智云MES后端API代码
blame | 历史 | 补丁 | 提交 | 提交对比 | ignore whitespace
wtt
2025-05-16 9124a9b2e9f4a041da4509039c65a70cc81dd033 
 WebAPI/Controllers/MJGL/Sc_MouldUpperBillController.cs


@@ -9,6 +9,7 @@


using Newtonsoft.Json;


using Model;


using DBUtility;


using SyntacticSugar.constant;




namespace WebAPI.Controllers.MJGL


{


@@ -39,7 +40,7 @@


                    return objJsonResult;


                }




                ds = oCN.RunProcReturn("select * from  h_v_Qj_Sc_MouldUpperBillList where 1=1" + sWhere + "order by hmainid desc ", "h_v_Qj_Sc_MouldUpperBillList");


                ds = oCN.RunProcReturn("select * from  h_v_Qj_Sc_MouldUpperBill_Edit where 1=1" + sWhere + "order by hmainid desc ", "h_v_Qj_Sc_MouldUpperBill_Edit");




                //添加列名


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


@@ -61,6 +62,55 @@


                objJsonResult.code = "0";


                objJsonResult.count = 0;


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


                objJsonResult.data = null;


                return objJsonResult;


            }


        }


        #endregion




        #region 上模单 列表分页查询


        [Route("Sc_MouldUpperBill/Sc_MouldUpperBillListPage")]


        [HttpGet]


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


        {


            try


            {


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




                //查看权限


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


                {


                    objJsonResult.code = "0";


                    objJsonResult.count = 0;


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


                    objJsonResult.data = null;


                    return objJsonResult;


                }




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


                ds = oCN.RunProcReturn("exec h_p_Sc_MouldUpperBillList " + page + "," + size + ",'" + sWhere + "'", "h_p_Sc_MouldUpperBillList");




                //添加列名


                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.data = ds.Tables[0];


                objJsonResult.list = columnNameList;


                return objJsonResult;


            }


            catch (Exception ex)


            {


                objJsonResult.code = CodeConstant.FAIL;


                objJsonResult.count = CountConstant.FAIL;


                objJsonResult.Message = "没有返回任何记录！" + ex.ToString();


                objJsonResult.data = null;


                return objJsonResult;


            }


@@ -389,11 +439,59 @@


                        return objJsonResult;


                    }




                    BillOld.MvarItemKey = "Sc_MouldUpperBillMain";


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


                    DataSet ds2;


                    string sql1 = "exec h_p_Sc_MouldUpperBill_BeforeDelCtrl " + Convert.ToInt32(HInterID) + ",'" + ds.Tables[0].Rows[0]["HBillNo"] + "','" + user + "'";


                    ds2 = oCN.RunProcReturn(sql1, "h_p_Sc_MouldUpperBill_BeforeDelCtrl");


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


                    {


                        objJsonResult.code = "0";


                        objJsonResult.count = 1;


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


                        objJsonResult.data = null;


                        return objJsonResult;


                    }




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


                    {


                        objJsonResult.code = "0";


                        objJsonResult.count = 1;


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


                        objJsonResult.data = null;


                        return objJsonResult;


                    }


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




                    if (ds.Tables[0].Rows.Count == 1) {


                        oCN.RunProc("delete from Sc_MouldUpperBillMain where HInterID=" + hmainid);


                    }




                    oCN.RunProc("delete from Sc_MouldUpperBillSub where HInterID=" + hmainid + " and HEntryID=" + hsubid);




                    //删除后控制=========================================      


                    string sql2 = "exec h_p_Sc_MouldUpperBill_AfterDelCtrl " + Convert.ToInt32(HInterID) + ",'" + ds.Tables[0].Rows[0]["HBillNo"] + "','" + user + "'";


                    ds2 = oCN.RunProcReturn(sql2, "h_p_Sc_MouldUpperBill_AfterDelCtrl");


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


                    {


                        oCN.RollBack();


                        objJsonResult.code = "0";


                        objJsonResult.count = 1;


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


                        objJsonResult.data = null;


                        return objJsonResult;


                    }




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


                    {


                        oCN.RollBack();


                        objJsonResult.code = "0";


                        objJsonResult.count = 1;


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


                        objJsonResult.data = null;


                        return objJsonResult;


                    }


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




                    oCN.Commit();


                }


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


                {


                    //判断单据是否已经审核


                    DataSet ds;


                    DataSet ds2;


                    string sql = "select * from " + BillOld.MvarItemKey + " where HinterID = " + HInterID;


                    ds = oCN.RunProcReturn(sql, BillOld.MvarItemKey);


                    if (ds.Tables[0] != null && ds.Tables[0].Rows.Count > 0)


@@ -464,15 +563,38 @@


                            return objJsonResult;


                        }




                        //审核单据


                        if (!BillOld.CheckBill(Int64.Parse(HInterID), ref ClsPub.sExeReturnInfo))


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


                        string sql1 = "exec h_p_Sc_MouldUpperBill_BeforeCheckCtrl " + HInterID + ",'" + ds.Tables[0].Rows[0]["HBillNo"] + "','" + user + "'";


                        ds2 = oCN.RunProcReturn(sql1, "h_p_Sc_MouldUpperBill_BeforeCheckCtrl");


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


                        {


                            objJsonResult.code = "0";


                            objJsonResult.count = 1;


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


                            objJsonResult.data = null;


                            oCN.RollBack();


                            return objJsonResult;


                        }




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


                        {


                            objJsonResult.code = "0";


                            objJsonResult.count = 1;


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


                            objJsonResult.data = null;


                            oCN.RollBack();


                            return objJsonResult;


                        }


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




                        if (!BillOld.CheckBill(int.Parse(HInterID), ds.Tables[0].Rows[0]["HBillNo"].ToString(), "h_p_Sc_MouldUpperBill_AfterCheckCtrl", user, ref ClsPub.sExeReturnInfo))


                        {


                            objJsonResult.code = "0";


                            objJsonResult.count = 1;


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


                            objJsonResult.data = null;


                            return objJsonResult;


                        }


                        }                     


                    }


                    else


                    {


@@ -482,13 +604,12 @@


                        objJsonResult.data = null;


                        return objJsonResult;


                    }






                }


                else


                {


                    //判断单据是否已经反审核


                    DataSet ds;


                    DataSet ds2;


                    string sql = "select * from " + BillOld.MvarItemKey + " where HinterID = " + HInterID;


                    ds = oCN.RunProcReturn(sql, BillOld.MvarItemKey);


                    if (ds.Tables[0] != null && ds.Tables[0].Rows.Count > 0)


@@ -502,19 +623,36 @@


                            return objJsonResult;


                        }




                        //反审核单据


                        if (BillOld.AbandonCheck(Int64.Parse(HInterID), ref ClsPub.sExeReturnInfo))


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


                        string sql1 = "exec h_p_Sc_MouldUpperBill_BeforeUnCheckCtrl " + HInterID + ",'" + ds.Tables[0].Rows[0]["HBillNo"] + "','" + user + "'";


                        ds2 = oCN.RunProcReturn(sql1, "h_p_Sc_MouldUpperBill_BeforeUnCheckCtrl");


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


                        {


                            objJsonResult.code = "0";


                            objJsonResult.count = 1;


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


                            objJsonResult.data = null;


                            return objJsonResult;




                        }


                        else


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


                        {


                            objJsonResult.code = "0";


                            objJsonResult.count = 1;


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


                            objJsonResult.data = null;


                            return objJsonResult;


                        }


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




                        if (!BillOld.AbandonCheck(int.Parse(HInterID), ds.Tables[0].Rows[0]["HBillNo"].ToString(), "h_p_Sc_MouldUpperBill_AfterUnCheckCtrl", user, ref ClsPub.sExeReturnInfo))


                        {


                            objJsonResult.code = "0";


                            objJsonResult.count = 1;


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


                            objJsonResult.data = null;


                            return objJsonResult;


                        }


                        }                       


                    }




                    else


