智云MES后端API代码
blame | 历史 | 补丁 | 提交 | 提交对比 | ignore whitespace
duhe
2025-03-26 7eb2427db47b9cd9413a3ef51afd34658ed71c3d 
 WebAPI/Controllers/Sc_MouldRepairInBillListController.cs


@@ -9125,6 +9125,7 @@


            try


            {


                Log.LogInfo("成功！"); //记录提交数据


                List<object> columnNameList = new List<object>();




                //查看权限


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


@@ -9157,10 +9158,19 @@


                    ds = new SQLHelper.ClsCN().RunProcReturn(sql, "h_p_Sc_MouldProdBackBillList_Query");


                }




                //添加列名


                foreach (DataColumn col in ds.Tables[0].Columns)


                {


                    Type dataType = col.DataType;


                    string ColmString = "{\"ColmCols\":\"" + col.ColumnName + "\",\"ColmType\":\"" + dataType.Name + "\"}";


                    columnNameList.Add(JsonConvert.DeserializeObject(ColmString));//获取到DataColumn列对象的列名


                }




                objJsonResult.code = "1";


                objJsonResult.count = int.Parse(ds.Tables[1].Rows[0]["count"].ToString());


                objJsonResult.Message = "Sucess！";


                objJsonResult.data = ds.Tables[0];


                objJsonResult.list = columnNameList;


                return objJsonResult;


            }


            catch (Exception e)


@@ -9183,7 +9193,7 @@


                return new ApiResult<DataSet> { code = -1, msg = "ID不能为空" };


            SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();




            var dataSet = oCN.RunProcReturn("select top 1 * from h_v_Sc_MouldProdBackBillList  where hmainid= " + HID + " ", "h_v_Sc_MouldProdBackBillList");


            var dataSet = oCN.RunProcReturn("select top 1 * from h_v_Sc_MouldProdBackBill_Edit  where hmainid= " + HID + " ", "h_v_Sc_MouldProdBackBill_Edit");


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


                return new ApiResult<DataSet> { code = -1, msg = "不存在退库单号" };




