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


@@ -152,7 +152,7 @@


                double HLossQty = list[0].HLossQty;//遗失数量


                double HBackWorkByMaterQty = list[0].HBackWorkByMaterQty;//遗失数量


                int HMouldID = list[0].HMouldID;//模具id




                double HMachineWorkTimes = list[0].HMachineWorkTimes;//设备工时


                LogService.Write($"1.字段赋值，用时" + sw.Elapsed );




                //单据完整性判断


@@ -413,7 +413,7 @@


                    ",HMainSourceInterID,HMainSourceBillNo,HMainSourceBillType,HLastSubProc" +


                    ",HEmpID2,HEmpID3,HEmpID4,HEmpID5,HDSQty,HChongQty,HPriceRate,HWorkTimes,HQCCheckID,HMainInterID,HPRDOrgID" +


                    ",HmaterOutqty,HProcPriceRate,HTemporaryAreaID,HWasterQty_Work,HWasterQty_Mater,HBackWorkQty,HShiftsID" +


                    ",HToCheckQty,HLossQty,HBackWorkByMaterQty,HMouldID" +


                    ",HToCheckQty,HLossQty,HBackWorkByMaterQty,HMouldID,HMachineWorkTimes " +


                    ") " +


                    " values('" + BillType + "','" + (OperationType == "5" ? "SUB" : HBillSubType)  + "'," + HInterID + ",'" + HBillNo + "'," + HBillStatus + ",'"+ HDate + "','" + HMaker + "',getdate(),'" + HMouldNum + "'" +


                    "," + HYear + "," + HPeriod + ",'" + HRemark + "','" + HSourceName + "'," + HPieceQty + "," + HWasterQty + "," + HPlanPieceQty + "," + HBadPNL +


@@ -424,7 +424,7 @@


                    "," + HMainSourceInterID + ",'" + HMainSourceBillNo + "','" + HMainSourceBillType + "'," + Convert.ToString(HLastSubProc ? 1 : 0) +


                    "," + HEmpID2 + "," + HEmpID3 + "," + HEmpID4 + "," + HEmpID5 + "," + HDSQty + "," + HChongQty + "," + HPriceRate + "," + HWorkTimes + "," + HQCCheckID + "," + HMainInterID + "," + HPRDOrgID +


                    "," + HmaterOutqty + "," + HProcPriceRate + "," + HTemporaryAreaID + "," + HWasterQty_Work + "," + HWasterQty_Mater + "," + HBackWorkQty +


                    "," + HShiftsID + "," + HToCheckQty + "," + HLossQty + ","+ HBackWorkByMaterQty + "," + HMouldID + ") ");


                    "," + HShiftsID + "," + HToCheckQty + "," + HLossQty + ","+ HBackWorkByMaterQty + "," + HMouldID + ",'" + HMachineWorkTimes + "') ");




                    LogService.Write($"4.新增结束，用时" + sw.Elapsed);


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


@@ -471,7 +471,7 @@


                    ",HShiftsID=" + HShiftsID +


                    ",HBackWorkByMaterQty=" + HBackWorkByMaterQty +


                    ",HMouldID=" + HMouldID +


                    ",HGroupID=" + HGroupID +


                    ",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


    }


}