@@ -582,6 +720,7 @@


                {


                    //判断单据是否已经关闭


                    DataSet ds;


                    DataSet ds2;


                    string sql = "select * from " + BillOld.MvarItemKey + " where HinterID = " + HInterID;


                    ds = oCN.RunProcReturn(sql, BillOld.MvarItemKey);


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


@@ -603,7 +742,6 @@


                            return objJsonResult;


                        }






                        if (ds.Tables[0].Rows[0]["HCloseMan"] != null && ds.Tables[0].Rows[0]["HCloseMan"].ToString() != "")


                        {


                            objJsonResult.code = "0";


@@ -612,12 +750,43 @@


                            objJsonResult.data = null;


                            return objJsonResult;


                        }


                        //关闭单据


                        if (!BillOld.CloseBill(Int64.Parse(HInterID), ref ClsPub.sExeReturnInfo))




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


                        sql = "exec h_p_Sc_MouldUpperBill_BeforeCloseCtrl " + HInterID + ",'" + ds.Tables[0].Rows[0]["HBillNo"] + "','" + user + "'";


                        ds2 = oCN.RunProcReturn(sql, "h_p_Sc_MouldUpperBill_BeforeCloseCtrl");


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


                        {


                            objJsonResult.code = "0";


                            objJsonResult.count = 0;


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


                            objJsonResult.data = null;


                            return objJsonResult;




                        }


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


                        {


                            objJsonResult.code = "0";


                            objJsonResult.count = 0;


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


                            objJsonResult.data = null;


                            return objJsonResult;


                        }


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




                        //关闭提交


                        if (BillOld.CloseBill(Convert.ToInt32(HInterID), ds.Tables[0].Rows[0]["HBillNo"].ToString(), "h_p_Sc_MouldUpperBill_AfterCloseCtrl", user, ref DBUtility.ClsPub.sExeReturnInfo) == true)


                        {


                            objJsonResult.code = "1";


                            objJsonResult.count = 1;


                            objJsonResult.Message = "关闭失败!原因:" + ClsPub.sExeReturnInfo;


                            objJsonResult.Message = "关闭成功";


                            objJsonResult.data = null;


                            return objJsonResult;


                        }


                        else


                        {


                            objJsonResult.code = "0";


                            objJsonResult.count = 0;


                            objJsonResult.Message = "关闭失败!原因:" + DBUtility.ClsPub.sExeReturnInfo;


                            objJsonResult.data = null;


                            return objJsonResult;


                        }


