| using Newtonsoft.Json.Linq; | 
| using Pub_Class; | 
| using System; | 
| using System.Collections.Generic; | 
| using System.Data; | 
| using System.Web.Http; | 
| using WebAPI.Models; | 
| namespace WebAPI.Controllers | 
| { | 
|     public class Sb_EquipMaintainBillController : ApiController | 
|     { | 
|         private json objJsonResult = new json(); | 
|         public DataSet ds = new DataSet(); | 
|   | 
|         public DBUtility.ClsPub.Enum_BillStatus BillStatus;//单据状态(新增,修改,浏览,更新单价,变更) | 
|         SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); | 
|         public DAL.ClsSb_EquipDotCheckBill BillNew = new DAL.ClsSb_EquipDotCheckBill();   //对应单据类 | 
|         public DAL.ClsSb_EquipDotCheckBill BillOld = new DAL.ClsSb_EquipDotCheckBill();   //对应单据类 | 
|   | 
|         #region 设备保养计划表 | 
|   | 
|         /// <summary> | 
|         /// 设备保养计划表列表 list列表数据加载 | 
|         /// </summary> | 
|         /// <returns></returns> | 
|         [Route("Sb_EquipMaintainBill/GetEquipMaintainBillList")] | 
|         [HttpGet] | 
|         public object GetEquipMaintainBillList(string sWhere,string user) | 
|         { | 
|             try | 
|             { | 
|                 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"); | 
|                 } | 
|                 else | 
|                 { | 
|                     string sql1 = "select * from h_v_Sc_EquipMaintain where 1 = 1"; | 
|                     string sql = sql1 + sWhere + " order by hmainid desc"; | 
|                     ds = oCN.RunProcReturn(sql, "h_v_Sc_EquipMaintain"); | 
|                 } | 
|   | 
|                 //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) | 
|             { | 
|                 objJsonResult.code = "0"; | 
|                 objJsonResult.count = 0; | 
|                 objJsonResult.Message = "没有返回任何记录!" + ex.ToString(); | 
|                 objJsonResult.data = null; | 
|                 return objJsonResult; | 
|             } | 
|         } | 
|   | 
|         #region sql语句 | 
|   | 
|   | 
|         public static DataSet Sb_EquipMaintainBillList_s(string sWhere) | 
|         { | 
|             return new SQLHelper.ClsCN().RunProcReturn("select * from h_v_Sb_EquipMaintainBillList ", "h_v_Sb_EquipMaintainBillList"); | 
|         } | 
|         #endregion | 
|   | 
|         #region 设备保养计划表 保存/编辑 | 
|         /// <summary> | 
|         /// 保存模具维修单 | 
|         /// </summary> | 
|         /// <param name="msg"></param> | 
|         /// <returns></returns> | 
|         [Route("Sb_EquipMaintainBill/SaveEquipMaintainBillList")] | 
|         [HttpPost] | 
|         public object SaveEquipMaintainBillList([FromBody] JObject msg) | 
|         { | 
|             var _value = msg["msg"].ToString(); | 
|             string msg1 = _value.ToString(); | 
|             string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries); | 
|             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("\\", ""); | 
|                 msg2 = msg2.Replace("\n", "");  //\n | 
|                 lsmain = oListModels.getObjectByJson_Sb_EquipMaintainBillMain(msg2); | 
|                 foreach (Model.ClsSb_EquipMaintainBillMain oItem in lsmain) | 
|                 { | 
|                     //oItem.HMaker = ""; | 
|                     UserName = oItem.HMaker;  //制单人 | 
|                     oItem.HBillType = "3901"; | 
|                     oItem.HBillSubType = "3901"; | 
|   | 
|                     //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) == "") | 
|                     { | 
|                         objJsonResult.code = "0"; | 
|                         objJsonResult.count = 0; | 
|                         objJsonResult.Message = "保存失败!没有单据日期,无法保存!"; | 
|                         objJsonResult.data = 1; | 
|                         return objJsonResult; | 
|                     } | 
|                     oBill.omodel = oItem; | 
|                 } | 
|                 //保养项表体数据 | 
|                 //按 },{来拆分数组 //去掉【和】 | 
|                 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 (Model.ClsSc_EquipMaintainBillSub_Item item in ls) | 
|                 { | 
|   | 
|                     i++; | 
|                     item.HEntryID = i; | 
|                     //oItemSub.HCloseMan = "";       //行关闭 | 
|                     item.HEntryCloseDate = DBUtility.ClsPub.isDate(DateTime.Now); | 
|                     item.HCloseType = false;   //关闭类型 | 
|                     //oItemSub.HRemark = "";         //备注 | 
|                     item.HSourceInterID = 0;     // 源单主内码 | 
|                     item.HSourceEntryID = 0;   //源单子内码 | 
|                     //oItemSub.HSourceBillNo = "";  //源单单号 | 
|                     //oItemSub.HSourceBillType = ""; //源单类型 | 
|                     item.HRelationQty = 0;     //关联数量 | 
|                     oBill.DetailCol.Add(item); | 
|   | 
|                 } | 
|                 //配件表体数据 | 
|                 //按 },{来拆分数组 //去掉【和】 | 
|                 msg4 = msg4.Substring(1, msg4.Length - 2); | 
|                 msg4 = msg4.Replace("\\", ""); | 
|                 msg4 = msg4.Replace("\n", "");  //\n | 
|                                                 //msg2 = msg2.Replace("'", "’"); | 
|                 List<Model.ClsSb_EquipMaintainBillSub> ls1 = new List<Model.ClsSb_EquipMaintainBillSub>(); | 
|                 ls1 = oListModels.getObjectByJson_Sb_EquipMaintainBillSub(msg4); | 
|                 int j = 0; | 
|                 foreach (Model.ClsSb_EquipMaintainBillSub oItemSub in ls1) | 
|                 { | 
|   | 
|                     j++; | 
|                     oItemSub.HEntryID = i; | 
|                     //oItemSub.HCloseMan = "";       //行关闭 | 
|                     oItemSub.HEntryCloseDate = DBUtility.ClsPub.isDate(DateTime.Now); | 
|                     oItemSub.HCloseType = false;   //关闭类型 | 
|                                                    //oItemSub.HRemark = "";         //备注 | 
|                     oItemSub.HSourceInterID = 0;     // 源单主内码 | 
|                     oItemSub.HSourceEntryID = 0;   //源单子内码 | 
|                                                    //oItemSub.HSourceBillNo = "";  //源单单号 | 
|                                                    //oItemSub.HSourceBillType = ""; //源单类型 | 
|                     oItemSub.HRelationQty = 0;     //关联数量 | 
|                                                    //oItemSub.HRelationMoney = 0;   //关联金额 | 
|                                                    //HMaterID = "";//配件代码 | 
|                                                    //HUnitID = "";//单位代码 | 
|                                                    //HQty = "";//实际用量 | 
|                                                    //HQtyMust = "";//单位用量 | 
|                                                    //HRemark = "";//备注 | 
|   | 
|                     oBill.DetailColl.Add(oItemSub); | 
|   | 
|                 } | 
|                 //保存 | 
|                 //保存完毕后处理 | 
|                 bool bResult; | 
|                 if (oBill.omodel.HInterID == 0) | 
|                 { | 
|                     // bResult = oBill.AddBill(ref DBUtility.ClsPub.sExeReturnInfo); | 
|                     bResult = oBill.AddBill(ref DBUtility.ClsPub.sExeReturnInfo); | 
|                 } | 
|                 else | 
|                 { | 
|                     bResult = oBill.ModifyBill(oBill.omodel.HInterID, ref DBUtility.ClsPub.sExeReturnInfo); | 
|                 } | 
|                 if (bResult) | 
|                 { | 
|                     objJsonResult.code = "0"; | 
|                     objJsonResult.count = 1; | 
|                     objJsonResult.Message = "保存成功!"; | 
|                     //WebAPIController.Add_Log("送货单下推", UserName, "生成送货单"); | 
|                     objJsonResult.data = 1; | 
|                     return objJsonResult; | 
|                 } | 
|                 else | 
|                 { | 
|                     objJsonResult.code = "0"; | 
|                     objJsonResult.count = 0; | 
|                     objJsonResult.Message = "保存失败!" + DBUtility.ClsPub.sExeReturnInfo; | 
|                     objJsonResult.data = 1; | 
|                     return objJsonResult; | 
|                 } | 
|             } | 
|             catch (Exception e) | 
|             { | 
|                 objJsonResult.code = "0"; | 
|                 objJsonResult.count = 0; | 
|                 objJsonResult.Message = "保存失败!" + e.ToString(); | 
|                 objJsonResult.data = 1; | 
|                 return objJsonResult; | 
|             } | 
|         } | 
|         #endregion | 
|         #region [设备保养计划表删除功能] | 
|         /// <summary> | 
|         /// 模具维修单删除功能 | 
|         /// </summary> | 
|         /// <returns></returns> | 
|         [Route("Sb_EquipMaintainBill/DeltetEquipMaintainBillList")] | 
|         [HttpGet] | 
|         public object DeltetEquipMaintainBillList(string HInterID,string user) | 
|         { | 
|             //编辑权限 | 
|             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; | 
|             lngBillKey = DBUtility.ClsPub.isLong(HInterID); | 
|             if (lngBillKey == 0) | 
|             { | 
|                 objJsonResult.code = "0"; | 
|                 objJsonResult.count = 0; | 
|                 objJsonResult.Message = "单据ID为空!"; | 
|                 objJsonResult.data = null; | 
|                 return objJsonResult; | 
|             } | 
|             DAL.ClsSb_EquipMaintainBill oBill = new DAL.ClsSb_EquipMaintainBill(); | 
|             if (oBill.ShowBill(lngBillKey, ref DBUtility.ClsPub.sExeReturnInfo)) | 
|             { | 
|                 if (oBill.omodel.HBillStatus > 1) | 
|                 { | 
|                     objJsonResult.code = "0"; | 
|                     objJsonResult.count = 0; | 
|                     objJsonResult.Message = "单据当前处于不能删除状态,不能删除!"; | 
|                     objJsonResult.data = null; | 
|                     return objJsonResult; | 
|                 } | 
|                 if (oBill.omodel.HChecker != "") | 
|                 { | 
|                     objJsonResult.code = "0"; | 
|                     objJsonResult.count = 0; | 
|                     objJsonResult.Message = "单据已经审核,不能删除!"; | 
|                     objJsonResult.data = null; | 
|                     return objJsonResult; | 
|                 } | 
|   | 
|                 bool IsDete = oBill.DeleteBill(oBill.omodel.HInterID, ref DBUtility.ClsPub.sExeReturnInfo); | 
|                 if (IsDete) | 
|                 { | 
|                     objJsonResult.code = "0"; | 
|                     objJsonResult.count = 1; | 
|                     objJsonResult.Message = DBUtility.ClsPub.sExeReturnInfo; | 
|                     objJsonResult.data = null; | 
|                     return objJsonResult; | 
|                 } | 
|                 else | 
|                 { | 
|                     objJsonResult.code = "0"; | 
|                     objJsonResult.count = 0; | 
|                     objJsonResult.Message = DBUtility.ClsPub.sExeReturnInfo; | 
|                     objJsonResult.data = null; | 
|                     return objJsonResult; | 
|                 } | 
|             } | 
|             else | 
|             { | 
|                 objJsonResult.code = "0"; | 
|                 objJsonResult.count = 0; | 
|                 objJsonResult.Message = "单据未找到"; | 
|                 objJsonResult.data = null; | 
|                 return objJsonResult; | 
|             } | 
|         } | 
|         #endregion | 
|   | 
|         #region[设备保养计划表编辑时获取表头数据] | 
|         [Route("Sb_EquipMaintainBill/Sb_EquipMaintainBillListCheckDetai")] | 
|         [HttpGet] | 
|         public ApiResult<DataSet> Sb_EquipMaintainBillListCheckDetai(string HID) | 
|         { | 
|             if (string.IsNullOrEmpty(HID)) | 
|                 return new ApiResult<DataSet> { code = -1, msg = "ID不能为空" }; | 
|             SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); | 
|             var dataSet = oCN.RunProcReturn("select top 1 * from h_v_Sb_EquipMaintainBillList  where hmainid= " + HID + " ", "h_v_Sb_EquipMaintainBillList"); | 
|             if (dataSet == null || dataSet.Tables[0].Rows.Count == 0) | 
|                 return new ApiResult<DataSet> { code = -1, msg = "不存在设备保养记录表" }; | 
|             return new ApiResult<DataSet> { code = 1, msg = "查询成功", data = dataSet }; | 
|         } | 
|         #endregion | 
|         #region[设备保养计划表编辑时获取表体数据(保养子表、配件子表)] | 
|         [Route("Sb_EquipMaintainBill/Sb_EquipMaintainBillListProjectDetai")] | 
|         [HttpGet] | 
|         public object Sb_EquipMaintainBillListProjectDetai(string HInterID) | 
|         { | 
|             DataSet ds, ds1; | 
|             List<object> list = new List<object>(); | 
|             string Swhere = ""; | 
|             try | 
|             { | 
|                 if (HInterID != "" || HInterID != null) | 
|                 { | 
|                     Swhere = " and hmainid='" + HInterID + "'"; | 
|                 } | 
|                 else | 
|                 { | 
|                     Swhere = HInterID; | 
|                 } | 
|                 SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); | 
|                 //获取保养项目编辑数据 | 
|                 string sql = "select HMaintainItemID, 保养项目代码 HMaintainItemNumber,保养项目名称 HMaintainItem,保养部位 HMaintainPart,具体要求 HClaim,HManagerID,负责人代码 HManagerNumber,负责人 HManagerName,表体备注 HRemark  from h_v_Sb_EquipMaintainBillSub_Item where 1 = 1 " + Swhere + ""; | 
|                 ds = oCN.RunProcReturn(sql, "h_v_Sb_EquipMaintainBillSub_Item"); | 
|                 //获取配件项目编辑数据 | 
|                 string sql1 = "select HMaterID, 配件代码 HMaterNumber,配件名称 HMaterName,单位ID HUnitID,单位代码 HUnitNumber,单位名称 HUnitName,实际用量 HQty,标准用量 HQtyMust,表体备注 HRemark,负责人ID HManagerID,负责人代码 HManagerNumber,负责人 HManagerName  from h_v_Sb_EquipMaintainBillList where 1 = 1 " + Swhere + ""; | 
|                 ds1 = oCN.RunProcReturn(sql1, "h_v_Sb_EquipMaintainBillList"); | 
|                 list.Add(ds.Tables[0]); | 
|                 list.Add(ds1.Tables[0]); | 
|                 objJsonResult.code = "0"; | 
|                 objJsonResult.count = 1; | 
|                 objJsonResult.Message = "获取信息成功!"; | 
|                 objJsonResult.list = list; | 
|             } | 
|             catch (Exception e) | 
|             { | 
|                 objJsonResult.code = "0"; | 
|                 objJsonResult.count = 0; | 
|                 objJsonResult.Message = "没有返回任何记录!" + e.ToString(); | 
|                 objJsonResult.data = null; | 
|             } | 
|             return objJsonResult; | 
|         } | 
|         #endregion | 
|   | 
|         #region[设备保养记录表编辑时获取表体数据新(保养项列表、配件项列表)] | 
|         [Route("Sb_EquipMaintainBill/Sb_EquipMaintainBillListProjectDetaiNew")] | 
|         [HttpGet] | 
|         public object Sb_EquipMaintainBillListProjectDetaiNew(string HInterID) | 
|         { | 
|   | 
|             DataSet ds, ds1; | 
|             List<object> list = new List<object>(); | 
|             string Swhere = ""; | 
|             try | 
|             { | 
|                 if (HInterID != "" || HInterID != null) | 
|                 { | 
|                     Swhere = " and hmainid='" + HInterID + "'"; | 
|                 } | 
|                 else | 
|                 { | 
|                     Swhere = HInterID; | 
|                 } | 
|                 SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); | 
|                 //获取保养项目编辑数据 | 
|                 string sql = "select 保养项目ID HMaintainItemID, 保养项目代码 HMaintainItemNumber,保养项目名称 HMaintainItem,保养部位 HMaintainPart,具体要求 HClaim,HManagerID,负责人代码 HManagerNumber,负责人 HManagerName,表体备注 HRemark  from h_v_Sb_EquipMaintainBillSub_Item where 1 = 1 " + Swhere + ""; | 
|                 ds = oCN.RunProcReturn(sql, "h_v_Sb_EquipMaintainBillSub_Item"); | 
|                 //获取配件项目编辑数据 | 
|                 string sql1 = "select HMaterID, 配件代码 HMaterNumber,配件名称 HMaterName,单位ID HUnitID,单位代码 HUnitNumber,单位名称 HUnitName,实际用量 HQty,标准用量 HQtyMust,表体备注 HRemark,负责人ID HManagerID,负责人代码 HManagerNumber,负责人 HManagerName  from h_v_Sb_EquipMaintainBillList where 1 = 1 " + Swhere + ""; | 
|                 ds1 = oCN.RunProcReturn(sql1, "h_v_Sb_EquipMaintainBillList"); | 
|   | 
|                 list.Add(ds.Tables[0]); | 
|                 list.Add(ds1.Tables[0]); | 
|                 objJsonResult.code = "0"; | 
|                 objJsonResult.count = 1; | 
|                 objJsonResult.Message = "获取信息成功!"; | 
|                 objJsonResult.list = list; | 
|             } | 
|             catch (Exception e) | 
|             { | 
|                 objJsonResult.code = "0"; | 
|                 objJsonResult.count = 0; | 
|                 objJsonResult.Message = "没有返回任何记录!" + e.ToString(); | 
|                 objJsonResult.data = null; | 
|             } | 
|             return objJsonResult; | 
|         } | 
|         #endregion | 
|   | 
|   | 
|   | 
|         #endregion | 
|   | 
|   | 
|   | 
|         #region 设备保养记录单PDA | 
|   | 
|         #region 根据设备条码查找设备档案信息PDA | 
|         [Route("Sb_PDA_EquipMaintainBill/txtHBarCode_KeyDown")] | 
|         [HttpGet] | 
|         public object txtHBarCode_KeyDown(string HBarCode) | 
|         { | 
|             try | 
|             { | 
|                 if (HBarCode == null || HBarCode.Equals("")) | 
|                 { | 
|                     objJsonResult.code = "0"; | 
|                     objJsonResult.count = 0; | 
|                     objJsonResult.Message = "条形码不能为空!"; | 
|                     objJsonResult.data = null; | 
|                     return objJsonResult; | 
|                 } | 
|                 //得到信息 | 
|                 ds = oCN.RunProcReturn("select top 1 * from Gy_EquipFileBillMain  where HEquipFileNumber= '" + HBarCode + "'", "Gy_EquipFileBillMain"); | 
|                 //写入信息 | 
|                 if (ds == null || ds.Tables[0].Rows.Count == 0) | 
|                 { | 
|                     objJsonResult.code = "0"; | 
|                     objJsonResult.count = 0; | 
|                     objJsonResult.Message = "未查询到设备信息!"; | 
|                     objJsonResult.data = null; | 
|                     return objJsonResult; | 
|                 } | 
|                 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 | 
|   | 
|         #region 设备保养记录提交PDA | 
|   | 
|         [Route("Sb_PDA_EquipMaintainBill/SaveGetEquipMaintainBillList")] | 
|         [HttpPost] | 
|         public object SaveGetEquipMaintainBillList([FromBody] JObject msg) | 
|         { | 
|             var _value = msg["msg"].ToString(); | 
|             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 | 
|             { | 
|                 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_EquipMaintainBillMain(msg2); | 
|                 foreach (Model.ClsSb_EquipMaintainBillMain oItem in lsmain) | 
|                 { | 
|                     //oItem.HMaker = ""; | 
|                     UserName = oItem.HMaker;  //制单人 | 
|                     oItem.HBillType = "3901"; | 
|                     oItem.HBillSubType = "3901"; | 
|   | 
|                     //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) == "") | 
|                     { | 
|                         objJsonResult.code = "0"; | 
|                         objJsonResult.count = 0; | 
|                         objJsonResult.Message = "保存失败!没有单据日期,无法保存!"; | 
|                         objJsonResult.data = 1; | 
|                         return objJsonResult; | 
|                     } | 
|                     oBill.omodel = oItem; | 
|                 } | 
|                 //保养项表体数据 | 
|                 //按 },{来拆分数组 //去掉【和】 | 
|                 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 (Model.ClsSc_EquipMaintainBillSub_Item item in ls) | 
|                 { | 
|   | 
|                     i++; | 
|                     item.HEntryID = i; | 
|                     //oItemSub.HCloseMan = "";       //行关闭 | 
|                     item.HEntryCloseDate = DBUtility.ClsPub.isDate(DateTime.Now); | 
|                     item.HCloseType = false;   //关闭类型 | 
|                     //oItemSub.HRemark = "";         //备注 | 
|                     item.HSourceInterID = 0;     // 源单主内码 | 
|                     item.HSourceEntryID = 0;   //源单子内码 | 
|                     //oItemSub.HSourceBillNo = "";  //源单单号 | 
|                     //oItemSub.HSourceBillType = ""; //源单类型 | 
|                     item.HRelationQty = 0;     //关联数量 | 
|                     oBill.DetailCol.Add(item); | 
|   | 
|                 } | 
|                 //保存 | 
|                 //保存完毕后处理 | 
|                 bool bResult; | 
|                 if (oBill.omodel.HInterID == 0) | 
|                 { | 
|                     // bResult = oBill.AddBill(ref DBUtility.ClsPub.sExeReturnInfo); | 
|                     bResult = oBill.AddBill(ref DBUtility.ClsPub.sExeReturnInfo); | 
|                 } | 
|                 else | 
|                 { | 
|                     bResult = oBill.ModifyBill(oBill.omodel.HInterID, ref DBUtility.ClsPub.sExeReturnInfo); | 
|                 } | 
|                 if (bResult) | 
|                 { | 
|                     objJsonResult.code = "0"; | 
|                     objJsonResult.count = 1; | 
|                     objJsonResult.Message = "保存成功!"; | 
|                     //WebAPIController.Add_Log("送货单下推", UserName, "生成送货单"); | 
|                     objJsonResult.data = 1; | 
|                     return objJsonResult; | 
|                 } | 
|                 else | 
|                 { | 
|                     objJsonResult.code = "0"; | 
|                     objJsonResult.count = 0; | 
|                     objJsonResult.Message = "保存失败!" + DBUtility.ClsPub.sExeReturnInfo; | 
|                     objJsonResult.data = 1; | 
|                     return objJsonResult; | 
|                 } | 
|             } | 
|             catch (Exception e) | 
|             { | 
|                 objJsonResult.code = "0"; | 
|                 objJsonResult.count = 0; | 
|                 objJsonResult.Message = "保存失败!" + e.ToString(); | 
|                 objJsonResult.data = 1; | 
|                 return objJsonResult; | 
|             } | 
|         } | 
|         #endregion | 
|   | 
|         #endregion | 
|     } | 
| } |