智云MES后端API代码
blame | 历史 | 补丁 | 提交 | 提交对比 | ignore whitespace
wtt
2024-12-20 fd2d833bf010d0be1bb308d9c431eee1dfd931ff 
 WebAPI/Controllers/CJGL/Cj_StationOutBillController.cs


@@ -451,6 +451,7 @@


                    ",HSourceID5=" + HSourceID5 +


                    ",HPayProcID=" + HPayProcID +


                    ",HGroupID=" + HGroupID +


                    ",HShiftsID=" + HShiftsID +


                    ",HWorkTimes=" + HWorkTimes +


                    ",HSaveBillFlag=0 " +


                    ",HBadCount=" + HBadCount +


@@ -468,10 +469,9 @@


                    ",HWasterQty_Work=" + HWasterQty_Work +


                    ",HWasterQty_Mater=" + HWasterQty_Mater +


                    ",HBackWorkQty=" + HBackWorkQty +


                    ",HShiftsID=" + HShiftsID +


                    ",HBackWorkByMaterQty=" + HBackWorkByMaterQty +


                    ",HMouldID=" + HMouldID +


                    ",HMachineWorkTimes=" + HMachineWorkTimes +


                    ",HMachineWorkTimes=" + HMachineWorkTimes +  


                    " where HInterID=" + HInterID);




                    LogService.Write("用户:" + user + ",日期:" + DateTime.Now + ",修改工序出站单据:" + HBillNo);


@@ -628,6 +628,27 @@


                sw.Stop();//结束计时


                LogService.Write($"11.参数查询结束,新增结束，用时" + sw.Elapsed);


                LogService.Write("END--出站单据保存结束，出站单号：" + HBillNo);




                //测试语句===========================================================================================================


                string msg_str = "";


                string sql_str = "select a.HQty HQty_Main,b.HQty HQty_Sub " +


                            "from Sc_ProcessExchangeBillMain as a " +


                            "inner join Sc_ProcessExchangeBillSub as b on a.HInterID = b.HInterID " +


                            "where a.HInterID = " + HProcExchInterID;


                DataSet ds_str = oCN.RunProcReturn(sql_str, "Sc_ProcessExchangeBillMain");


                if (ds_str.Tables[0].Rows.Count > 0)


                {


                    msg_str = "HQty_Main:" + ds_str.Tables[0].Rows[0]["HQty_Main"].ToString() + ";HQty_Sub:";


                    for (int j = 0; j < ds_str.Tables[0].Rows.Count; j++)


                    {


                        msg_str += ds_str.Tables[0].Rows[j]["HQty_Sub"].ToString() + ",";


                    }


                }




                oCN.RunProc("Insert into System_log (GeginDate, userid, WorkstationName, WorkList, SystemName, NetuserName, State) select GETDATE(),'" + user + "','" + HComputerName + "','" + "修改工序出站单据：" + HBillNo + "[工序流转卡号：" + HProcExchBillNo + "]" + msg_str + "','LMES-工序出站模块','" + DBUtility.ClsPub.IPAddress + "','新增或修改单据'", ref DBUtility.ClsPub.sExeReturnInfo);


                //==============================================================================================================






                objJsonResult.code = "1";


                objJsonResult.count = 1;


                objJsonResult.Message = "新增单据成功！";


@@ -1929,7 +1950,7 @@


            string HRemark = HttpContext.Current.Request.Params["HRemark"];  //备注


            string HUserName = HttpContext.Current.Request.Params["HUserName"];  //创建人


            HttpPostedFile files = HttpContext.Current.Request.Files["file"];


            string path = HttpContext.Current.Server.MapPath("~/../Files/" + HBillNo);


            string path = HttpContext.Current.Server.MapPath("~/../Files/Cj_StationOutBill/" + HBillNo);


            //string path = @"D:\\Files\\"+ HBillNo;


            dynamic dyResult = UpLoadFile(files, path, HBillNo, HRemark, HUserName);


            if (dyResult != null && dyResult.result == 1)