@@ -627,6 +796,7 @@


                {


                    //判断单据是否已经反关闭


                    DataSet ds;


                    DataSet ds2;


                    string sql = "select * from " + BillOld.MvarItemKey + " where HinterID = " + HInterID;


                    ds = oCN.RunProcReturn(sql, BillOld.MvarItemKey);


                    if (ds.Tables[0] != null && ds.Tables[0].Rows.Count > 0)


@@ -648,15 +818,46 @@


                            objJsonResult.data = null;


                            return objJsonResult;


                        }


                        //反关闭单据


                        if (!BillOld.CancelClose(Int64.Parse(HInterID), ref ClsPub.sExeReturnInfo))




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


                        sql = "exec h_p_Sc_MouldUpperBill_BeforeUnCloseCtrl " + HInterID + ",'" + ds.Tables[0].Rows[0]["HBillNo"] + "','" + user + "'";


                        ds2 = oCN.RunProcReturn(sql, "h_p_Sc_MouldUpperBill_BeforeUnCloseCtrl");


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


                        {


                            objJsonResult.code = "0";


                            objJsonResult.count = 1;


                            objJsonResult.Message = "反关闭失败!原因:" + ClsPub.sExeReturnInfo;


                            objJsonResult.count = 0;


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


                            objJsonResult.data = null;


                            return objJsonResult;




                        }


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


                        {


                            objJsonResult.code = "0";


                            objJsonResult.count = 0;


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


                            objJsonResult.data = null;


                            return objJsonResult;


                        }


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




                        //反关闭提交


                        if (BillOld.CancelClose(Convert.ToInt32(HInterID), ds.Tables[0].Rows[0]["HBillNo"].ToString(), "h_p_Sc_MouldUpperBill_AfterUnCloseCtrl", user, ref DBUtility.ClsPub.sExeReturnInfo) == true)


                        {


                            objJsonResult.code = "1";


                            objJsonResult.count = 1;


                            objJsonResult.Message = "反关闭成功";


                            objJsonResult.data = null;


                            return objJsonResult;


                        }


                        else


                        {


                            objJsonResult.code = "0";


                            objJsonResult.count = 0;


                            objJsonResult.Message = "反关闭失败!原因:" + DBUtility.ClsPub.sExeReturnInfo;


                            objJsonResult.data = null;


                            return objJsonResult;


                        }                      


                    }


                }




