智云MES后端API代码
blame | 历史 | 补丁 | 提交 | 提交对比 | ignore whitespace
yusijie
2024-12-17 feec6d0e153a8435ead4383a2a8f988b47003191 
 WebAPI/Controllers/SCGL/Sc_ICMOReportBillController.cs


@@ -38,6 +38,7 @@


        {


            try


            {


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


                //判断是否有查询权限


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


                {


@@ -58,13 +59,19 @@


                    string sql = sql1 + sWhere + " order by hmainid desc ";


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


                }




                foreach (DataColumn col in ds.Tables[0].Columns)//遍历ds中第一个表（Tables[0]）的所有列（Columns）每次循环中，col变量会持有当前列的引用


                {


                    Type dataType = col.DataType; //获取当前数据类型传入 自定义变量datadataType


                    string ColmString = "{\"ColmCols\":\"" + col.ColumnName + "\",\"ColmType\":\"" + dataType.Name + "\"}"; //字符串拼接         // 将列名和数据类型信息拼接成一个JSON格式的字符串


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


                }


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


                //{


                objJsonResult.code = "1";


                objJsonResult.count = 1;


                objJsonResult.Message = "Sucess！";


                objJsonResult.data = ds.Tables[0];


                objJsonResult.list = a;


                return objJsonResult;


                //}


                //else


@@ -118,7 +125,9 @@


                {


                    ds = oCN.RunProcReturn(string.Format(@"SELECT HMaterID,物料代码 HMaterCode,物料名称 HMaterName,规格型号 HMaterSpec,


                                            HUnitID, 计量单位代码 HUnitCode, 计量单位 HUnitName,HSourceID,生产资源代码 HSourceCode,生产资源 HSourceName,


                                            HWorkerid,操作员代码 HWorkerCode,操作员 HWorkerName,生产数量 HQty,表体备注 HRemark


                                            HWorkerid,操作员代码 HWorkerCode,操作员 HWorkerName,生产数量 HQty,表体备注 HRemark,


                                            HICMOInterID,HICMOEntryID,HICMOBillNo,HICMOInterID as HSourceInterID,HICMOEntryID as HSourceEntryID,


                                            HICMOBillNo as HSourceBillNo,3710 as HSourceBillType,不良数量 HBadQty


                                            FROM h_v_IF_ICMOReportBillList_Edit"), "h_v_IF_ICMOReportBillList_Edit");




                    objJsonResult.code = "0";


@@ -132,7 +141,10 @@


                    //string sql1 = "select HRepairCheckID,HRepairCheckContent,HManagerID,HRemark  from Sc_MouldRepairCheckBillSub where 1 = 1 ";


                    string sql1 = string.Format(@"SELECT HMaterID,物料代码 HMaterCode,物料名称 HMaterName,规格型号 HMaterSpec,


                                            HUnitID, 计量单位代码 HUnitCode, 计量单位 HUnitName,HSourceID,生产资源代码 HSourceCode,生产资源 HSourceName,


                                            HWorkerid,操作员代码 HWorkerCode,操作员 HWorkerName,生产数量 HQty,表体备注 HRemark


                                            HWorkerid,操作员代码 HWorkerCode,操作员 HWorkerName,生产数量 HQty,表体备注 


                                            HRemark,HICMOInterID,HICMOEntryID,HICMOBillNo,


                                            HICMOInterID as HSourceInterID,HICMOEntryID as HSourceEntryID,


                                            HICMOBillNo as HSourceBillNo,3710 as HSourceBillType,不良数量 HBadQty


                                            FROM h_v_IF_ICMOReportBillList_Edit where 1 = 1 ");


                    string sql = sql1 + sqlWhere;


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


@@ -298,8 +310,8 @@


                    oItemSub.HEntryCloseDate = DBUtility.ClsPub.isDate(DateTime.Now);


                    oItemSub.HCloseType = false;   //关闭类型


                    //oItemSub.HRemark = "";         //备注


                    oItemSub.HSourceInterID = 0;     // 源单主内码


                    oItemSub.HSourceEntryID = 0;   //源单子内码


                    //oItemSub.HSourceInterID = 0;     // 源单主内码


                    //oItemSub.HSourceEntryID = 0;   //源单子内码


                    //oItemSub.HSourceBillNo = "";  //源单单号


                    //oItemSub.HSourceBillType = ""; //源单类型


                    //oItemSub.HRelationQty = 0;     //关联数量


@@ -493,6 +505,8 @@


                    objJsonResult.data = null;


                    return objJsonResult;


                }


                string HBillNo = "";


                oCN.BeginTran();//开始事务


                ds = oCN.RunProcReturn("select * from Sc_ICMOReportBillMain where HInterID=" + lngBillKey, "Sc_ICMOReportBillMain");


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


                {


@@ -500,17 +514,51 @@


                    objJsonResult.count = 0;


                    objJsonResult.Message = "没有数据，无法删除！";


                    objJsonResult.data = null;


                    oCN.RollBack();


                    return objJsonResult; ;


                }


                else


                {


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


                }




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


                DataSet Ds;




                string sql1 = "exec h_p_Sc_ICMOReportBill_BeforeDelCtrl " + HInterID + ",'" + HBillNo + "','" + user + "'";


                Ds = oCN.RunProcReturn(sql1, "h_p_Sc_ICMOReportBill_BeforeDelCtrl");


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


                {


                    objJsonResult.code = "0";


                    objJsonResult.count = 0;


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


                    objJsonResult.data = null;


                    oCN.RollBack();


                    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;


                    oCN.RollBack();


                    return objJsonResult;


                }


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






                oCN.RunProc("Insert into System_log (GeginDate, userid, WorkstationName, WorkList, SystemName, NetuserName, State) select GETDATE(),'" + user + "','" + "" + "','" + "删除生产汇报单单据：" + ds.Tables[0].Rows[0]["HBillNo"].ToString() + "','LMES-生产汇报单模块','" + DBUtility.ClsPub.IPAddress + "','删除单据'", ref DBUtility.ClsPub.sExeReturnInfo);






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


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






                if (IsDete)


                {


                    oCN.Commit();//提交事务




                    objJsonResult.code = "0";


                    objJsonResult.count = 1;


                    objJsonResult.Message = DBUtility.ClsPub.sExeReturnInfo;


@@ -519,11 +567,11 @@


                }


                else


                {




                    objJsonResult.code = "0";


                    objJsonResult.count = 0;


                    objJsonResult.Message = DBUtility.ClsPub.sExeReturnInfo;


                    objJsonResult.data = null;


                    oCN.RollBack();


                    return objJsonResult;


                }


            }


@@ -533,6 +581,7 @@


                objJsonResult.count = 0;


                objJsonResult.Message = "单据未找到";


                objJsonResult.data = null;


                oCN.RollBack();


                return objJsonResult;


            }


        }


@@ -552,6 +601,7 @@


        {


            string ModRightNameCheck = "Sc_ICMOReportBill_Check";


            DBUtility.ClsPub.CurUserName = CurUserName;


            string sql = "";


            try


            {


                //审核权限


@@ -626,8 +676,30 @@


                }


                if (IsAudit == 0) //审核提交


                {


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


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


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


                    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.CheckBill(lngBillKey, ref DBUtility.ClsPub.sExeReturnInfo) == true)


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


                    {


                        objJsonResult.code = "1";


                        objJsonResult.count = 1;


@@ -637,8 +709,8 @@


                    }


                    else


                    {


                        objJsonResult.code = "1";


                        objJsonResult.count = 1;


                        objJsonResult.code = "0";


                        objJsonResult.count = 0;


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


                        objJsonResult.data = null;


                        return objJsonResult;


@@ -646,8 +718,30 @@


                }


                if (IsAudit == 1) //反审核提交


                {


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


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


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


                    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===================================================================




                    //反审核提交AbandonCheck


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


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


                    {


                        objJsonResult.code = "1";


                        objJsonResult.count = 1;


@@ -657,8 +751,8 @@


                    }


                    else


                    {


                        objJsonResult.code = "1";


                        objJsonResult.count = 1;


                        objJsonResult.code = "0";


                        objJsonResult.count = 0;


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


                        objJsonResult.data = null;


                        return objJsonResult;


@@ -1183,5 +1277,43 @@


        }


        #endregion






        #region 生产汇报单 根据主内码与子内码获取生产汇报单数据


        [Route("Sc_ICMOReportBill/loadSc_ICMOReportBill_Push")]


        [HttpGet]


        public object loadSc_ICMOReportBill_Push(long HInterID, long HSubID)


        {


            try


            {




                ds = oCN.RunProcReturn("select * from h_v_IF_ICMOReportBillList_Edit where hmainid =" + HInterID + " and hsubid = " + HSubID, "h_v_IF_ICMOReportBillList_Edit");


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


                {


                    objJsonResult.code = "0";


                    objJsonResult.count = 0;


                    objJsonResult.Message = "未查询到源单信息！";


                    objJsonResult.data = null;


                    return objJsonResult;


                }


                else


                {


                    objJsonResult.code = "1";


                    objJsonResult.count = 1;


                    objJsonResult.Message = "Sucess！";


                    objJsonResult.data = ds.Tables[0];


                    return objJsonResult;


                }


            }


            catch (Exception e)


            {


                objJsonResult.code = "0";


                objJsonResult.count = 0;


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


                objJsonResult.data = null;


                return objJsonResult;


            }


        }


        #endregion




    }


}