智云MES后端API代码
blame | 历史 | 补丁 | 提交 | 提交对比 | ignore whitespace
duhe
2023-08-10 11d66773731184ac89f01501bdb508e645f0c095 
 WebAPI/Controllers/SBGL/Sb_EquipMaintainBillController.cs


@@ -1,4 +1,5 @@


using Newtonsoft.Json.Linq;


using Newtonsoft.Json;


using Newtonsoft.Json.Linq;


using Pub_Class;


using System;


using System.Collections.Generic;


@@ -25,10 +26,19 @@


        /// <returns></returns>


        [Route("Sb_EquipMaintainBill/GetEquipMaintainBillList")]


        [HttpGet]


        public object GetEquipMaintainBillList(string sWhere)


        public object GetEquipMaintainBillList(string sWhere,string user)


        {


            try


            {


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


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


                {


                    objJsonResult.code = "0";


                    objJsonResult.count = 0;


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


                    objJsonResult.data = null;


                    return objJsonResult;


                }


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


                {


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


@@ -39,22 +49,32 @@


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


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


                }


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




                //添加列名


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


                {


                    objJsonResult.code = "0";


                    objJsonResult.count = 0;


                    objJsonResult.Message = "没有你要找的记录！";


                    objJsonResult.data = null;


                    return objJsonResult;


                    Type dataType = col.DataType;


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


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


                }


                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];


                objJsonResult.list = columnNameList;


                return objJsonResult;


                //}


                //else


                //{


                //objJsonResult.code = "0";


                //objJsonResult.count = 0;


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


                //objJsonResult.data = null;


                //return objJsonResult;


                //}


            }


            catch (Exception ex)


            {


@@ -91,11 +111,20 @@


            string msg2 = sArray[0].ToString();


            string msg3 = sArray[1].ToString();


            string msg4 = sArray[2].ToString();


            string msg5 = sArray[3].ToString();




            string UserName = "";


            ListModels oListModels = new ListModels();


            try


            {


                if (!DBUtility.ClsPub.Security_Log("Sb_EquipMaintainBill_Edit", 1, false, msg5))


                {


                    objJsonResult.code = "0";


                    objJsonResult.count = 0;


                    objJsonResult.Message = "无保存权限！";


                    objJsonResult.data = null;


                    return objJsonResult;


                }


                DAL.ClsSb_EquipMaintainBill oBill = new DAL.ClsSb_EquipMaintainBill();


                List<Model.ClsSb_EquipMaintainBillMain> lsmain = new List<Model.ClsSb_EquipMaintainBillMain>();


                msg2 = msg2.Replace("\\", "");


@@ -240,17 +269,17 @@


        /// <returns></returns>


        [Route("Sb_EquipMaintainBill/DeltetEquipMaintainBillList")]


        [HttpGet]


        public object DeltetEquipMaintainBillList(string HInterID)


        public object DeltetEquipMaintainBillList(string HInterID,string user)


        {


            //编辑权限


            //if (!DBUtility.ClsPub.Security_Log("Sb_MouldRepairWorkBill_Delete", 1, true, DBUtility.ClsPub.CurUserName))


            //{


            //    objJsonResult.code = "0";


            //    objJsonResult.count = 0;


            //    objJsonResult.Message = "无删除权限！";


            //    objJsonResult.data = null;


            //    return objJsonResult;


            //}


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


            {


                objJsonResult.code = "0";


                objJsonResult.count = 0;


                objJsonResult.Message = "无删除权限！";


                objJsonResult.data = null;


                return objJsonResult;


            }






            Int64 lngBillKey = 0;


@@ -438,7 +467,7 @@


                    return objJsonResult;


                }


                //得到信息


                ds = oCN.RunProcReturn("select top 1 * from Gy_EquipMent  where HNumber= '" + HBarCode + "'", "Gy_EquipMent");


                ds = oCN.RunProcReturn("select top 1 * from Gy_EquipFileBillMain  where HEquipFileNumber= '" + HBarCode + "'", "Gy_EquipFileBillMain");


                //写入信息


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


                {


@@ -475,49 +504,39 @@


            string msg1 = _value.ToString();


            string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries);


            string msg2 = sArray[0].ToString();


            string msg3 = sArray[1].ToString();




            string UserName = "";




            ListModels oListModels = new ListModels();


            try


            {


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


                List<Models.ClsSb_EquipMaintainBillMain> lsmain = new List<Models.ClsSb_EquipMaintainBillMain>();


                DAL.ClsSb_EquipMaintainBill oBill = new DAL.ClsSb_EquipMaintainBill();


                List<Model.ClsSb_EquipMaintainBillMain> lsmain = new List<Model.ClsSb_EquipMaintainBillMain>();


                msg2 = msg2.Replace("\\", "");


                msg2 = msg2.Replace("\n", "");  //\n


                lsmain = oListModels.getObjectByJson_Sb_EquipMaintainBillMainPDA(msg2);


                foreach (Models.ClsSb_EquipMaintainBillMain oItem in lsmain)


                lsmain = oListModels.getObjectByJson_Sb_EquipMaintainBillMain(msg2);


                foreach (Model.ClsSb_EquipMaintainBillMain oItem in lsmain)


                {


                    //单据号是否重复


                    if (BillNew.IsExistBillNo(ref ClsPub.sExeReturnInfo, oItem.HBillNo, BillStatus, BillOld.omodel.HInterID))


                    {


                        objJsonResult.code = "0";


                        objJsonResult.count = 0;


                        objJsonResult.Message = "单据号重复！不允许保存！";


                        objJsonResult.data = 1;


                        return objJsonResult;


                    }




                    //oItem.HMaker = "";


                    UserName = oItem.HMaker;  //制单人


                    oItem.HBillType = "3901";


                    oItem.HBillSubType = "3901";


                    //oItem.HBillNo = "";    //单据号


                    //oItem.HDate = DBUtility.ClsPub.isDate(DateTime.Now.ToString("yyyy-MM-dd"));//  --日期


                    //oItem.HInnerBillNo = "";  //  --内部单据号


                    oItem.HYear = DBUtility.ClsPub.isLong(DateTime.Now.Year);


                    oItem.HMakeDate = DBUtility.ClsPub.isStrNull(DateTime.Now.ToString("yyyy-MM-dd"));


                    //oItem.HEquipID = 0;    //设备ID(Gy_EquipMent)


                    //oItem.HPeriod = 0;


                    //oItem.HCheckBeginDate = DBUtility.ClsPub.isDate(DateTime.Now.ToString("yyyy-MM-dd"));  //  --维修日期


                    //oItem.HCheckResult = "";     //验收结论--(正常，异常)


                    //oItem.HEmpID = 0;           //验收人(Gy_Employee)


                    //oItem.HManagerID = 0;      //负责人(Gy_Employee)


                    //oItem.HDeptID = 0;        //验收部门(Gy_Department)


                    //oItem.HExplanation = "";  //摘要(故障描述)  


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




                    //oItem.HMainSourceInterID = oItem.HInterID;


                    //oItem.HInterID =0;


                    //oItem.HBillNo = "";


                    oItem.HDate = DBUtility.ClsPub.isDate(DateTime.Now.ToString("yyyy-MM-dd"));//  --日期


                    oItem.HYear = DBUtility.ClsPub.isLong(DateTime.Now.Year);


                    //oItem.HMakeDate = "";


                    //oItem.HYear = "";


                    //oItem.HPeriod = "";


                    //oItem.HRemark = "";


                    //oItem.HCycleUnit = "";


                    //oItem.HCheckCycle = "";


                    //oItem.HBeginDate = "";


                    //oItem.HEndDate = "";


                    //oItem.HInnerBillNo = "";


                    //oItem.HExplanation = "";




                    //oItem.HInterID = DBUtility.ClsPub.CreateBillID_SRMProd("1103", ref DBUtility.ClsPub.sExeReturnInfo);


                    if (DBUtility.ClsPub.isStrNull(oItem.HDate) == "")


@@ -530,34 +549,30 @@


                    }


                    oBill.omodel = oItem;


                }


                //子表体数据




                List<Models.ClsSb_EquipMaintainBillSub> ls = new List<Models.ClsSb_EquipMaintainBillSub>();


                ls = oListModels.getObjectByJson_Sb_EquipMaintainBillSubPDA(msg2);


                //保养项表体数据


                //按 },{来拆分数组 //去掉【和】


                msg3 = msg3.Substring(1, msg3.Length - 2);


                msg3 = msg3.Replace("\\", "");


                msg3 = msg3.Replace("\n", "");  //\n


                //msg2 = msg2.Replace("'", "’");


                List<Model.ClsSc_EquipMaintainBillSub_Item> ls = new List<Model.ClsSc_EquipMaintainBillSub_Item>();


                ls = oListModels.getObjectByJson_Sc_EquipMaintainBillSub_Item(msg3);


                int i = 0;


                foreach (Models.ClsSb_EquipMaintainBillSub oItemSub in ls)


                foreach (Model.ClsSc_EquipMaintainBillSub_Item item in ls)


                {




                    i++;


                    oItemSub.HEntryID = i;




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


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


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


                    item.HEntryID = i;


                    //oItemSub.HCloseMan = "";       //行关闭


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


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


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


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


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


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


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


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


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


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


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


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


                    //oItemSub.HRelationMoney = 0;   //关联金额 


                    //oItemSub.HRepairID = 0;       //维修项目


                    //oItemSub.HRepairExplanation ="";   //维修要求


                    //oItemSub.HMoney = 0;        //维修费用


                    oBill.DetailColl.Add(oItemSub);


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


                    oBill.DetailCol.Add(item);




                }


                //保存