@@ -9207,7 +9217,7 @@


                    ds = oCN.RunProcReturn(string.Format(@"SELECT HMaterID,模具代码 HMaterCode,模具名称 HMaterName,规格型号 HMaterSpec,批次 HBatchNo,


                                                设计寿命 HDesignLife, 剩余寿命 HLeaveLife, 累积使用寿命 HUseLife, 应发数量 HQtyMust, 实发数量 HQty, 


                                                单价 HPrice, 金额 HMoney,收料仓库ID HWHID, 收料仓库代码 HWHCode, 收料仓库 HWHName,HSPID, 


                                                仓位代码 HSPCode, 仓位 HSPName,表体备注 HRemark,HStockOrgID,HUnitID,计量单位代码 HUnitCode,计量单位 HUnitName FROM h_v_Sc_MouldProdBackBillList"), "h_v_Sc_MouldProdBackBillList");


                                                仓位代码 HSPCode, 仓位 HSPName,表体备注 HRemark,HStockOrgID,HUnitID,计量单位代码 HUnitCode,计量单位 HUnitName FROM h_v_Sc_MouldProdBackBill_Edit"), "h_v_Sc_MouldProdBackBill_Edit");




                }


                else


@@ -9217,15 +9227,15 @@


                    string sql1 = string.Format(@"SELECT HMaterID,模具代码 HMaterCode,模具名称 HMaterName,规格型号 HMaterSpec,批次 HBatchNo,


                                                设计寿命 HDesignLife, 剩余寿命 HLeaveLife, 累积使用寿命 HUseLife, 应发数量 HQtyMust, 实发数量 HQty, 


                                                单价 HPrice, 金额 HMoney,收料仓库ID HWHID, 收料仓库代码 HWHCode, 收料仓库 HWHName,HSPID, 


                                                仓位代码 HSPCode, 仓位 HSPName,表体备注 HRemark,HStockOrgID,HUnitID,计量单位代码 HUnitCode,计量单位 HUnitName FROM h_v_Sc_MouldProdBackBillList where 1 = 1 ");


                                                仓位代码 HSPCode, 仓位 HSPName,表体备注 HRemark,HStockOrgID,HUnitID,计量单位代码 HUnitCode,计量单位 HUnitName FROM h_v_Sc_MouldProdBackBill_Edit where 1 = 1 ");


                    string sql = sql1 + sqlWhere;


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


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




                }


                //查汇总


                ds1 = oCN.RunProcReturn(string.Format(@"select  物料代码,max(物料名称)物料名称,规格型号,max(单据号)单据号,批次,sum(实发数量)实发数量,


                                            收料仓库ID,max(收料仓库代码)收料仓库代码,max(收料仓库)收料仓库,表体备注 from h_v_Sc_MouldProdBackBillList 


                                            where 1=1 " + sqlWhere + " group by 物料代码,规格型号,收料仓库ID,批次,表体备注"), "h_v_Sc_MouldProdBackBillList");


                                            收料仓库ID,max(收料仓库代码)收料仓库代码,max(收料仓库)收料仓库,表体备注 from h_v_Sc_MouldProdBackBill_Edit 


                                            where 1=1 " + sqlWhere + " group by 物料代码,规格型号,收料仓库ID,批次,表体备注"), "h_v_Sc_MouldProdBackBill_Edit");




                list.Add(ds.Tables[0]);


                list.Add(ds1.Tables[0]);


@@ -9607,7 +9617,30 @@


                //    swhere = swhere + ds.Tables[0].Rows[i]["HMaterID"].ToString()+",";


                //}


                //swhere = swhere.Substring(0, swhere.Length - 1);


                bool IsDete = oBill.DeleteBill(oBill.omodel.HInterID, ref DBUtility.ClsPub.sExeReturnInfo);




                //删除前控制=========================================      


                string sql1 = "exec h_p_Sc_MouldProdBackBill_BeforeDelCtrl " + oBill.omodel.HInterID + ",'" + oBill.omodel.HBillNo + "','" + user + "'";


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


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


                {


                    objJsonResult.code = "0";


                    objJsonResult.count = 1;


                    objJsonResult.Message = "删除失败!原因:删除前判断失败，请与网络管理人员联系";


                    objJsonResult.data = null;


                    return objJsonResult;


                }




                if (ds.Tables[0].Rows[0]["HBack"].ToString() != "0")


                {


                    objJsonResult.code = "0";


                    objJsonResult.count = 1;


                    objJsonResult.Message = "删除失败!原因:" + ds.Tables[0].Rows[0]["HRemark"].ToString(); ;


                    objJsonResult.data = null;


                    return objJsonResult;


                }


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




                bool IsDete = oBill.DeleteBill(oBill.omodel.HInterID,oBill.omodel.HBillNo, "h_p_Sc_MouldProdBackBill_AfterDelCtrl",user, ref DBUtility.ClsPub.sExeReturnInfo);


                if (IsDete)


                {


                    //删除成功修改器具档案位置


@@ -9667,7 +9700,7 @@


                objJsonResult.data = null;


                return objJsonResult;


            }


            DLL.ClsSc_MouldProdOutBill oBill = new DLL.ClsSc_MouldProdOutBill();


            DLL.ClsSc_MouldProdBackBill oBill = new DLL.ClsSc_MouldProdBackBill();


            if (oBill.ShowBill(lngBillKey, ref DBUtility.ClsPub.sExeReturnInfo))


            {


                if (oBill.omodel.HCloseMan.Trim() != "")


@@ -9698,8 +9731,41 @@


                    }


                    else


                    {


                        string HCheckDate = DateTime.Now.Date.ToString();


                        oCn.RunProc(" Update Sc_MouldStockBillMain set HChecker='" + user + "',HCheckDate='" + HCheckDate + "',HBillStatus=2 Where HBillType='3803' and HInterID=" + HInterID);


                        //审核前控制=========================================      


                        string sql1 = "exec h_p_Sc_MouldProdBackBill_BeforeCheckCtrl " + oBill.omodel.HInterID + ",'" + oBill.omodel.HBillNo + "','" + user + "'";


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


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


                        {


                            objJsonResult.code = "0";


                            objJsonResult.count = 1;


                            objJsonResult.Message = "审核失败!原因:审核前判断失败，请与网络管理人员联系";


                            objJsonResult.data = null;


                            oCN.RollBack();


                            return objJsonResult;


                        }




                        if (ds.Tables[0].Rows[0]["HBack"].ToString() != "0")


                        {


                            objJsonResult.code = "0";


                            objJsonResult.count = 1;


                            objJsonResult.Message = "审核失败!原因:" + ds.Tables[0].Rows[0]["HRemark"].ToString(); ;


                            objJsonResult.data = null;


                            oCN.RollBack();


                            return objJsonResult;


                        }


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




                        if (!oBill.CheckBill(int.Parse(HInterID), oBill.omodel.HBillNo, "h_p_Sc_MouldProdBackBill_AfterCheckCtrl", user, ref ClsPub.sExeReturnInfo))


                        {


                            objJsonResult.code = "0";


                            objJsonResult.count = 1;


                            objJsonResult.Message = "审核失败!原因:" + ClsPub.sExeReturnInfo;


                            objJsonResult.data = null;


                            return objJsonResult;


                        }




                        //string HCheckDate = DateTime.Now.Date.ToString();


                        //oCn.RunProc(" Update Sc_MouldStockBillMain set HChecker='" + user + "',HCheckDate='" + HCheckDate + "',HBillStatus=2 Where HBillType='3803' and HInterID=" + HInterID);


                        objJsonResult.code = "0";


                        objJsonResult.count = 1;


                        objJsonResult.Message = "审核成功！";


@@ -9719,8 +9785,39 @@


                    }


                    else


                    {


                        string HCheckDate = DateTime.Now.Date.ToString();


                        oCn.RunProc(" Update Sc_MouldStockBillMain set HChecker=' ',HCheckDate=' ',HBillStatus=1 Where HBillType='3803' and HInterID=" + HInterID);


                        //反审核前控制=========================================        


                        string sql1 = "exec h_p_Sc_MouldProdBackBill_BeforeUnCheckCtrl " + oBill.omodel.HInterID + ",'" + oBill.omodel.HBillNo + "','" + user + "'";


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


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


                        {


                            objJsonResult.code = "0";


                            objJsonResult.count = 1;


                            objJsonResult.Message = "反审核失败!原因:反审核前判断失败，请与网络管理人员联系";


                            objJsonResult.data = null;


                            return objJsonResult;




                        }


                        if (ds.Tables[0].Rows[0]["HBack"].ToString() != "0")


                        {


                            objJsonResult.code = "0";


                            objJsonResult.count = 1;


                            objJsonResult.Message = "反审核失败!原因:" + ds.Tables[0].Rows[0]["HRemark"].ToString(); ;


                            objJsonResult.data = null;


                            return objJsonResult;


                        }


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




                        if (!oBill.AbandonCheck(int.Parse(HInterID), oBill.omodel.HBillNo, "h_p_Sc_MouldProdBackBill_AfterUnCheckCtrl", user, ref ClsPub.sExeReturnInfo))


                        {


                            objJsonResult.code = "0";


                            objJsonResult.count = 1;


                            objJsonResult.Message = "审核失败!原因:" + ClsPub.sExeReturnInfo;


                            objJsonResult.data = null;


                            return objJsonResult;


                        }




                        //string HCheckDate = DateTime.Now.Date.ToString();


                        //oCn.RunProc(" Update Sc_MouldStockBillMain set HChecker=' ',HCheckDate=' ',HBillStatus=1 Where HBillType='3803' and HInterID=" + HInterID);


                        objJsonResult.code = "0";


                        objJsonResult.count = 1;


                        objJsonResult.Message = "反审核成功！";


@@ -9835,8 +9932,31 @@


                //进行需要进行的关闭/反关闭操作


                if (IsAudit == 0) //关闭提交


                {


                    string sql = "";


                    //关闭前控制===============================================Begin===================================================================


                    sql = "exec h_p_Sc_MouldProdBackBill_BeforeCloseCtrl " + HInterID + ",'" + oBill.omodel.HBillNo + "','" + CurUserName + "'";


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


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


                    {


                        objJsonResult.code = "0";


                        objJsonResult.count = 0;


                        objJsonResult.Message = "关闭失败!原因:关闭前前判断失败，无返回信息，请与网络管理人员联系";


                        objJsonResult.data = null;


                        return objJsonResult;




                    }


                    if (ds.Tables[0].Rows[0]["HBack"].ToString() != "0")


                    {


                        objJsonResult.code = "0";


                        objJsonResult.count = 0;


                        objJsonResult.Message = "关闭失败!原因:" + ds.Tables[0].Rows[0]["HRemark"].ToString(); ;


                        objJsonResult.data = null;


                        return objJsonResult;


                    }


                    //关闭前控制===============================================End===================================================================




                    //关闭提交


                    if (oBill.CloseBill(lngBillKey, ref DBUtility.ClsPub.sExeReturnInfo) == true)


                    if (oBill.CloseBill(lngBillKey, oBill.omodel.HBillNo, "h_p_Sc_MouldProdBackBill_AfterCloseCtrl", CurUserName, ref DBUtility.ClsPub.sExeReturnInfo) == true)


                    {


                        objJsonResult.code = "1";


                        objJsonResult.count = 1;


@@ -9855,8 +9975,31 @@


                }


                if (IsAudit == 1) //反关闭提交


                {


                    string sql = "";


                    //反关闭前控制===============================================Begin===================================================================


                    sql = "exec h_p_Sc_MouldProdBackBill_BeforeUnCloseCtrl " + HInterID + ",'" + oBill.omodel.HBillNo + "','" + CurUserName + "'";


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


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


                    {


                        objJsonResult.code = "0";


                        objJsonResult.count = 0;


                        objJsonResult.Message = "反关闭失败!原因:反关闭前前判断失败，无返回信息，请与网络管理人员联系";


                        objJsonResult.data = null;


                        return objJsonResult;




                    }


                    if (ds.Tables[0].Rows[0]["HBack"].ToString() != "0")


                    {


                        objJsonResult.code = "0";


                        objJsonResult.count = 0;


                        objJsonResult.Message = "反关闭失败!原因:" + ds.Tables[0].Rows[0]["HRemark"].ToString(); ;


                        objJsonResult.data = null;


                        return objJsonResult;


                    }


                    //反关闭前控制===============================================End===================================================================




                    //反关闭提交


                    if (oBill.CancelClose(lngBillKey, ref DBUtility.ClsPub.sExeReturnInfo) == true)


                    if (oBill.CancelClose(lngBillKey, oBill.omodel.HBillNo, "h_p_Sc_MouldProdBackBill_AfterUnCloseCtrl", CurUserName, ref DBUtility.ClsPub.sExeReturnInfo) == true)


                    {


                        objJsonResult.code = "1";


                        objJsonResult.count = 1;


@@ -9956,6 +10099,7 @@


        {


            try


            {


                List<object> columnNameList = new List<object>();


                //查看权限


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


                {


@@ -9984,10 +10128,19 @@


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


                }




                //添加列名


                foreach (DataColumn col in ds.Tables[0].Columns)


                {


                    Type dataType = col.DataType;


                    string ColmString = "{\"ColmCols\":\"" + col.ColumnName + "\",\"ColmType\":\"" + dataType.Name + "\"}";


                    columnNameList.Add(JsonConvert.DeserializeObject(ColmString));//获取到DataColumn列对象的列名


                }




                objJsonResult.code = "1";


                objJsonResult.count = int.Parse(ds.Tables[1].Rows[0]["count"].ToString());


                objJsonResult.Message = "Sucess！";


                objJsonResult.data = ds.Tables[0];


                objJsonResult.list = columnNameList;


                return objJsonResult;


            }


            catch (Exception e)


@@ -10010,7 +10163,7 @@


                return new ApiResult<DataSet> { code = -1, msg = "ID不能为空" };


            SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();




            var dataSet = oCN.RunProcReturn("select top 1 * from h_v_Sc_MouldProdOutHouseBillList  where hmainid= " + HID + " ", "h_v_Sc_MouldProdOutHouseBillList");


            var dataSet = oCN.RunProcReturn("select top 1 * from h_v_Sc_MouldProdOutHouseBill_Edit  where hmainid= " + HID + " ", "h_v_Sc_MouldProdOutHouseBill_Edit");


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


                return new ApiResult<DataSet> { code = -1, msg = "不存在退库单号" };




@@ -10034,7 +10187,7 @@


                    ds = oCN.RunProcReturn(string.Format(@"SELECT HMaterID,模具代码 HMaterCode,模具名称 HMaterName,规格型号 HMaterSpec,批次 HBatchNo,


                                                设计寿命 HDesignLife, 剩余寿命 HLeaveLife, 累积使用寿命 HUseLife, 应发数量 HQtyMust, 实发数量 HQty, 


                                                单价 HPrice, 金额 HMoney,HWHSonID HWHID, 发料仓库代码 HWHCode, 发料仓库 HWHName,HSPID, 


                                                仓位代码 HSPCode, 仓位 HSPName,表体备注 HRemark,HStockOrgID,HUnitID,计量单位代码 HUnitCode,计量单位 HUnitName FROM h_v_Sc_MouldProdOutHouseBillList"), "h_v_Sc_MouldProdOutHouseBillList");


                                                仓位代码 HSPCode, 仓位 HSPName,表体备注 HRemark,HStockOrgID,HUnitID,计量单位代码 HUnitCode,计量单位 HUnitName FROM h_v_Sc_MouldProdOutHouseBill_Edit"), "h_v_Sc_MouldProdOutHouseBill_Edit");




                }


                else


@@ -10044,14 +10197,14 @@


                    string sql1 = string.Format(@"SELECT HMaterID,模具代码 HMaterCode,模具名称 HMaterName,规格型号 HMaterSpec,批次 HBatchNo,


                                                设计寿命 HDesignLife, 剩余寿命 HLeaveLife, 累积使用寿命 HUseLife, 应发数量 HQtyMust, 实发数量 HQty, 


                                                单价 HPrice, 金额 HMoney,HWHSonID HWHID, 发料仓库代码 HWHCode, 发料仓库 HWHName,HSPID, 


                                                仓位代码 HSPCode, 仓位 HSPName,表体备注 HRemark,HStockOrgID,HUnitID,计量单位代码 HUnitCode,计量单位 HUnitName FROM h_v_Sc_MouldProdOutHouseBillList where 1 = 1 ");


                                                仓位代码 HSPCode, 仓位 HSPName,表体备注 HRemark,HStockOrgID,HUnitID,计量单位代码 HUnitCode,计量单位 HUnitName FROM h_v_Sc_MouldProdOutHouseBill_Edit where 1 = 1 ");


                    string sql = sql1 + sqlWhere;


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


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


                }


                //查汇总


                ds1 = oCN.RunProcReturn(string.Format(@"select  物料代码,max(物料名称)物料名称,规格型号,max(单据号)单据号,批次,sum(实发数量)实发数量,


                                            HWHSonID,max(发料仓库代码)发料仓库代码,max(发料仓库)发料仓库,表体备注 from h_v_Sc_MouldProdOutHouseBillList 


                                            where 1=1 " + sqlWhere + " group by 物料代码,规格型号,HWHSonID,批次,表体备注"), "h_v_Sc_MouldProdOutHouseBillList");


                                            HWHSonID,max(发料仓库代码)发料仓库代码,max(发料仓库)发料仓库,表体备注 from h_v_Sc_MouldProdOutHouseBill_Edit 


                                            where 1=1 " + sqlWhere + " group by 物料代码,规格型号,HWHSonID,批次,表体备注"), "h_v_Sc_MouldProdOutHouseBill_Edit");




                list.Add(ds.Tables[0]);


                list.Add(ds1.Tables[0]);


@@ -10469,7 +10622,31 @@


                //    swhere = swhere + ds.Tables[0].Rows[i]["HMaterID"].ToString() + ",";


                //}


                //swhere = swhere.Substring(0, swhere.Length - 1);


                bool IsDete = oBill.DeleteBill(oBill.omodel.HInterID, ref DBUtility.ClsPub.sExeReturnInfo);




                //删除前控制=========================================      


                string sql1 = "exec h_p_Sc_MouldProdOutBill_BeforeDelCtrl " + BillOld.omodel.HInterID + ",'" + BillOld.omodel.HBillNo + "','" + user + "'";


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


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


                {


                    objJsonResult.code = "0";


                    objJsonResult.count = 1;


                    objJsonResult.Message = "删除失败!原因:删除前判断失败，请与网络管理人员联系";


                    objJsonResult.data = null;


                    return objJsonResult;


                }




                if (ds.Tables[0].Rows[0]["HBack"].ToString() != "0")


                {


                    objJsonResult.code = "0";


                    objJsonResult.count = 1;


                    objJsonResult.Message = "删除失败!原因:" + ds.Tables[0].Rows[0]["HRemark"].ToString(); ;


                    objJsonResult.data = null;


                    return objJsonResult;


                }


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




                bool IsDete = oBill.DeleteBill(oBill.omodel.HInterID,oBill.omodel.HBillNo, "h_p_Sc_MouldProdOutBill_AfterDelCtrl",user, ref DBUtility.ClsPub.sExeReturnInfo);




                if (IsDete)


                {


                    //删除成功修改器具档案位置


@@ -10567,8 +10744,56 @@


                    }


                    else


                    {


                        //审核前控制=========================================      


                        string sql1 = "exec h_p_Sc_MouldProdOutBill_BeforeCheckCtrl " + oBill.omodel.HInterID + ",'" + oBill.omodel.HBillNo + "','" + user + "'";


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


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


                        {


                            objJsonResult.code = "0";


                            objJsonResult.count = 1;


                            objJsonResult.Message = "审核失败!原因:审核前判断失败，请与网络管理人员联系";


                            objJsonResult.data = null;


                            oCN.RollBack();


                            return objJsonResult;


                        }




                        if (ds.Tables[0].Rows[0]["HBack"].ToString() != "0")


                        {


                            objJsonResult.code = "0";


                            objJsonResult.count = 1;


                            objJsonResult.Message = "审核失败!原因:" + ds.Tables[0].Rows[0]["HRemark"].ToString(); ;


                            objJsonResult.data = null;


                            oCN.RollBack();


                            return objJsonResult;


                        }


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




                        string HCheckDate = DateTime.Now.Date.ToString();


                        oCn.RunProc(" Update Sc_MouldStockBillMain set HChecker='" + user + "',HCheckDate='" + HCheckDate + "',HBillStatus=2 Where HBillType='3802' and HInterID=" + HInterID);




                        //审核后控制=========================================      


                        string sql2 = "exec h_p_Sc_MouldProdOutBill_AfterCheckCtrl " + oBill.omodel.HInterID + ",'" + oBill.omodel.HBillNo + "','" + user + "'";


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


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


                        {


                            objJsonResult.code = "0";


                            objJsonResult.count = 1;


                            objJsonResult.Message = "审核失败!原因:审核后判断失败，请与网络管理人员联系";


                            objJsonResult.data = null;


                            oCN.RollBack();


                            return objJsonResult;


                        }




                        if (ds.Tables[0].Rows[0]["HBack"].ToString() != "0")


                        {


                            objJsonResult.code = "0";


                            objJsonResult.count = 1;


                            objJsonResult.Message = "审核失败!原因:" + ds.Tables[0].Rows[0]["HRemark"].ToString(); ;


                            objJsonResult.data = null;


                            oCN.RollBack();


                            return objJsonResult;


                        }


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


                        objJsonResult.code = "0";


                        objJsonResult.count = 1;


                        objJsonResult.Message = "审核成功！";


@@ -10588,8 +10813,53 @@


                    }


                    else


                    {


                        //反审核前控制=========================================        


                        string sql1 = "exec h_p_Sc_MouldProdOutBill_BeforeUnCheckCtrl " + oBill.omodel.HInterID + ",'" + oBill.omodel.HBillNo + "','" + user + "'";


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


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


                        {


                            objJsonResult.code = "0";


                            objJsonResult.count = 1;


                            objJsonResult.Message = "反审核失败!原因:反审核前判断失败，请与网络管理人员联系";


                            objJsonResult.data = null;


                            return objJsonResult;




                        }


                        if (ds.Tables[0].Rows[0]["HBack"].ToString() != "0")


                        {


                            objJsonResult.code = "0";


                            objJsonResult.count = 1;


                            objJsonResult.Message = "反审核失败!原因:" + ds.Tables[0].Rows[0]["HRemark"].ToString(); ;


                            objJsonResult.data = null;


                            return objJsonResult;


                        }


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




                        string HCheckDate = DateTime.Now.Date.ToString();


                        oCn.RunProc(" Update Sc_MouldStockBillMain set HChecker=' ',HCheckDate=' ',HBillStatus=1 Where HBillType='3802' and HInterID=" + HInterID);




                        //反审核前控制=========================================        


                        string sql2 = "exec h_p_Sc_MouldProdOutBill_AfterUnCheckCtrl " + oBill.omodel.HInterID + ",'" + oBill.omodel.HBillNo + "','" + user + "'";


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


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


                        {


                            objJsonResult.code = "0";


                            objJsonResult.count = 1;


                            objJsonResult.Message = "反审核失败!原因:反审核后判断失败，请与网络管理人员联系";


                            objJsonResult.data = null;


                            return objJsonResult;




                        }


                        if (ds.Tables[0].Rows[0]["HBack"].ToString() != "0")


                        {


                            objJsonResult.code = "0";


                            objJsonResult.count = 1;


                            objJsonResult.Message = "反审核失败!原因:" + ds.Tables[0].Rows[0]["HRemark"].ToString(); ;


                            objJsonResult.data = null;


                            return objJsonResult;


                        }


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




                        objJsonResult.code = "0";


                        objJsonResult.count = 1;


                        objJsonResult.Message = "反审核成功！";


@@ -10704,8 +10974,31 @@


                //进行需要进行的关闭/反关闭操作


                if (IsAudit == 0) //关闭提交


                {


                    string sql = "";


                    //关闭前控制===============================================Begin===================================================================


                    sql = "exec h_p_Sc_MouldProdOutBill_BeforeCloseCtrl " + HInterID + ",'" + oBill.omodel.HBillNo + "','" + CurUserName + "'";


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


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


                    {


                        objJsonResult.code = "0";


                        objJsonResult.count = 0;


                        objJsonResult.Message = "关闭失败!原因:关闭前前判断失败，无返回信息，请与网络管理人员联系";


                        objJsonResult.data = null;


                        return objJsonResult;




                    }


                    if (ds.Tables[0].Rows[0]["HBack"].ToString() != "0")


                    {


                        objJsonResult.code = "0";


                        objJsonResult.count = 0;


                        objJsonResult.Message = "关闭失败!原因:" + ds.Tables[0].Rows[0]["HRemark"].ToString(); ;


                        objJsonResult.data = null;


                        return objJsonResult;


                    }


                    //关闭前控制===============================================End===================================================================




                    //关闭提交


                    if (oBill.CloseBill(lngBillKey, ref DBUtility.ClsPub.sExeReturnInfo) == true)


                    if (oBill.CloseBill(lngBillKey,oBill.omodel.HBillNo, "h_p_Sc_MouldProdOutBill_AfterCloseCtrl", CurUserName, ref DBUtility.ClsPub.sExeReturnInfo) == true)


                    {


                        objJsonResult.code = "1";


                        objJsonResult.count = 1;


@@ -10724,8 +11017,31 @@


                }


                if (IsAudit == 1) //反关闭提交


                {


                    string sql = "";


                    //反关闭前控制===============================================Begin===================================================================


                    sql = "exec h_p_Sc_MouldProdOutBill_BeforeUnCloseCtrl " + HInterID + ",'" + oBill.omodel.HBillNo + "','" + CurUserName + "'";


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


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


                    {


                        objJsonResult.code = "0";


                        objJsonResult.count = 0;


                        objJsonResult.Message = "反关闭失败!原因:反关闭前前判断失败，无返回信息，请与网络管理人员联系";


                        objJsonResult.data = null;


                        return objJsonResult;




                    }


                    if (ds.Tables[0].Rows[0]["HBack"].ToString() != "0")


                    {


                        objJsonResult.code = "0";


                        objJsonResult.count = 0;


                        objJsonResult.Message = "反关闭失败!原因:" + ds.Tables[0].Rows[0]["HRemark"].ToString(); ;


                        objJsonResult.data = null;


                        return objJsonResult;


                    }


                    //反关闭前控制===============================================End===================================================================




                    //反关闭提交


                    if (oBill.CancelClose(lngBillKey, ref DBUtility.ClsPub.sExeReturnInfo) == true)


                    if (oBill.CancelClose(lngBillKey,oBill.omodel.HBillNo, "h_p_Sc_MouldProdOutBill_AfterUnCloseCtrl", CurUserName, ref DBUtility.ClsPub.sExeReturnInfo) == true)


                    {


                        objJsonResult.code = "1";


                        objJsonResult.count = 1;


@@ -10823,6 +11139,61 @@




        #endregion




        #region 器具寿命调整单分页列表


        [Route("Sc_MouldLifeChangeBill/page")]


        [HttpGet]


        public object Sc_MouldLifeChangeBillPage(string sWhere, string user, int page, int size)


        {


            DataSet ds;


            try


            {


                List<object> columnNameList = new List<object>();


                //权限


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


                {


                    objJsonResult.code = "0";


                    objJsonResult.count = 0;


                    objJsonResult.Message = "无查看权限！";


                    objJsonResult.data = null;


                    return objJsonResult;


                }




                sWhere = sWhere.Replace("'", "''");


                if (sWhere == null || sWhere.Equals(""))


                {


                    ds = oCn.RunProcReturn("exec h_p_Sc_MouldLifeChangeBillList_Query " + page + "," + size + ",''", "h_p_Sc_MouldLifeChangeBillList_Query");


                }


                else


                {


                    ds = oCn.RunProcReturn("exec h_p_Sc_MouldLifeChangeBillList_Query " + page + "," + size + ",'" + sWhere + "'", "h_p_Sc_MouldLifeChangeBillList_Query");


                }




                //添加列名


                foreach (DataColumn col in ds.Tables[0].Columns)


                {


                    Type dataType = col.DataType;


                    string ColmString = "{\"ColmCols\":\"" + col.ColumnName + "\",\"ColmType\":\"" + dataType.Name + "\"}";


                    columnNameList.Add(JsonConvert.DeserializeObject(ColmString));//获取到DataColumn列对象的列名


                }




                objJsonResult.code = CodeConstant.SUCCEED;


                objJsonResult.count = int.Parse(ds.Tables[1].Rows[0]["count"].ToString());


                objJsonResult.Message = "Sucess！";


                objJsonResult.list = columnNameList;


                objJsonResult.data = ds.Tables[0];


                return objJsonResult;


            }


            catch (Exception e)


            {


                objJsonResult.code = CodeConstant.FAIL;


                objJsonResult.count = CountConstant.FAIL;


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


                objJsonResult.data = null;


                return objJsonResult;


            }


        }


        #endregion




        #region[模具寿命调整单编辑时获取表头数据]


        [Route("Sc_MouldLifeChangeBill/Sc_GetMouldLifeChangeBillListCheckDetai")]


        [HttpGet]