@@ -829,7 +1030,7 @@


                    return objJsonResult;


                }




                ds = oCN.RunProcReturn("select * from  h_v_Qj_Sc_MouldLowerBillList where 1=1" + sWhere + "order by hmainid desc ", "h_v_Qj_Sc_MouldLowerBillList");


                ds = oCN.RunProcReturn("select * from  h_v_Qj_Sc_MouldLowerBill_Edit where 1=1" + sWhere + "order by hmainid desc ", "h_v_Qj_Sc_MouldLowerBill_Edit");




                //添加列名


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


@@ -851,6 +1052,55 @@


                objJsonResult.code = "0";


                objJsonResult.count = 0;


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


                objJsonResult.data = null;


                return objJsonResult;


            }


        }


        #endregion




        #region 下模单 列表分页查询


        [Route("Sc_MouldUpperBill/Sc_MouldLowerBillListPage")]


        [HttpGet]


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


        {


            try


            {


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




                //查看权限


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


                {


                    objJsonResult.code = "0";


                    objJsonResult.count = 0;


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


                    objJsonResult.data = null;


                    return objJsonResult;


                }




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


                ds = oCN.RunProcReturn("exec h_p_Sc_MouldLowerBillList " + page + "," + size + ",'" + sWhere + "'", "h_p_Sc_MouldLowerBillList");




                //添加列名


                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.data = ds.Tables[0];


                objJsonResult.list = columnNameList;


                return objJsonResult;


            }


            catch (Exception ex)


            {


                objJsonResult.code = CodeConstant.FAIL;


                objJsonResult.count = CountConstant.FAIL;


                objJsonResult.Message = "没有返回任何记录！" + ex.ToString();


                objJsonResult.data = null;


                return objJsonResult;


            }


@@ -1179,12 +1429,60 @@


                        return objJsonResult;


                    }




                    BillOld.MvarItemKey = "Sc_MouldLowerBillMain";


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


                    DataSet ds2;


                    string sql1 = "exec h_p_Sc_MouldLowerBill_BeforeDelCtrl " + Convert.ToInt32(HInterID) + ",'" + ds.Tables[0].Rows[0]["HBillNo"] + "','" + user + "'";


                    ds2 = oCN.RunProcReturn(sql1, "h_p_Sc_MouldLowerBill_BeforeDelCtrl");


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


                    {


                        objJsonResult.code = "0";


                        objJsonResult.count = 1;


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


                        objJsonResult.data = null;


                        return objJsonResult;


                    }




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


                    {


                        objJsonResult.code = "0";


                        objJsonResult.count = 1;


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


                        objJsonResult.data = null;


                        return objJsonResult;


                    }


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




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


                    {


                        oCN.RunProc("delete from Sc_MouldLowerBillMain where HInterID=" + hmainid);


                    }




                    oCN.RunProc("delete from Sc_MouldLowerBillSub where HInterID=" + hmainid + " and HEntryID=" + hsubid);




                    //删除后控制=========================================      


                    string sql2 = "exec h_p_Sc_MouldLowerBill_AfterDelCtrl " + Convert.ToInt32(HInterID) + ",'" + ds.Tables[0].Rows[0]["HBillNo"] + "','" + user + "'";


                    ds2 = oCN.RunProcReturn(sql2, "h_p_Sc_MouldLowerBill_AfterDelCtrl");


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


                    {


                        oCN.RollBack();


                        objJsonResult.code = "0";


                        objJsonResult.count = 1;


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


                        objJsonResult.data = null;


                        return objJsonResult;


                    }




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


                    {


                        oCN.RollBack();


                        objJsonResult.code = "0";


                        objJsonResult.count = 1;


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


                        objJsonResult.data = null;


                        return objJsonResult;


                    }


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




                    oCN.Commit();


                }


