智云MES后端API代码
blame | 历史 | 补丁 | 提交 | 提交对比 | ignore whitespace
1
zrg
2024-11-21 179a5764f06f36e8d0901d5c1b8ac85804920db9 
 WebAPI/Controllers/MJGL/Sc_MouldMoveStockStepOutBillController.cs


@@ -89,7 +89,7 @@


            try


            {


                //编辑权限 


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


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


                {


                    objJsonResult.code = "0";


                    objJsonResult.count = 0;


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


                }




                ds = Sc_MouldMoveStockStepOutBill(sWhere,Organization);




                objJsonResult.code = "1";


                objJsonResult.count = 1;


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


@@ -120,11 +121,11 @@


            string sql1 = string.Format(@"select * from h_v_Sc_MouldMoveStockStepOutBill where (调出组织='" + Organization + "' or 调入组织='" + Organization + "')");


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


            {


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


                return new SQLHelper.ClsCN().RunProcReturn(sql1+ "order by 制单日期 desc", "h_v_Sc_MouldMoveStockStepOutBill");


            }


            else


            {


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


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


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


            }




@@ -155,6 +156,8 @@


        public object Sc_MouldMoveStockStepOutBillListProjectDetai(string sqlWhere)


        {


            DataSet ds;


            DataSet ds1;


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


            try


            {


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


@@ -164,12 +167,8 @@


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


                                                单价 HPrice, 金额 HMoney,HStockOrgID,调入组织代码 HStockOrgCode,调入组织 HStockOrgName, HOtherOrgID ,调出组织代码 HOtherOrgCode,调出组织 HOtherOrgName, HWHID, 调入仓库代码 HWHCode, 调入仓库 HWHName,HSPID, 


                                                调入仓位代码 HSPCode, 调入仓位 HSPName,HSCWHID, 调出仓库代码 HSCWHCode, 调出仓库 HSCWHName,HSCSPID, 


                                                调出仓位代码 HSCSPCode, 调出仓位 HSCSPName,表体备注 HRemark,HStockOrgID FROM h_v_Sc_MouldMoveStockStepOutBill"), "h_v_Sc_MouldMoveStockStepOutBill");


                                                调出仓位代码 HSCSPCode, 调出仓位 HSCSPName,表体备注 HRemark,HStockOrgID,HUnitID,计量单位代码 HUnitCode,计量单位 HUnitName FROM h_v_Sc_MouldMoveStockStepOutBill"), "h_v_Sc_MouldMoveStockStepOutBill");




                    objJsonResult.code = "0";


                    objJsonResult.count = 1;


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


                    objJsonResult.data = ds.Tables[0];


                }


                else


                {


@@ -178,15 +177,22 @@


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


                                                单价 HPrice, 金额 HMoney,HStockOrgID,调入组织代码 HStockOrgCode,调入组织 HStockOrgName, HOtherOrgID,调出组织代码 HOtherOrgCode,调出组织 HOtherOrgName, HWHID, 调入仓库代码 HWHCode, 调入仓库 HWHName,HSPID, 


                                                调入仓位代码 HSPCode, 调入仓位 HSPName,HSCWHID, 调出仓库代码 HSCWHCode, 调出仓库 HSCWHName,HSCSPID, 


                                                调出仓位代码 HSCSPCode, 调出仓位 HSCSPName,表体备注 HRemark,HStockOrgID FROM h_v_Sc_MouldMoveStockStepOutBill where 1 = 1 ");


                                                调出仓位代码 HSCSPCode, 调出仓位 HSCSPName,表体备注 HRemark,HStockOrgID,HUnitID,计量单位代码 HUnitCode,计量单位 HUnitName FROM h_v_Sc_MouldMoveStockStepOutBill where 1 = 1 ");


                    string sql = sql1 + sqlWhere;


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




                    objJsonResult.code = "0";


                    objJsonResult.count = 1;


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


                    objJsonResult.data = ds.Tables[0];


                }


                //查汇总


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


                                            hscwhid,max(调出仓库代码)调出仓库代码,max(调出仓库)调出仓库,表体备注 from h_v_Sc_MouldMoveStockStepOutBill 


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




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


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


                objJsonResult.code = "0";


                objJsonResult.count = 1;


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


                objJsonResult.list = list;


            }


            catch (Exception e)


            {


@@ -221,7 +227,7 @@


            ListModels oListModels = new ListModels();


            try


            {


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


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


                {


                    objJsonResult.code = "0";


                    objJsonResult.count = 0;


@@ -310,13 +316,20 @@


                {


                    // bResult = oBill.AddBill(ref DBUtility.ClsPub.sExeReturnInfo);


                    bResult = oBill.AddBill(ref DBUtility.ClsPub.sExeReturnInfo);


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


                    oCn.RunProc(sql);


                }


                else


                {


                    bResult = oBill.ModifyBill(oBill.omodel.HInterID, ref DBUtility.ClsPub.sExeReturnInfo);


                    //修改成功


                    //string sql = string.Format($"exec h_p_Sc_MouldChangeNowWHID  1,{oBill.omodel.HInterID.ToString()},' ' ");


                    string sql = string.Format($"exec h_p_Sc_MouldChangeNowWHID ");


                    oCn.RunProc(sql);


                }


                if (bResult)


                {


                    


                    objJsonResult.code = "0";


                    objJsonResult.count = 1;


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


@@ -354,7 +367,7 @@


        public object DeltetMouldMoveStockStepOutBil(string HInterID,string user)


        {


            //编辑权限 


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


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


            {


                objJsonResult.code = "0";


                objJsonResult.count = 0;


@@ -393,10 +406,21 @@


                    objJsonResult.data = null;


                    return objJsonResult;


                }




                //删除前查找当前单据的所有器具ID


                //string swhere = "";


                //DataSet ds = oCn.RunProcReturn("select HMaterID from Sc_MouldStockBillSub where HinterID=" + HInterID, "Sc_MouldStockBillSub");


                //for (var i = 0; i < ds.Tables[0].Rows.Count; i++)


                //{


                //    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);


                if (IsDete)


                {


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


                    //string sql = string.Format($"exec h_p_Sc_MouldChangeNowWHID  0,0,'{swhere}' ");


                    string sql = string.Format($"exec h_p_Sc_MouldChangeNowWHID ");


                    oCn.RunProc(sql);


                    objJsonResult.code = "0";


                    objJsonResult.count = 1;


                    objJsonResult.Message = DBUtility.ClsPub.sExeReturnInfo;


@@ -431,7 +455,7 @@


        {


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


            //编辑权限


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


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


            {


                objJsonResult.code = "0";


                objJsonResult.count = 0;


@@ -508,6 +532,49 @@


        }


        #endregion




        #region 器具分布式调出未调入单列表Sc_MouldMoveStockStepOutButNotStepInList




        [Route("Sc_MouldMoveStockStepOutBill/GetMouldMoveStockStepOutButNotStepInList")]


        [HttpGet]


        public object GetMouldMoveStockStepOutButNotStepInList(string sWhere, string Organization)


        {


            try


            {


                ds = Sc_MouldGetMouldMoveStockStepOutButNotStepInList(sWhere, Organization);




                objJsonResult.code = "1";


                objJsonResult.count = 1;


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


                objJsonResult.data = ds.Tables[0];


                return objJsonResult;


            }


            catch (Exception ex)


            {


                objJsonResult.code = "0";


                objJsonResult.count = 0;


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


                objJsonResult.data = null;


                return objJsonResult;


            }


        }




        public static DataSet Sc_MouldGetMouldMoveStockStepOutButNotStepInList(string sWhere, string Organization)


        {


            string sql1 = string.Format(@"select * from h_v_Sc_MouldMoveStockStepOutButNotStepInList where (调出组织='" + Organization + "' or 调入组织='" + Organization + "')");


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


            {


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


            }


            else


            {


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


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


            }




        }




        #endregion




    }


}


#endregion