智云MES后端API代码
blame | 历史 | 补丁 | 提交 | 提交对比 | ignore whitespace
yangle
2022-05-20 bbce8e0914dce16334feda67ce918a587d61fe6a 
 WebAPI/Controllers/MJGL/Sc_MouldProdInBillController.cs


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


using System.Net;


using System.Net.Http;


using System.Web.Http;


using ViewAPI;


using WebAPI.Models;




namespace WebAPI.Controllers.MJGL


@@ -28,8 +29,9 @@


        {


            try


            {


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


                //编辑权限


                if (!DBUtility.ClsPub.Security_Log_second("Sc_MouldProdInBillList", 1, true, user))


                if (!DBUtility.ClsPub.Security_Log_second("Sc_MouldProdInBillList", 1, false, user))


                {


                    objJsonResult.code = "0";


                    objJsonResult.count = 0;


@@ -37,24 +39,25 @@


                    objJsonResult.data = null;


                    return objJsonResult;


                }




                Log.LogInfo("有权限");


                ds = Sc_GetMouldProdInHouseBill(sWhere,Organization);


                if (ds == null)


                {


                    objJsonResult.code = "0";


                    objJsonResult.count = 0;


                    objJsonResult.Message = "查询数据异常，请与管理员联系！";


                    objJsonResult.data = null;


                    return objJsonResult;


                }


                else


                {


                    objJsonResult.code = "1";


                    objJsonResult.count = 1;


                    objJsonResult.Message = "返回记录成功！";


                    objJsonResult.data = ds.Tables[0];


                    return objJsonResult;


                }




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


                //{


                objJsonResult.code = "1";


                objJsonResult.count = 1;


                objJsonResult.Message = "Sucess！";


                objJsonResult.data = ds.Tables[0];


                return objJsonResult;


                //}


                //else


                //{


                //objJsonResult.code = "0";


                //objJsonResult.count = 0;


                //objJsonResult.Message = "无数据";


                //objJsonResult.data = null;


                //return objJsonResult;


                //}


            }


            catch (Exception ex)


            {


@@ -68,17 +71,18 @@




        public static DataSet Sc_GetMouldProdInHouseBill(string sWhere, string Organization)


        {


            LogService.Write(sWhere+";"+ Organization);


            string sql1 = string.Format(@"select * from h_v_Sc_MouldProdInHouseBillList where 库存组织='" + Organization + "'");


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


            {


                return new SQLHelper.ClsCN().RunProcReturn(sql1+ sWhere + "order by 日期 desc", "h_v_Sc_MouldProdInHouseBillList");


                return new SQLHelper.ClsCN().RunProcReturn(sql1+ sWhere + "order by hmainid desc", "h_v_Sc_MouldProdInHouseBillList");


            }


            else


            {


                string sql = sql1 + sWhere+ "order by 日期 desc";


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


                Log.LogInfo(sql);


                return new SQLHelper.ClsCN().RunProcReturn(sql, "h_v_Sc_MouldProdInHouseBillList");


            }




        }




        #endregion


@@ -93,7 +97,7 @@


        public object set_DeleteBill(string HInterID,string user)


        {


            //编辑权限


            if (!DBUtility.ClsPub.Security_Log_second("Sc_MouldProdInBill_Delete", 1, true, user))


            if (!DBUtility.ClsPub.Security_Log_second("Sc_MouldProdInBill_Delete", 1, false, user))


            {


                objJsonResult.code = "0";


                objJsonResult.count = 0;


@@ -187,7 +191,7 @@


            try


            {


                //审核权限


                if (!DBUtility.ClsPub.Security_Log_second(ModRightNameCheck, 1, true, CurUserName))


                if (!DBUtility.ClsPub.Security_Log_second(ModRightNameCheck, 1, false, CurUserName))


                {


                    objJsonResult.code = "0";


                    objJsonResult.count = 0;


@@ -294,7 +298,7 @@


            try


            {


                //审核权限


                if (!DBUtility.ClsPub.Security_Log_second(ModRightNameCheck, 1, true, CurUserName))


                if (!DBUtility.ClsPub.Security_Log_second(ModRightNameCheck, 1, false, CurUserName))


                {


                    objJsonResult.code = "0";


                    objJsonResult.count = 0;


@@ -411,6 +415,7 @@


        {


            DataSet ds;


            DataSet ds1;


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


            try


            {


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


@@ -419,18 +424,9 @@


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


                                          批次 HBatchNo,设计寿命 HDesignLife, 剩余寿命 HLeaveLife, 使用寿命 HUseLife,应收数量 HQtyMust,


                                          实收数量 HQty, 单价 HPrice, 金额 HMoney,hwhid1 HWHID, 收料仓库代码 HWHCode,收料仓库 HWHName,


                                          HSPID, 收料仓位代码 HSPCode,收料仓位 HSPName,表体备注 HRemark,HStockOrgID 


                                          HSPID, 收料仓位代码 HSPCode,收料仓位 HSPName,表体备注 HRemark,HStockOrgID,HUnitID,计量单位代码,计量单位  


                                          FROM h_v_Sc_MouldProdInHouseBillList"), "h_v_Sc_MouldProdInHouseBillList");


                    //查汇总


                    ds1 = oCN.RunProcReturn(string.Format(@"select 模具代码,模具名称,单据号,规格型号,批次,实收数量,hwhid1,收料仓库代码,


                                                收料仓库,表体备注,sum(HMaterID) from h_v_Sc_MouldProdInHouseBillList group by 模具代码,


                                                模具名称,单据号,规格型号,批次,实收数量,hwhid1,收料仓库代码,收料仓库,表体备注"), 


                                                "h_v_Sc_MouldProdInHouseBillList");




                    objJsonResult.code = "0";


                    objJsonResult.count = 1;


                    objJsonResult.Message = "获取信息成功！";


                    objJsonResult.data = ds.Tables[0];


                    


                }


                else


                {


@@ -439,16 +435,23 @@


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


                                          批次 HBatchNo,设计寿命 HDesignLife, 剩余寿命 HLeaveLife, 使用寿命 HUseLife,应收数量 HQtyMust,


                                          实收数量 HQty, 单价 HPrice, 金额 HMoney,hwhid1 HWHID, 收料仓库代码 HWHCode,收料仓库 HWHName,


                                          HSPID, 收料仓位代码 HSPCode,收料仓位 HSPName,表体备注 HRemark,HStockOrgID 


                                          HSPID, 收料仓位代码 HSPCode,收料仓位 HSPName,表体备注 HRemark,HStockOrgID,HUnitID,计量单位代码,计量单位  


                                          FROM h_v_Sc_MouldProdInHouseBillList where 1=1");


                    string sql = sql1 + sqlWhere;


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




                    objJsonResult.code = "0";


                    objJsonResult.count = 1;


                    objJsonResult.Message = "获取信息成功！";


                    objJsonResult.data = ds.Tables[0];


                }


                //查汇总


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


                                            hwhid1,max(收料仓库代码)收料仓库代码,max(收料仓库)收料仓库,表体备注 from h_v_Sc_MouldProdInHouseBillList 


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




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


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


                objJsonResult.code = "0";


                objJsonResult.count = 1;


                objJsonResult.Message = "获取信息成功！";


                objJsonResult.list = list;




            }


            catch (Exception e)


            {


@@ -481,11 +484,12 @@




            string UserName = "";


            string s = "";


            long mouldid;


            ListModels oListModels = new ListModels();


            try


            {


                //编辑权限


                if (!DBUtility.ClsPub.Security_Log_second("Sc_MouldProdInBill_Edit", 1, true, msg4))


                if (!DBUtility.ClsPub.Security_Log_second("Sc_MouldProdInBill_Edit", 1, false, msg4))


                {


                    objJsonResult.code = "0";


                    objJsonResult.count = 0;


@@ -596,7 +600,7 @@




                    i++;


                    oItemSub.HEntryID = i;




                    mouldid = oItemSub.HMaterID;


                    //oItemSub.HRepairCheckID = 0;   //验收项目ID


                    //oItemSub.HRepairCheckContent = ""; //验收内容


                    //oItemSub.HManagerID = 0;   //负责人ID


@@ -630,6 +634,8 @@


                }


                if (bResult)


                {


                    string sql = $"exec h_p_Sc_MouldChangeFileStatus  'in','{oBill.omodel.HInterID.ToString()}' ";


                    oCn.RunProc(sql);


                    objJsonResult.code = "0";


                    objJsonResult.count = 1;


                    objJsonResult.Message = "保存成功！";


@@ -664,7 +670,7 @@


        {


            //flag=1 审核；  flag=2 反审核


            //编辑权限


            if (!DBUtility.ClsPub.Security_Log_second("Sc_MouldProdInBill_Check", 1, true, user))


            if (!DBUtility.ClsPub.Security_Log_second("Sc_MouldProdInBill_Check", 1, false, user))


            {


                objJsonResult.code = "0";


                objJsonResult.count = 0;