@@ -1985,7 +2006,7 @@


                {


                    File.Delete(fileurl);      //删除指定文件


                    files.SaveAs(fileurl);


                    string StrPath = "/files/"+ HBillNo+"/"+ filename;


                    string StrPath = "/files/Cj_StationOutBill/" + HBillNo+"/"+ filename;


                    if (File.Exists(fileurl)) 


                    {


                        //这里可以执行一些其它的操作，比如更新数据库


@@ -2008,7 +2029,7 @@


                {


                    Directory.CreateDirectory(fileSavePath); //添加文件夹


                    files.SaveAs(fileurl);


                    string StrPath = "/files/" + HBillNo + "/" + filename;


                    string StrPath = "/files/Cj_StationOutBill/" + HBillNo + "/" + filename;


                    if (File.Exists(fileurl))


                    {


                        //这里可以执行一些其它的操作，比如更新数据库


@@ -2049,7 +2070,7 @@


            string HRemark = HttpContext.Current.Request.Params["HRemark"];  //备注


            string HUserName = HttpContext.Current.Request.Params["HUserName"];  //创建人


            HttpPostedFile files = HttpContext.Current.Request.Files["file"];


            string path = HttpContext.Current.Server.MapPath("~/../Files/" + HBillNo);


            string path = HttpContext.Current.Server.MapPath("~/../Files/Cj_StationOutBill/" + HBillNo);


            //string path = @"D:\\Files\\"+ HBillNo;


            dynamic dyResult = UpLoadFile1(files, path, HBillNo, HRemark, HUserName);


            if (dyResult != null && dyResult.result == 1)


@@ -2105,7 +2126,7 @@


                {


                    File.Delete(fileurl);      //删除指定文件


                    files.SaveAs(fileurl);


                    string StrPath = "/files/" + HBillNo + "/" + filename;


                    string StrPath = "/files/Cj_StationOutBill/" + HBillNo + "/" + filename;


                    if (File.Exists(fileurl))


                    {


                        //这里可以执行一些其它的操作，比如更新数据库


@@ -2128,7 +2149,7 @@


                {


                    Directory.CreateDirectory(fileSavePath); //添加文件夹


                    files.SaveAs(fileurl);


                    string StrPath = "/files/" + HBillNo + "/" + filename;


                    string StrPath = "/files/Cj_StationOutBill/" + HBillNo + "/" + filename;


                    if (File.Exists(fileurl))


                    {


                        //这里可以执行一些其它的操作，比如更新数据库


@@ -2178,7 +2199,7 @@


        [HttpGet]


        public object Filelist(string HBillNo)


        {


            var url = fileip + "/files/" + HBillNo+"/";


            var url = fileip + "/files/Cj_StationOutBill/" + HBillNo+"/";


            //@"C:\\files\\"


            try


            {


@@ -2213,7 +2234,7 @@


            {




                oCN.RunProc("delete from MES_AccessoriesList where HItemID =" + HItemID);


                string fileurl = Path.Combine(HttpContext.Current.Server.MapPath("~/../Files/" + HSourceBillNo), HFileName);


                string fileurl = Path.Combine(HttpContext.Current.Server.MapPath("~/../Files/Cj_StationOutBill/" + HSourceBillNo), HFileName);


                File.Delete(fileurl);      //删除指定文件


                objJsonResult.code = "1";


                objJsonResult.count = 1;


@@ -3955,5 +3976,95 @@


            }


        }


        #endregion




        #region 编辑页面根据id获取工序出站汇报单信息


        [Route("Cj_StationOutBill/SetBillTime")]


        [HttpGet]


        public object SetBillTime(int HInterID,DateTime dateTime,string user)


        {


            try


            {


                //判断是否有编辑权限


                if (!DBUtility.ClsPub.Security_Log("Cj_StationOutBill_Edit", 1, false, user))


                {


                    objJsonResult.code = "0";


                    objJsonResult.count = 0;


                    objJsonResult.Message = "出站单无编辑权限!";


                    objJsonResult.data = null;


                    return objJsonResult;


                }


                string sql = "select * from Sc_StationOutBillMain  with(nolock) where HInterID=" + HInterID;


                ds = oCN.RunProcReturn(sql, "Sc_StationOutBillMain");


                if (ds == null || ds.Tables[0].Rows.Count == 0)


                {


                    objJsonResult.code = "0";


                    objJsonResult.count = 0;


                    objJsonResult.Message = "修改失败没找到相关出站汇报单";


                    objJsonResult.data = null;


                    return objJsonResult;


                }


                //修改前时间修改后时间判断有无工资计算


                string HGroupID = ds.Tables[0].Rows[0]["HGroupID"].ToString();


                string HOldDate = ds.Tables[0].Rows[0]["HDate"].ToString();


                string sql1 = "select * from Pay_SingleBalBillMain where HGroupID =" +HGroupID + " and HDate ='" + HOldDate + "'";


                string sql2 = "select * from Pay_GroupBalBillMain where HGroupID =" + HGroupID + " and HDate ='" + HOldDate + "'";


                string sql3 = "select * from Pay_SingleBalBillMain where HGroupID =" + HGroupID + " and HDate ='" + dateTime + "'";


                string sql4 = "select * from Pay_GroupBalBillMain where HGroupID =" + HGroupID + " and HDate ='" + dateTime + "'";


                ds = oCN.RunProcReturn(sql1, "Sc_StationOutBillMain");


                if (ds.Tables[0].Rows.Count > 0)


                {


                    objJsonResult.code = "0";


                    objJsonResult.count = 0;


                    objJsonResult.Message = "修改失败该时间班组已计算工资:" + HOldDate;


                    objJsonResult.data = null;


                    return objJsonResult;


                }


                ds = oCN.RunProcReturn(sql2, "Sc_StationOutBillMain");


                if (ds.Tables[0].Rows.Count > 0)


                {


                    objJsonResult.code = "0";


                    objJsonResult.count = 0;


                    objJsonResult.Message = "修改失败该时间班组已计算工资:" + HOldDate;


                    objJsonResult.data = null;


                    return objJsonResult;


                }


                ds = oCN.RunProcReturn(sql3, "Sc_StationOutBillMain");


                if (ds.Tables[0].Rows.Count > 0)


                {


                    objJsonResult.code = "0";


                    objJsonResult.count = 0;


                    objJsonResult.Message = "修改失败该时间班组已计算工资:" + dateTime;


                    objJsonResult.data = null;


                    return objJsonResult;


                }


                ds = oCN.RunProcReturn(sql4, "Sc_StationOutBillMain");


                if (ds.Tables[0].Rows.Count > 0)


                {


                    objJsonResult.code = "0";


                    objJsonResult.count = 0;


                    objJsonResult.Message = "修改失败该时间班组已计算工资:" + dateTime;


                    objJsonResult.data = null;


                    return objJsonResult;


                }


                //修改时间


                sql = "update Sc_StationOutBillMain set HDate = '" + dateTime + "' where HInterID = " + HInterID;


                oCN.RunProcReturn(sql, "Sc_StationOutBillMain");


                objJsonResult.code = "1";


                objJsonResult.count = 1;


                objJsonResult.Message = "Sucess！";


                objJsonResult.data = null;


                return objJsonResult;


               


            }


            catch (Exception e)


            {


                objJsonResult.code = "0";


                objJsonResult.count = 0;


                objJsonResult.Message = "Exception！" + e.ToString();


                objJsonResult.data = null;


                return objJsonResult;


            }


        }


        #endregion


    }


}