From e85b050a89311f8d6e2558c07d93b8a8f7f5075d Mon Sep 17 00:00:00 2001
From: zzr99 <1940172413@qq.com>
Date: 星期四, 18 十一月 2021 17:55:27 +0800
Subject: [PATCH] 1、设备管理：增加 设备点检规程单，单据列表 2、设备管理：增加 设备保养规程单，单据列表 3、新增编辑设备点检规程单
---
WebAPI/Controllers/SBGL/Sb_EquipMaintainRuleBillController.cs | 175 +++++++++++++++++++
WebAPI/Models/ClsSb_EquipDotCheckRuleBillMain.cs | 17 +
WebAPI/Controllers/SBGL/Sb_EquipDotCheckRuleBillController.cs | 185 ++++++++++++++++++++
WebAPI/DLL/ClsSb_EquipMaintainRuleBill.cs | 37 ++++
WebAPI/Models/ClsSb_EquipDotCheckRuleBillSub.cs | 16 +
WebAPI/Models/ClsSb_EquipMaintainRuleBillSub_Item.cs | 18 ++
WebAPI/DLL/ClsSb_EquipDotCheckRuleBill.cs | 25 ++
WebAPI/Models/ClsSb_EquipMaintainRuleBillMain.cs | 15 +
WebAPI/WebAPI.csproj | 9 +
WebAPI/Models/ClsSb_EquipMaintainRuleBillSub.cs | 17 +
10 files changed, 514 insertions(+), 0 deletions(-)
diff --git a/WebAPI/Controllers/SBGL/Sb_EquipDotCheckRuleBillController.cs b/WebAPI/Controllers/SBGL/Sb_EquipDotCheckRuleBillController.cs
new file mode 100644
index 0000000..0f5157b
--- /dev/null
+++ b/WebAPI/Controllers/SBGL/Sb_EquipDotCheckRuleBillController.cs
@@ -0,0 +1,185 @@
+锘縰sing System;
+using System.Collections.Generic;
+using System.Data;
+using System.Linq;
+using System.Net;
+using System.Net.Http;
+using System.Web.Http;
+using WebAPI.Models;
+
+namespace WebAPI.Controllers.SBGL
+{
+ public class Sb_EquipDotCheckRuleBillController : ApiController
+ {
+ private json objJsonResult = new json();
+ public DataSet ds = new DataSet();
+ public DBUtility.ClsPub.Enum_BillStatus BillStatus;//鍗曟嵁鐘舵�侊紙鏂板锛屼慨鏀癸紝娴忚锛屾洿鏂板崟浠凤紝鍙樻洿锛�
+ SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
+ public DLL.ClsSb_EquipDotCheckRuleBill BillNew = new DLL.ClsSb_EquipDotCheckRuleBill(); //瀵瑰簲鍗曟嵁绫�
+ public DLL.ClsSb_EquipDotCheckRuleBill BillOld = new DLL.ClsSb_EquipDotCheckRuleBill(); //瀵瑰簲鍗曟嵁绫�
+
+
+ #region 璁惧鐐规瑙勭▼鍗曞垪琛�
+ [Route("Sb_EquipDotCheckRuleBill/GetEquipDotCheckRuleList")]
+ [HttpGet]
+ public object GetEquipDotCheckRuleList(string sWhere)
+ {
+ try
+ {
+ if (sWhere == null || sWhere.Equals(""))
+ {
+ ds = oCN.RunProcReturn("select * from h_v_Sb_EquipDotCheckRuleList " + sWhere + " order by hmainid desc", "h_v_Sb_EquipDotCheckRuleList");
+ }
+ else
+ {
+ string sql1 = "select * from h_v_Sb_EquipDotCheckRuleList where 1 = 1";
+ string sql = sql1 + sWhere + " order by hmainid desc";
+ ds = oCN.RunProcReturn(sql, "h_v_Sb_EquipDotCheckRuleList");
+ }
+ 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 = "杩斿洖璁板綍鎴愬姛锛�";
+ 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;
+ }
+ }
+ #endregion
+
+ #region 璁惧鐐规瑙勭▼璁板綍鍒犻櫎鍔熻兘
+ [Route("Sb_EquipDotCheckRuleBill/DeleteEquipDotCheckRuleBillList")]
+ [HttpGet]
+ public object DeleteEquipDotCheckRuleBillList(string HInterID)
+ {
+ 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;
+ }
+ DLL.ClsSb_EquipDotCheckRuleBill oBill = new DLL.ClsSb_EquipDotCheckRuleBill();
+ 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_EquipDotCheckRuleBill/Sb_EquipDotCheckRuleBillListCheckDetai")]
+ [HttpGet]
+ public ApiResult<DataSet> Sb_EquipDotCheckRuleBillListCheckDetai(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_EquipDotCheckRuleList where hmainid= " + HID + " ", "h_v_Sb_EquipDotCheckRuleList");
+ 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_EquipDotCheckRuleBill/Sb_EquipDotCheckRuleBillListProjectDetai")]
+ [HttpGet]
+ public object Sb_EquipDotCheckRuleBillListProjectDetai(string sqlWhere)
+ {
+ DataSet ds;
+ try
+ {
+ SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
+ if (sqlWhere == null || sqlWhere.Equals(""))
+ {
+ ds = oCN.RunProcReturn("select 鐐规椤圭洰ID,鐐规椤圭洰,鐐规閮ㄤ綅,鍏蜂綋瑕佹眰,璐熻矗浜篒D,璐熻矗浜轰唬鐮�,璐熻矗浜�,瀛愬娉� from h_v_Sb_EquipDotCheckRuleList", "h_v_Sb_EquipDotCheckRuleList");
+ objJsonResult.code = "0";
+ objJsonResult.count = 1;
+ objJsonResult.Message = "鑾峰彇淇℃伅鎴愬姛锛�";
+ objJsonResult.data = ds.Tables[0];
+ }
+ else
+ {
+ string sql1 = "select 鐐规椤圭洰ID,鐐规椤圭洰,鐐规閮ㄤ綅,鍏蜂綋瑕佹眰,璐熻矗浜篒D,璐熻矗浜轰唬鐮�,璐熻矗浜�,瀛愬娉� from h_v_Sb_EquipDotCheckRuleList where 1 = 1 ";
+ string sql = sql1 + sqlWhere;
+ ds = oCN.RunProcReturn(sql, "h_v_Sb_EquipDotCheckRuleList");
+ objJsonResult.code = "0";
+ objJsonResult.count = 1;
+ objJsonResult.Message = "鑾峰彇淇℃伅鎴愬姛锛�";
+ objJsonResult.data = ds.Tables[0];
+ }
+ }
+ catch (Exception e)
+ {
+ objJsonResult.code = "0";
+ objJsonResult.count = 0;
+ objJsonResult.Message = "娌℃湁杩斿洖浠讳綍璁板綍锛�" + e.ToString();
+ objJsonResult.data = null;
+ }
+ return objJsonResult;
+ }
+ #endregion
+ }
+}
diff --git a/WebAPI/Controllers/SBGL/Sb_EquipMaintainRuleBillController.cs b/WebAPI/Controllers/SBGL/Sb_EquipMaintainRuleBillController.cs
new file mode 100644
index 0000000..3939dd1
--- /dev/null
+++ b/WebAPI/Controllers/SBGL/Sb_EquipMaintainRuleBillController.cs
@@ -0,0 +1,175 @@
+锘縰sing System;
+using System.Collections.Generic;
+using System.Data;
+using System.Linq;
+using System.Net;
+using System.Net.Http;
+using System.Web.Http;
+using WebAPI.Models;
+
+namespace WebAPI.Controllers.SBGL
+{
+ public class Sb_EquipMaintainRuleBillController : ApiController
+ {
+ private json objJsonResult = new json();
+ public DataSet ds = new DataSet();
+ public DBUtility.ClsPub.Enum_BillStatus BillStatus;//鍗曟嵁鐘舵�侊紙鏂板锛屼慨鏀癸紝娴忚锛屾洿鏂板崟浠凤紝鍙樻洿锛�
+ SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
+ public DLL.ClsSb_EquipMaintainRuleBill BillNew = new DLL.ClsSb_EquipMaintainRuleBill(); //瀵瑰簲鍗曟嵁绫�
+ public DLL.ClsSb_EquipMaintainRuleBill BillOld = new DLL.ClsSb_EquipMaintainRuleBill(); //瀵瑰簲鍗曟嵁绫�
+
+ #region 璁惧淇濆吇瑙勭▼鍗曞垪琛�
+ [Route("Sb_EquipMaintainRuleBill/GetEquipMaintainRuleList")]
+ [HttpGet]
+ public object GetEquipMaintainRuleList(string sWhere)
+ {
+ try
+ {
+ if (sWhere == null || sWhere.Equals(""))
+ {
+ ds = oCN.RunProcReturn("select * from h_v_Sb_EquipMaintainRuleList " + sWhere + " order by hmainid desc", "h_v_Sb_EquipMaintainRuleList");
+ }
+ else
+ {
+ string sql1 = "select * from h_v_Sb_EquipMaintainRuleList where 1 = 1";
+ string sql = sql1 + sWhere + " order by hmainid desc";
+ ds = oCN.RunProcReturn(sql, "h_v_Sb_EquipMaintainRuleList");
+ }
+ 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 = "杩斿洖璁板綍鎴愬姛锛�";
+ 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;
+ }
+ }
+ #endregion
+
+ #region 璁惧淇濆吇瑙勭▼璁板綍鍒犻櫎鍔熻兘
+ [Route("Sb_EquipMaintainRuleBill/DeleteEquipMaintainRuleBillList")]
+ [HttpGet]
+ public object DeleteEquipMaintainRuleBillList(string HInterID)
+ {
+ 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;
+ }
+ DLL.ClsSb_EquipMaintainRuleBill oBill = new DLL.ClsSb_EquipMaintainRuleBill();
+ 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_EquipMaintainRuleBill/Sb_EquipMaintainRuleBillListProjectDetaiNew")]
+ [HttpGet]
+ public object Sb_EquipMaintainRuleBillListProjectDetaiNew(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,淇濆吇椤圭洰,淇濆吇閮ㄤ綅,鍏蜂綋瑕佹眰,璐熻矗浜篒D,璐熻矗浜轰唬鐮�,璐熻矗浜哄悕绉�,瀛愬娉�2 from h_v_Sb_EquipMaintainRuleList where 1 = 1 " + Swhere + "";
+ ds = oCN.RunProcReturn(sql, "h_v_Sb_EquipMaintainRuleList");
+ //鑾峰彇閰嶄欢椤圭洰缂栬緫鏁版嵁
+ string sql1 = "select 閰嶄欢ID,閰嶄欢浠ｇ爜,閰嶄欢鍚嶇О,鍗曚綅ID,璁￠噺鍗曚綅浠ｇ爜,璁￠噺鍗曚綅鍚嶇О,鐢ㄩ噺,鏍囧噯鐢ㄩ噺,瀛愬娉�1 from h_v_Sb_EquipMaintainRuleList where 1 = 1 " + Swhere + "";
+ ds1 = oCN.RunProcReturn(sql1, "h_v_Sb_EquipMaintainRuleList");
+
+ 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
+ }
+}
diff --git a/WebAPI/DLL/ClsSb_EquipDotCheckRuleBill.cs b/WebAPI/DLL/ClsSb_EquipDotCheckRuleBill.cs
new file mode 100644
index 0000000..8d0e535
--- /dev/null
+++ b/WebAPI/DLL/ClsSb_EquipDotCheckRuleBill.cs
@@ -0,0 +1,25 @@
+锘縰sing System;
+using System.Collections.Generic;
+using System.Linq;
+using System.Web;
+
+namespace WebAPI.DLL
+{
+ public class ClsSb_EquipDotCheckRuleBill : DBUtility.ClsXt_BaseBill
+ {
+ public Models.ClsSb_EquipDotCheckRuleBillMain omodel = new Models.ClsSb_EquipDotCheckRuleBillMain();
+ public List<Models.ClsSb_EquipDotCheckRuleBillSub> DetailColl_Mater = new List<Models.ClsSb_EquipDotCheckRuleBillSub>();
+
+ public ClsSb_EquipDotCheckRuleBill()
+ {
+ base.MvarItemKeySub = "ClsSb_EquipDotCheckRuleBillSub";
+ base.MvarItemKeySub2 = "";
+ base.MvarItemKeySub3 = "";
+ base.MvarItemKeySub4 = "";
+ base.MvarItemKey = "Sb_EquipDotCheckRuleBillMain";
+ base.MvarReportTitle = "璁惧鐐规瑙勭▼";
+ base.BillType = "3913";
+ }
+
+ }
+}
\ No newline at end of file
diff --git a/WebAPI/DLL/ClsSb_EquipMaintainRuleBill.cs b/WebAPI/DLL/ClsSb_EquipMaintainRuleBill.cs
new file mode 100644
index 0000000..9a2ee03
--- /dev/null
+++ b/WebAPI/DLL/ClsSb_EquipMaintainRuleBill.cs
@@ -0,0 +1,37 @@
+锘縰sing System;
+using System.Collections.Generic;
+using System.Linq;
+using System.Web;
+
+namespace WebAPI.DLL
+{
+ public class ClsSb_EquipMaintainRuleBill : DBUtility.ClsXt_BaseBill
+ {
+ public Models.ClsSb_EquipMaintainRuleBillMain omodel = new Models.ClsSb_EquipMaintainRuleBillMain();
+ public List<Models.ClsSb_EquipMaintainRuleBillSub> DetailColl_Mater = new List<Models.ClsSb_EquipMaintainRuleBillSub>();
+ public List<Models.ClsSb_EquipMaintainRuleBillSub_Item> DetailColl_Pay = new List<Models.ClsSb_EquipMaintainRuleBillSub_Item>();
+
+ public ClsSb_EquipMaintainRuleBill()
+ {
+ base.MvarItemKeySub = "Sb_EquipMaintainRuleBillSub";
+ base.MvarItemKeySub2 = "Sb_EquipMaintainRuleBillSub_Item";
+ base.MvarItemKeySub3 = "";
+ base.MvarItemKeySub4 = "";
+ base.MvarItemKey = "Sb_EquipMaintainRuleBillMain";
+ base.MvarReportTitle = "璁惧淇濆吇瑙勭▼";
+ base.BillType = "3912";
+ }
+
+ #region 鍥哄畾浠ｇ爜
+
+ ~ClsSb_EquipMaintainRuleBill()
+ {
+ DetailColl_Mater = null;
+ DetailColl_Pay = null;
+ //DetailColl_Entrust = null;
+ //DetailColl_Money = null;
+ }
+
+ #endregion 鑷畾涔夋柟娉�
+ }
+}
\ No newline at end of file
diff --git a/WebAPI/Models/ClsSb_EquipDotCheckRuleBillMain.cs b/WebAPI/Models/ClsSb_EquipDotCheckRuleBillMain.cs
new file mode 100644
index 0000000..1c9fe42
--- /dev/null
+++ b/WebAPI/Models/ClsSb_EquipDotCheckRuleBillMain.cs
@@ -0,0 +1,17 @@
+锘縰sing System;
+using System.Collections.Generic;
+using System.Linq;
+using System.Web;
+
+namespace WebAPI.Models
+{
+ public class ClsSb_EquipDotCheckRuleBillMain : DBUtility.ClsXt_BaseBillMain
+ {
+ public DateTime HBeginDate;// datetime --璁″垝寮�濮嬫棩鏈�
+ public DateTime HEndDate;// datetime --璁″垝缁撴潫鏃ユ湡
+ public string HCycleUnit;// varchar(10) --鍛ㄦ湡鍗曚綅(澶╋紝鏈堬紝鍛�)
+ public int HCheckCycle;// int --鐐规鍛ㄦ湡
+ public string HExplanation;// varchar(500) --鎽樿
+ public string HInnerBillNo;// varchar(50) --鍐呴儴鍗曟嵁鍙�
+ }
+}
\ No newline at end of file
diff --git a/WebAPI/Models/ClsSb_EquipDotCheckRuleBillSub.cs b/WebAPI/Models/ClsSb_EquipDotCheckRuleBillSub.cs
new file mode 100644
index 0000000..005d6f0
--- /dev/null
+++ b/WebAPI/Models/ClsSb_EquipDotCheckRuleBillSub.cs
@@ -0,0 +1,16 @@
+锘縰sing System;
+using System.Collections.Generic;
+using System.Linq;
+using System.Web;
+
+namespace WebAPI.Models
+{
+ public class ClsSb_EquipDotCheckRuleBillSub : DBUtility.ClsXt_BaseBillSub
+ {
+ public int HDotCheckItemID;// int --鐐规椤圭洰ID
+ public string HDotCheckItem;// varchar(100) --鐐规椤圭洰
+ public string HDotCheckPart;// varchar(100) --鐐规閮ㄤ綅
+ public string HClaim;// varchar(100) --鍏蜂綋瑕佹眰
+ public int HManagerID;// int --璐熻矗浜篿d(鑱屽憳琛�)
+ }
+}
\ No newline at end of file
diff --git a/WebAPI/Models/ClsSb_EquipMaintainRuleBillMain.cs b/WebAPI/Models/ClsSb_EquipMaintainRuleBillMain.cs
new file mode 100644
index 0000000..f729114
--- /dev/null
+++ b/WebAPI/Models/ClsSb_EquipMaintainRuleBillMain.cs
@@ -0,0 +1,15 @@
+锘縰sing System;
+using System.Collections.Generic;
+using System.Linq;
+using System.Web;
+
+namespace WebAPI.Models
+{
+ public class ClsSb_EquipMaintainRuleBillMain : DBUtility.ClsXt_BaseBillMain
+ {
+ public string HCycleUnit; //--鍛ㄦ湡鍗曚綅(澶╋紝鏈堬紝鍛�)
+ public int HCheckCycle; //--淇濆吇鍛ㄦ湡
+ public string HExplanation; // varchar(500) --鎽樿
+ public string HInnerBillNo; //varchar(50) --鍐呴儴鍗曟嵁鍙�
+ }
+}
\ No newline at end of file
diff --git a/WebAPI/Models/ClsSb_EquipMaintainRuleBillSub.cs b/WebAPI/Models/ClsSb_EquipMaintainRuleBillSub.cs
new file mode 100644
index 0000000..018b56e
--- /dev/null
+++ b/WebAPI/Models/ClsSb_EquipMaintainRuleBillSub.cs
@@ -0,0 +1,17 @@
+锘縰sing System;
+using System.Collections.Generic;
+using System.Linq;
+using System.Web;
+
+namespace WebAPI.Models
+{
+ public class ClsSb_EquipMaintainRuleBillSub : DBUtility.ClsXt_BaseBillSub
+ {
+ public string HBillNo_bak;
+ public int HItemSubID; // --鑷鍒�(GUID)
+ public int HMaterID; //int --閰嶄欢ID
+ public int HUnitID;// int --璁￠噺鍗曚綅
+ public string HQty;// dec(18,8) --鐢ㄩ噺
+ public string HQtyMust;// dec(18,8) --鏍囧噯鐢ㄩ噺(鏆傛椂闅愯棌)
+ }
+}
\ No newline at end of file
diff --git a/WebAPI/Models/ClsSb_EquipMaintainRuleBillSub_Item.cs b/WebAPI/Models/ClsSb_EquipMaintainRuleBillSub_Item.cs
new file mode 100644
index 0000000..97d1c30
--- /dev/null
+++ b/WebAPI/Models/ClsSb_EquipMaintainRuleBillSub_Item.cs
@@ -0,0 +1,18 @@
+锘縰sing System;
+using System.Collections.Generic;
+using System.Linq;
+using System.Web;
+
+namespace WebAPI.Models
+{
+ public class ClsSb_EquipMaintainRuleBillSub_Item : DBUtility.ClsXt_BaseBillSub
+ {
+ public string HBillNo_bak;
+ public int HItemSubID; // --鑷鍒�(GUID)
+ public int HMaintainItemID;// int --淇濆吇椤圭洰ID
+ public string HMaintainItem;// varchar(100) --淇濆吇椤圭洰
+ public string HMaintainPart; //varchar(100) --淇濆吇閮ㄤ綅
+ public string HClaim;// varchar(100) --鍏蜂綋瑕佹眰
+ public int HManagerID;// int --璐熻矗浜篿d(鑱屽憳琛�)
+ }
+}
\ No newline at end of file
diff --git a/WebAPI/WebAPI.csproj b/WebAPI/WebAPI.csproj
index b6b5440..a65bbd9 100644
--- a/WebAPI/WebAPI.csproj
+++ b/WebAPI/WebAPI.csproj
@@ -357,6 +357,8 @@
<Compile Include="Controllers\ReportPlatFormController.cs" />
<Compile Include="Controllers\SBGL\Gy_EquipFileMainController.cs" />
<Compile Include="Controllers\SBGL\Gy_EquipTypeController.cs" />
+ <Compile Include="Controllers\SBGL\Sb_EquipDotCheckRuleBillController.cs" />
+ <Compile Include="Controllers\SBGL\Sb_EquipMaintainRuleBillController.cs" />
<Compile Include="Controllers\SCGL\Sc_MESProductReportBillController.cs" />
<Compile Include="Controllers\Sc_MouldRepairOutBillController.cs" />
<Compile Include="Controllers\Sc_MouldRepairInBillListController - .cs" />
@@ -416,6 +418,7 @@
<Compile Include="DLL\ClsSb_EquipConkBookBill.cs" />
<Compile Include="DLL\ClsSb_EquipDotCheckBill.cs" />
<Compile Include="DLL\ClsSb_EquipMaintainBill.cs" />
+ <Compile Include="DLL\ClsSb_EquipMaintainRuleBill.cs" />
<Compile Include="DLL\ClsSb_EquipRepairCheckBill.cs" />
<Compile Include="DLL\ClsSb_EquipRepairWorkBill.cs" />
<Compile Include="DLL\ClsSc_ICMOBillWorkQtyStatus_Tmp.cs" />
@@ -447,6 +450,7 @@
<Compile Include="DLL\ClsWW_EntrustProcessReportBill.cs" />
<Compile Include="DLL\ClsWW_EntrustProcessSendOutBill.cs" />
<Compile Include="DLL\ClsWW_EntrustWorkOrderBill.cs" />
+ <Compile Include="DLL\ClsSb_EquipDotCheckRuleBill.cs" />
<Compile Include="LogService.cs" />
<Compile Include="Models\ApiConfig.cs" />
<Compile Include="Models\ApiResult.cs" />
@@ -463,6 +467,11 @@
<Compile Include="Models\ClsKf_MateOutBillSub.cs" />
<Compile Include="Models\ClsOA_InformBillMain.cs" />
<Compile Include="Models\ClsOA_InformBillSub.cs" />
+ <Compile Include="Models\ClsSb_EquipDotCheckRuleBillMain.cs" />
+ <Compile Include="Models\ClsSb_EquipDotCheckRuleBillSub.cs" />
+ <Compile Include="Models\ClsSb_EquipMaintainRuleBillMain.cs" />
+ <Compile Include="Models\ClsSb_EquipMaintainRuleBillSub.cs" />
+ <Compile Include="Models\ClsSb_EquipMaintainRuleBillSub_Item.cs" />
<Compile Include="Models\Pay_PeriodInfoSet.cs" />
<Compile Include="Models\Gy_OrderBackInfo.cs" />
<Compile Include="Models\Gy_OrderLevList.cs" />
--
Gitblit v1.9.1