智云MES后端API代码
blame | 历史 | 补丁 | 提交 | 提交对比 | ignore whitespace
1
wtt
2024-12-20 a068a3a556b437470e2aeaa87e607c3a5de8c647 
 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,6 +471,7 @@


                    ",HShiftsID=" + HShiftsID +


                    ",HBackWorkByMaterQty=" + HBackWorkByMaterQty +


                    ",HMouldID=" + HMouldID +


                    ",HMachineWorkTimes=" + HMachineWorkTimes +


                    " where HInterID=" + HInterID);




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


@@ -1949,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)


@@ -2005,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)) 


                    {


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


@@ -2028,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))


                    {


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


@@ -2069,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)


@@ -2125,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))


                    {


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


@@ -2148,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))


                    {


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


@@ -2198,7 +2199,7 @@


        [HttpGet]


        public object Filelist(string HBillNo)


        {


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


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


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


            try


            {


@@ -2233,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;


@@ -3975,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


    }


}