@@ -1242,6 +1540,7 @@


                {


                    //判断单据是否已经审核


                    DataSet ds;


                    DataSet ds2;


                    string sql = "select * from " + BillOld.MvarItemKey + " where HinterID = " + HInterID;


                    ds = oCN.RunProcReturn(sql, BillOld.MvarItemKey);


                    if (ds.Tables[0] != null && ds.Tables[0].Rows.Count > 0)


@@ -1255,8 +1554,31 @@


                            return objJsonResult;


                        }




                        //审核单据


                        if (!BillOld.CheckBill(Int64.Parse(HInterID), ref ClsPub.sExeReturnInfo))


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


                        string sql1 = "exec h_p_Sc_MouldLowerBill_BeforeCheckCtrl " + HInterID + ",'" + ds.Tables[0].Rows[0]["HBillNo"] + "','" + user + "'";


                        ds2 = oCN.RunProcReturn(sql1, "h_p_Sc_MouldLowerBill_BeforeCheckCtrl");


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


                        {


                            objJsonResult.code = "0";


                            objJsonResult.count = 1;


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


                            objJsonResult.data = null;


                            oCN.RollBack();


                            return objJsonResult;


                        }




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


                        {


                            objJsonResult.code = "0";


                            objJsonResult.count = 1;


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


                            objJsonResult.data = null;


                            oCN.RollBack();


                            return objJsonResult;


                        }


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




                        if (!BillOld.CheckBill(int.Parse(HInterID), ds.Tables[0].Rows[0]["HBillNo"].ToString(), "h_p_Sc_MouldLowerBill_AfterCheckCtrl", user, ref ClsPub.sExeReturnInfo))


                        {


                            objJsonResult.code = "0";


                            objJsonResult.count = 1;


@@ -1277,6 +1599,7 @@


                {


                    //判断单据是否已经反审核


                    DataSet ds;


                    DataSet ds2;


                    string sql = "select * from " + BillOld.MvarItemKey + " where HinterID = " + HInterID;


                    ds = oCN.RunProcReturn(sql, BillOld.MvarItemKey);


                    if (ds.Tables[0] != null && ds.Tables[0].Rows.Count > 0)


@@ -1290,12 +1613,29 @@


                            return objJsonResult;


                        }




                        //反审核单据


                        if (BillOld.AbandonCheck(Int64.Parse(HInterID), ref ClsPub.sExeReturnInfo))


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


                        string sql1 = "exec h_p_Sc_MouldLowerBill_BeforeUnCheckCtrl " + HInterID + ",'" + ds.Tables[0].Rows[0]["HBillNo"] + "','" + user + "'";


                        ds2 = oCN.RunProcReturn(sql1, "h_p_Sc_MouldLowerBill_BeforeUnCheckCtrl");


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


                        {


                            objJsonResult.code = "0";


                            objJsonResult.count = 1;


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


                            objJsonResult.data = null;


                            return objJsonResult;




                        }


                        else


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


                        {


                            objJsonResult.code = "0";


                            objJsonResult.count = 1;


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


                            objJsonResult.data = null;


                            return objJsonResult;


                        }


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




                        if (!BillOld.AbandonCheck(int.Parse(HInterID), ds.Tables[0].Rows[0]["HBillNo"].ToString(), "h_p_Sc_MouldLowerBill_AfterUnCheckCtrl", user, ref ClsPub.sExeReturnInfo))


                        {


                            objJsonResult.code = "0";


                            objJsonResult.count = 1;


@@ -1369,6 +1709,7 @@


                {


                    //判断单据是否已经关闭


                    DataSet ds;


                    DataSet ds2;


                    string sql = "select * from " + BillOld.MvarItemKey + " where HinterID = " + HInterID;


                    ds = oCN.RunProcReturn(sql, BillOld.MvarItemKey);


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


@@ -1399,12 +1740,43 @@


                            objJsonResult.data = null;


                            return objJsonResult;


                        }


                        //关闭单据


                        if (!BillOld.CloseBill(Int64.Parse(HInterID), ref ClsPub.sExeReturnInfo))




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


                        sql = "exec h_p_Sc_MouldLowerBill_BeforeCloseCtrl " + HInterID + ",'" + ds.Tables[0].Rows[0]["HBillNo"] + "','" + user + "'";


                        ds2 = oCN.RunProcReturn(sql, "h_p_Sc_MouldLowerBill_BeforeCloseCtrl");


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


                        {


                            objJsonResult.code = "0";


                            objJsonResult.count = 0;


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


                            objJsonResult.data = null;


                            return objJsonResult;




                        }


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


                        {


                            objJsonResult.code = "0";


                            objJsonResult.count = 0;


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


                            objJsonResult.data = null;


                            return objJsonResult;


                        }


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




                        //关闭提交


                        if (BillOld.CloseBill(Convert.ToInt32(HInterID), ds.Tables[0].Rows[0]["HBillNo"].ToString(), "h_p_Sc_MouldLowerBill_AfterCloseCtrl", user, ref DBUtility.ClsPub.sExeReturnInfo) == true)


                        {


                            objJsonResult.code = "1";


                            objJsonResult.count = 1;


                            objJsonResult.Message = "关闭失败!原因:" + ClsPub.sExeReturnInfo;


                            objJsonResult.Message = "关闭成功";


                            objJsonResult.data = null;


                            return objJsonResult;


                        }


                        else


                        {


                            objJsonResult.code = "0";


                            objJsonResult.count = 0;


                            objJsonResult.Message = "关闭失败!原因:" + DBUtility.ClsPub.sExeReturnInfo;


                            objJsonResult.data = null;


                            return objJsonResult;


                        }


@@ -1414,6 +1786,7 @@


                {


                    //判断单据是否已经反关闭


                    DataSet ds;


                    DataSet ds2;


                    string sql = "select * from " + BillOld.MvarItemKey + " where HinterID = " + HInterID;


                    ds = oCN.RunProcReturn(sql, BillOld.MvarItemKey);


                    if (ds.Tables[0] != null && ds.Tables[0].Rows.Count > 0)


@@ -1435,12 +1808,43 @@


                            objJsonResult.data = null;


                            return objJsonResult;


                        }


                        //反关闭单据


                        if (!BillOld.CancelClose(Int64.Parse(HInterID), ref ClsPub.sExeReturnInfo))




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


                        sql = "exec h_p_Sc_MouldLowerBill_BeforeUnCloseCtrl " + HInterID + ",'" + ds.Tables[0].Rows[0]["HBillNo"] + "','" + user + "'";


                        ds2 = oCN.RunProcReturn(sql, "h_p_Sc_MouldLowerBill_BeforeUnCloseCtrl");


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


                        {


                            objJsonResult.code = "0";


                            objJsonResult.count = 0;


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


                            objJsonResult.data = null;


                            return objJsonResult;




                        }


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


                        {


                            objJsonResult.code = "0";


                            objJsonResult.count = 0;


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


                            objJsonResult.data = null;


                            return objJsonResult;


                        }


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




                        //反关闭提交


                        if (BillOld.CancelClose(Convert.ToInt32(HInterID), ds.Tables[0].Rows[0]["HBillNo"].ToString(), "h_p_Sc_MouldLowerBill_AfterUnCloseCtrl", user, ref DBUtility.ClsPub.sExeReturnInfo) == true)


                        {


                            objJsonResult.code = "1";


                            objJsonResult.count = 1;


                            objJsonResult.Message = "反关闭失败!原因:" + ClsPub.sExeReturnInfo;


                            objJsonResult.Message = "反关闭成功";


                            objJsonResult.data = null;


                            return objJsonResult;


                        }


                        else


                        {


                            objJsonResult.code = "0";


                            objJsonResult.count = 0;


                            objJsonResult.Message = "反关闭失败!原因:" + DBUtility.ClsPub.sExeReturnInfo;


                            objJsonResult.data = null;


                            return objJsonResult;


                        }


@@ -1636,7 +2040,7 @@


        #region 上/下模单获取条码信息


        [Route("Sc_MouldUpperBill/txtHBarCode_KeyDown")]


        [HttpGet]


        public object txtHBarCode_KeyDown(string HBarCode, string UserID, string HBillType)


        public object txtHBarCode_KeyDown(string HBarCode,int HSourceID, string UserID, string HBillType)


        {


            try


            {


@@ -1649,7 +2053,7 @@


                    return objJsonResult;


                }




                ds = oCN.RunProcReturn("exec h_p_Sc_AllowLoadData '" + HBarCode + "'", "h_p_Sc_AllowLoadData");


                ds = oCN.RunProcReturn("exec h_p_Sc_AllowLoadData '" + HBarCode + "','"+ HSourceID + "','"+ HBillType + "'", "h_p_Sc_AllowLoadData");




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


                {


@@ -1660,6 +2064,15 @@


                    return objJsonResult;


                }




                if (DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HBack"]) != "0")


                {


                    objJsonResult.code = "0";


                    objJsonResult.count = 0;


                    objJsonResult.Message = "保存失败！" + DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HBackRemark"]);


                    objJsonResult.data = null;


                    return objJsonResult;


                }




                objJsonResult.code = "1";


                objJsonResult.count = 1;


                objJsonResult.Message = "Sucess！";