From 63ae5fc4f972960fa9728a7f4be0a0309c9f7ed6 Mon Sep 17 00:00:00 2001
From: duhe <226547893@qq.com>
Date: 星期四, 08 八月 2024 10:33:07 +0800
Subject: [PATCH] 销售发货看板、采购收料看板
---
WebAPI/Controllers/WebAPIController.cs | 498 +++++++++++++++++++++++++++++++++++++++++++++++-------
1 files changed, 430 insertions(+), 68 deletions(-)
diff --git a/WebAPI/Controllers/WebAPIController.cs b/WebAPI/Controllers/WebAPIController.cs
index b91b18a..db4fc44 100644
--- a/WebAPI/Controllers/WebAPIController.cs
+++ b/WebAPI/Controllers/WebAPIController.cs
@@ -150,21 +150,21 @@
/// <returns></returns>
[Route("Web/GetMAXNumber")]
[HttpGet]
- public object GetMAXNumber(string HBillType,string HName,string TableName)
+ public object GetMAXNumber(string HBillType, string HName, string TableName)
{
try
{
string HNumber = "";
- HNumber = DBUtility.ClsPub.CreateHNumber(HBillType,HName, TableName, ref DBUtility.ClsPub.sExeReturnInfo, true);
+ HNumber = DBUtility.ClsPub.CreateHNumber(HBillType, HName, TableName, ref DBUtility.ClsPub.sExeReturnInfo, true);
//----------鍒涘缓铏氳〃------------------------
DataTable dt_Main = new DataTable("Json");
dt_Main.Columns.Add("HNumber", typeof(string));
-
+
//---------鍒涘缓鏂拌------------------------
DataRow dr_main = dt_Main.NewRow();//鍒涘缓鏂拌
dt_Main.Rows.Add(dr_main);//灏嗘柊琛屽姞鍏ュ埌琛ㄤ腑
dr_main["HNumber"] = DBUtility.ClsPub.isStrNull(HNumber);
-
+
if (HNumber == null)
{
@@ -252,7 +252,7 @@
public object GetUser(string UserName, string PassWord, string HOrgName)
{
try
- {
+ {
DataSet ds = null;
ClsCN oCnLoc = new ClsCN();
DAL.ClsUser oUser = new DAL.ClsUser();
@@ -321,7 +321,7 @@
return objjson;
}
}
- }
+ }
objjson.code = "0";
objjson.count = 1;
objjson.Message = "灞曞紑鎴愬姛锛�";
@@ -474,8 +474,8 @@
// return objJsonResult;
//}
- string sql = "update Gy_Czygl set " +
- "HWhID = " + HWhID +
+ string sql = "update Gy_Czygl set " +
+ "HWhID = " + HWhID +
", HWhName = '" + HWhName +
"', HSecManagerID = " + HSecManagerID +
", HSecManager = '" + HSecManager +
@@ -1289,7 +1289,7 @@
/// <returns></returns>
[Route("Web/GetSouceList_Json")]
[HttpGet]
- public object GetSouceList_Json(string HMaterID,string Value, Int64 HOrgID)
+ public object GetSouceList_Json(string HMaterID, string Value, Int64 HOrgID)
{
sWhere = " and HStopFlag=0 and HUSEORGID =" + HOrgID + "";
if (Value != "" && Value != null)
@@ -1298,7 +1298,7 @@
}
try
{
- string sql = "EXEC h_p_Gy_SouceViewList " + HMaterID+",'"+ sWhere + "'";
+ string sql = "EXEC h_p_Gy_SouceViewList " + HMaterID + ",'" + sWhere + "'";
ds = oCN.RunProcReturn(sql, "h_p_Gy_SouceViewList");
if (ds == null || ds.Tables[0].Rows.Count <= 0)
@@ -1709,7 +1709,7 @@
string sql1 = "Select HItemID,HNumber ,HName from Gy_SellStyle where HStopflag=0 and HEndFlag=1 ";
string sql = sql1 + sWhere;
ds = oCN.RunProcReturn(sql, "Gy_SellStyle");
- }
+ }
if (ds == null || ds.Tables[0].Rows.Count <= 0)
{
@@ -1736,7 +1736,7 @@
objjson.Message = "鑾峰彇澶辫触" + ex.ToString();
objjson.data = null;
return objjson;
- }
+ }
}
/// <summary>
@@ -2948,7 +2948,7 @@
objJsonResult.data = null;
return objJsonResult; ;
}
-
+
oCN.RunProc("delete Gy_ErrType where HItemID=" + HItemID);
oCN.Commit();//鎻愪氦浜嬪姟
@@ -5237,7 +5237,7 @@
objJsonResult.data = null;
return objJsonResult; ;
}
-
+
oCN.RunProc("delete Gy_PostSkill where HItemID=" + HItemID);
oCN.Commit();//鎻愪氦浜嬪姟
@@ -5584,7 +5584,7 @@
WebAPI.DLL.ClsGy_StockMoveStyle_Ctl oBill = new WebAPI.DLL.ClsGy_StockMoveStyle_Ctl();
List<Model.ClsGy_StockMoveStyle_Model> lsmain = new List<Model.ClsGy_StockMoveStyle_Model>();
msg1 = msg1.Replace("\\", "");
- msg1 = msg1.Replace("\n", "");
+ msg1 = msg1.Replace("\n", "");
lsmain = oListModels.getObjectByJson_Gy_StockMoveStyle(msg1);
foreach (Model.ClsGy_StockMoveStyle_Model oItem in lsmain)
{
@@ -8101,7 +8101,7 @@
ListModels oListModels = new ListModels();
try
{
-
+
WebAPI.DLL.ClsGy_ProjectMoney_Ctl oBill = new WebAPI.DLL.ClsGy_ProjectMoney_Ctl();
List<Model.ClsGy_ProjectMoney_Model> lsmain = new List<Model.ClsGy_ProjectMoney_Model>();
msg1 = msg1.Replace("\\", "");
@@ -8310,7 +8310,7 @@
return objJsonResult;
}
oCN.BeginTran();//寮�濮嬩簨鍔�
-
+
ds = oCN.RunProcReturn("select * from Gy_ProjectMoney where HItemID=" + HItemID, "Gy_ProjectMoney");
if (ds.Tables[0].Rows.Count > 0)
{
@@ -8402,7 +8402,7 @@
ListModels oListModels = new ListModels();
try
{
-
+
WebAPI.DLL.ClsGy_ErrMsgBackType_Ctl oBill = new WebAPI.DLL.ClsGy_ErrMsgBackType_Ctl();
List<Model.ClsGy_ErrMsgBackType_Model> lsmain = new List<Model.ClsGy_ErrMsgBackType_Model>();
msg1 = msg1.Replace("\\", "");
@@ -9816,7 +9816,7 @@
}
oCN.BeginTran();//寮�濮嬩簨鍔�
-
+
oCN.RunProc("delete Gy_PreventErrMould where HItemID=" + HItemID);
oCN.Commit();//鎻愪氦浜嬪姟
objJsonResult.code = "0";
@@ -10374,6 +10374,368 @@
objJsonResult.data = null;
return objJsonResult;
}
+ }
+ #endregion
+
+ #region 浼戞伅鏃� 璁剧疆鍒楄〃/淇濆瓨/缂栬緫/鍒犻櫎鏂规硶
+ /// <summary>
+ /// 浼戞伅鏃� 淇濆瓨
+ /// </summary>
+ /// <param name="msg"></param>
+ /// <returns></returns>
+ [Route("SaveGy_RestDayList")]
+ [HttpPost]
+ public object SaveGy_RestDayList([FromBody] JObject msg)
+ {
+ DataSet ds;
+ var _value = msg["msg"].ToString();
+ string msg3 = _value.ToString();
+ string[] sArray = msg3.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries);
+ string msg1 = sArray[0].ToString();
+ string msg2 = sArray[1].ToString();
+
+ //鏌ョ湅鏉冮檺
+ if (!DBUtility.ClsPub.Security_Log("Gy_RestDay_Edit", 1, false, msg2))
+ {
+ objJsonResult.code = "0";
+ objJsonResult.count = 0;
+ objJsonResult.Message = "鏃犱繚瀛樻潈闄愶紒";
+ objJsonResult.data = null;
+ return objJsonResult;
+ }
+
+ Int64 HItemID = 0;
+ SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
+ //鑾峰彇鏈�澶D鍊艰祴鍊�
+ DataSet Maxds = oCN.RunProcReturn("select isNull(MAX(HItemID),0) HItemID from Gy_RestDay ", "Gy_RestDay");
+ if (Maxds != null || Maxds.Tables[0].Rows.Count > 0)
+ {
+ //HItemID= Maxds.Tables[0].Rows[0]["HItemID"]
+ var maxid = Convert.ToInt32(Maxds.Tables[0].Rows[0]["HItemID"]);
+ maxid += 1;
+ HItemID = maxid;
+ }
+ ListModels oListModels = new ListModels();
+ try
+ {
+
+ WebAPI.DLL.ClsGy_RestDay_Ctl oBill = new WebAPI.DLL.ClsGy_RestDay_Ctl();
+ List<Model.ClsGy_RestDay_Model> lsmain = new List<Model.ClsGy_RestDay_Model>();
+ msg1 = msg1.Replace("\\", "");
+ msg1 = msg1.Replace("\n", "");
+ lsmain = oListModels.getObjectByJson_Gy_RestDay(msg1);
+ foreach (Model.ClsGy_RestDay_Model oItem in lsmain)
+ {
+ if (oItem.HNumber.Trim() == "")
+ {
+ objJsonResult.code = "0";
+ objJsonResult.count = 0;
+ objJsonResult.Message = "淇濆瓨澶辫触锛佷唬鐮佷笉鑳戒负绌猴紒";
+ objJsonResult.data = 1;
+ return objJsonResult;
+ }
+ if (oItem.HName.Trim() == "")
+ {
+ objJsonResult.code = "0";
+ objJsonResult.count = 0;
+ objJsonResult.Message = "淇濆瓨澶辫触锛佸悕绉颁笉鑳戒负绌猴紒";
+ objJsonResult.data = 1;
+ return objJsonResult;
+ }
+ if (!DBUtility.ClsPub.AllowNumber(oItem.HNumber.Trim()))
+ {
+ objJsonResult.code = "0";
+ objJsonResult.count = 0;
+ objJsonResult.Message = "淇濆瓨澶辫触锛佷唬鐮佷腑涓嶈兘鍑虹幇杩炵画鈥�.鈥欏苟涓旈浣嶆湯浣嶄笉鑳戒负鈥�.鈥欙紒";
+ objJsonResult.data = 1;
+ return objJsonResult;
+ }
+ //寰楀埌鐭唬鐮�
+ string sShortNumber;
+ sShortNumber = DBUtility.ClsPub.GetShortNumber(oItem.HNumber.Trim());
+ if (sShortNumber.Trim() == "")
+ {
+ objJsonResult.code = "0";
+ objJsonResult.count = 0;
+ objJsonResult.Message = "淇濆瓨澶辫触锛佺煭浠ｇ爜涓虹┖锛�";
+ objJsonResult.data = 1;
+ return objJsonResult;
+ }
+ oItem.HShortNumber = sShortNumber;//鐭唬鐮�
+ oItem.HEndFlag = true;//鏈骇鏍囧織
+ oItem.HLevel = DBUtility.ClsPub.GetLevel(oItem.HNumber.Trim()); //绛夌骇
+ oItem.HMakeEmp = msg2; //鍒涘缓浜�
+ DayOfWeek dayOfWeek = oItem.HRestDay.DayOfWeek;
+
+ // 瀹氫箟鏄熸湡鍑犵殑涓枃鏄犲皠鍏崇郴
+ Dictionary<DayOfWeek, string> chineseDayOfWeek = new Dictionary<DayOfWeek, string>
+ {
+ { DayOfWeek.Sunday, "鏄熸湡鏃�" },
+ { DayOfWeek.Saturday, "鏄熸湡鍏�" }
+ };
+
+ // 鑾峰彇涓枃鏄熸湡鍑犲悕绉�
+ oItem.HWeekDay = chineseDayOfWeek[dayOfWeek];
+ oBill.oModel = oItem;
+ }
+
+ //淇濆瓨
+ //淇濆瓨瀹屾瘯鍚庡鐞�
+ bool bResult;
+ if (oBill.oModel.HItemID == 0)
+ {
+ // bResult = oBill.AddBill(ref DBUtility.ClsPub.sExeReturnInfo);
+ bResult = oBill.AddNew();
+ }
+ else
+ {
+ bResult = oBill.ModifyByID(oBill.oModel.HItemID);
+ }
+ if (bResult)
+ {
+ objJsonResult.code = "0";
+ objJsonResult.count = 1;
+ objJsonResult.Message = "淇濆瓨鎴愬姛锛�";
+ objJsonResult.data = 1;
+ return objJsonResult;
+ }
+ else
+ {
+ objJsonResult.code = "0";
+ objJsonResult.count = 0;
+ objJsonResult.Message = "淇濆瓨澶辫触锛佹暟鎹凡瀛樺湪!";
+ objJsonResult.data = 1;
+ return objJsonResult;
+ }
+ }
+ catch (Exception e)
+ {
+ objJsonResult.code = "0";
+ objJsonResult.count = 0;
+ objJsonResult.Message = "淇濆瓨澶辫触锛�" + e.ToString();
+ objJsonResult.data = 1;
+ return objJsonResult;
+ }
+ }
+
+ /// <summary>
+ /// 浼戞伅鏃� 淇濆瓨
+ /// </summary>
+ /// <param name="msg"></param>
+ /// <returns></returns>
+ [Route("SaveSumGy_RestDayList")]
+ [HttpPost]
+ public object SaveSumGy_RestDayList([FromBody] JObject msg)
+ {
+ DataSet ds;
+ var _value = msg["msg"].ToString();
+ string msg3 = _value.ToString();
+ string[] sArray = msg3.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries);
+ string msg1 = sArray[0].ToString();
+ string msg2 = sArray[1].ToString();
+
+ //鏌ョ湅鏉冮檺
+ if (!DBUtility.ClsPub.Security_Log("Gy_RestDay_Edit", 1, false, msg2))
+ {
+ objJsonResult.code = "0";
+ objJsonResult.count = 0;
+ objJsonResult.Message = "鏃犱繚瀛樻潈闄愶紒";
+ objJsonResult.data = null;
+ return objJsonResult;
+ }
+
+
+ JObject msgObj = JObject.Parse(msg1);
+ string HYear = msgObj["HYear"].ToString();
+ string HNumber1 = msgObj["HDeptNumber"].ToString()+'-' + msgObj["HOrgNumber"].ToString();
+ string HName1 = msgObj["HDeptName"].ToString()+'-'+msgObj["HOrgName"].ToString();
+ string HOrgID = msgObj["HOrgID"].ToString();
+ string HDeptID = msgObj["HDeptID"].ToString();
+ bool HStopflag = bool.Parse(msgObj["HStopflag"].ToString());
+ string HRemark= msgObj["HRemark"].ToString();
+ string HUSEORGID= msgObj["HUSEORGID"].ToString();
+ string HHelpCode= msgObj["HHelpCode"].ToString();
+ string HMakeEmp = msg2; //鍒涘缓浜�
+ bool Sunday = Convert.ToBoolean(msgObj["Sunday"]);
+ bool Saturday = Convert.ToBoolean(msgObj["Saturday"]);
+ List<Tuple<DateTime, string>> sundaysInYear = GetSundaysInYear(Convert.ToInt32(HYear), Sunday, Saturday);
+
+ foreach (var oItem in sundaysInYear)
+ {
+ Int64 HItemID = 0;
+ SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
+ //鑾峰彇鏈�澶D鍊艰祴鍊�
+ DataSet Maxds = oCN.RunProcReturn("select isNull(MAX(HItemID),0) HItemID from Gy_RestDay ", "Gy_RestDay");
+ if (Maxds != null || Maxds.Tables[0].Rows.Count > 0)
+ {
+ //HItemID= Maxds.Tables[0].Rows[0]["HItemID"]
+ var maxid = Convert.ToInt32(Maxds.Tables[0].Rows[0]["HItemID"]);
+ maxid += 1;
+ HItemID = maxid;
+ }
+ DateTime HRestDay = oItem.Item1;
+ string HWeekDay = oItem.Item2; // 鑾峰彇鏄熸湡瀛楃涓�
+ string HDate = oItem.Item1.ToString("yyyyMMdd");
+ string HNumber = "";
+ string HName = "";
+ HNumber = HNumber1 + '-' + HDate;
+
+ HName = HName1 + '-' + HDate;
+ //鍏堟煡鐪嬫暟鎹簱鏈夋病鏈�
+ ds = oCN.RunProcReturn("select * from Gy_RestDay where HRestDay='" + HRestDay + "' and HOrgID='" + HOrgID + "' and HDeptID='" + HDeptID + "'", "Gy_RestDay");
+ if (ds.Tables[0].Rows.Count<1)
+ {
+ oCN.RunProc("Insert into Gy_RestDay " +
+ " (HNumber,HName,HHelpCode,HShortNumber,HParentID" +
+ ",HLevel,HEndFlag,HStopflag,HRemark,HMakeTime,HUSEORGID,HUseFlag,HMakeEmp,HCREATEORGID," +
+ "HOrgID,HDeptID,HRestDay,HWeekDay) " +
+ " Values('" + HNumber + "','" + HName + "','" + HHelpCode + "',''," + 0 +
+ "," + 0 + "," + 0 + "," + Convert.ToString(HStopflag ? 1 : 0) + ",'" + HRemark + "','" + DateTime.Now + "','" + HUSEORGID + "',' 鏈娴�','" + HMakeEmp + "','" + HUSEORGID + "'" +
+ ",'" + HOrgID.ToString() + "','" + HDeptID.ToString() + "','" + HRestDay.ToString() + "','" + HWeekDay.ToString() + "')");
+ }
+ }
+ objJsonResult.code = "0";
+ objJsonResult.count = 1;
+ objJsonResult.Message = "淇濆瓨鎴愬姛锛�";
+ objJsonResult.data = 1;
+ return objJsonResult;
+ }
+
+ /// <summary>
+ /// 浼戞伅鏃� 鑾峰彇淇℃伅
+ /// </summary>
+ /// <returns></returns>
+ [Route("GetGy_RestDayDetailEdit")]
+ [HttpGet]
+ public ApiResult<DataSet> GetGy_RestDayDetailEdit(string HID)
+ {
+ var model = LuBaoSevice.GetGy_RestDayDetailEdit(HID);
+ return model;
+ }
+
+ /// <summary>
+ /// 浼戞伅鏃� 鑾峰彇淇℃伅
+ /// </summary>
+ /// <returns></returns>
+ [Route("GetGy_RestDayDetail")]
+ [HttpGet]
+ public ApiResult<DataSet> GetGy_RestDayDetail(string HName)
+ {
+ var model = LuBaoSevice.GetGy_RestDayDetail(HName);
+ return model;
+ }
+
+ /// <summary>
+ /// 浼戞伅鏃� 鍒犻櫎鍔熻兘
+ /// </summary>
+ /// <returns></returns>
+ [Route("DeltetGy_RestDay")]
+ [HttpGet]
+ public object DeltetGy_RestDay(string HItemID, string user)
+ {
+ DataSet ds;
+ try
+ {
+ //鍒犻櫎鏉冮檺
+ if (!DBUtility.ClsPub.Security_Log("Gy_RestDay_Delete", 1, false, user))
+ {
+ objJsonResult.code = "0";
+ objJsonResult.count = 0;
+ objJsonResult.Message = "鏃犲垹闄ゆ潈闄愶紒";
+ objJsonResult.data = null;
+ return objJsonResult;
+ }
+
+ SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
+ if (string.IsNullOrWhiteSpace(HItemID))
+ {
+ objJsonResult.code = "0";
+ objJsonResult.count = 0;
+ objJsonResult.Message = "HItemID涓虹┖锛�";
+ objJsonResult.data = null;
+ return objJsonResult;
+ }
+ oCN.BeginTran();//寮�濮嬩簨鍔�
+
+
+ oCN.RunProc("delete Gy_RestDay where HItemID=" + HItemID);
+ oCN.Commit();//鎻愪氦浜嬪姟
+ objJsonResult.code = "0";
+ objJsonResult.count = 1;
+ objJsonResult.Message = "鏁版嵁鍒犻櫎鎴愬姛锛�";
+ objJsonResult.data = null;
+ return objJsonResult; ;
+
+ }
+ catch (Exception e)
+ {
+ objJsonResult.code = "0";
+ objJsonResult.count = 0;
+ objJsonResult.Message = "鍒犻櫎澶辫触锛�" + e.ToString();
+ objJsonResult.data = null;
+ return objJsonResult;
+ }
+ }
+
+ //鑾峰彇涓�骞翠腑鐨勫懆鍏�,鍛ㄦ棩鎴栬�呬袱涓悓鏃惰幏鍙�
+ public List<Tuple<DateTime, string>> GetSundaysInYear(int HYear, bool Sunday,bool Saturday)
+ {
+ List<Tuple<DateTime, string>> Days = new List<Tuple<DateTime, string>>();
+ DateTime startDate = new DateTime(HYear, 1, 1);
+ DateTime endDate = new DateTime(HYear, 12, 31);
+ //鏄熸湡澶╁嬀閫�
+ if (Sunday && !Saturday)
+ {
+ while (startDate <= endDate)
+ {
+ if (startDate.DayOfWeek == DayOfWeek.Sunday)
+ {
+ Days.Add(Tuple.Create(startDate, "鏄熸湡澶�"));
+ }
+ startDate = startDate.AddDays(1);
+ }
+ }
+ //鏄熸湡鍏� 鍕鹃��
+ else if (!Sunday && Saturday)
+ {
+ while (startDate <= endDate)
+ {
+ if (startDate.DayOfWeek == DayOfWeek.Saturday)
+ {
+ Days.Add(Tuple.Create(startDate, "鏄熸湡鍏�"));
+ }
+ startDate = startDate.AddDays(1);
+ }
+ }
+ else if (Sunday && Saturday)
+ {
+ while (startDate <= endDate)
+ {
+ if (startDate.DayOfWeek == DayOfWeek.Saturday || startDate.DayOfWeek == DayOfWeek.Sunday)
+ {
+ string weekdayChinese;
+ if (startDate.DayOfWeek == DayOfWeek.Sunday)
+ {
+ weekdayChinese = "鏄熸湡澶�";
+ Days.Add(Tuple.Create(startDate, weekdayChinese));
+ }
+ else if (startDate.DayOfWeek == DayOfWeek.Saturday)
+ {
+ weekdayChinese = "鏄熸湡鍏�";
+ Days.Add(Tuple.Create(startDate, weekdayChinese));
+ }
+ }
+ startDate = startDate.AddDays(1);
+ }
+ }
+ return Days;
+ }
+
+ //杩斿洖鐨勫瓧娈�
+ public class DayOfWeekInfo
+ {
+ public DateTime Date { get; set; }
+ public string DayOfWeekText { get; set; }
}
#endregion
@@ -11497,7 +11859,7 @@
/// <returns></returns>
[Route("Web/GetSc_ICMOBillListView3")]
[HttpGet]
- public object GetSc_ICMOBillListView3(string ICMOBill, int OrganizationID,int HSourceID)
+ public object GetSc_ICMOBillListView3(string ICMOBill, int OrganizationID, int HSourceID)
{
if (ICMOBill != "")
{
@@ -11552,7 +11914,7 @@
[HttpGet]
public object GetSc_ProcessExchangeBillListView(string ICMOBill, int OrganizationID)
{
- if (ICMOBill != "")
+ if (ICMOBill != "" & ICMOBill != null)
{
sWhere = " where 1=1 and 鍗曟嵁鍙� like '%" + ICMOBill + "%' ";
}
@@ -11561,7 +11923,7 @@
SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
if (sWhere == null || sWhere.Equals(""))
{
- ds = oCN.RunProcReturn("select * from h_v_Sc_ProcessExchangeBillList where 1=1 order by 鍗曟嵁鍙� desc,hsubid ", "h_v_Sc_ProcessExchangeBillList");
+ ds = oCN.RunProcReturn(" select * from h_v_Sc_ProcessExchangeBillList where 1=1 and 鏃ユ湡>=DATEADD(MONTH,-2,GETDATE()) order by 鍗曟嵁鍙� desc,hsubid", "h_v_Sc_ProcessExchangeBillList");
}
else
{
@@ -11865,7 +12227,7 @@
/// <returns></returns>
[Route("Web/GetCheckItemByCheckProjectID")]
[HttpGet]
- public object GetCheckItemByCheckProjectID(int CheckProjectID,int HBatchQty)
+ public object GetCheckItemByCheckProjectID(int CheckProjectID, int HBatchQty)
{
if (CheckProjectID <= 0)
{
@@ -11984,17 +12346,17 @@
DataSet ds2;
DataSet ds1;
- // string sql1 = string.Format(@"select t.HMaintainItemID ,m.HNumber HMaintainItemNumber,t.HMaintainItem,t.HMaintainPart,t.HClaim,t.HManagerID,e.HNumber HManagerNumber,e.HName HManagerName,a.HRemark
- // from Sc_MouldMaintainRuleBillMain a left join Sc_MouldMaintainRuleBillSub_Item t on a.HInterID=t.HInterID
- // left join Gy_Maintain m on m.HItemID=t.HMaintainItemID
- // left join Gy_Employee e on e.HItemID=t.HManagerID
- // where a.HInterID=" + MouldMaintainRuleID);
+ // string sql1 = string.Format(@"select t.HMaintainItemID ,m.HNumber HMaintainItemNumber,t.HMaintainItem,t.HMaintainPart,t.HClaim,t.HManagerID,e.HNumber HManagerNumber,e.HName HManagerName,a.HRemark
+ // from Sc_MouldMaintainRuleBillMain a left join Sc_MouldMaintainRuleBillSub_Item t on a.HInterID=t.HInterID
+ // left join Gy_Maintain m on m.HItemID=t.HMaintainItemID
+ // left join Gy_Employee e on e.HItemID=t.HManagerID
+ // where a.HInterID=" + MouldMaintainRuleID);
- // string sql2 = string.Format(@"select b.HMaterID,m.HNumber HMaterNumber,m.HName HMaterName, m.HModel HMaterSpec,b.HUnitID,u.HNumber HUnitNumber,u.HName HUnitName,b.HQty,b.HQtyMust,b.HRemark from Sc_MouldMaintainRuleBillMain a
- //left join Sc_MouldMaintainRuleBillSub b on a.HInterID=b.HInterID
- // left join h_v_IF_Material m on b.HMaterID=m.HItemID
- //left join h_v_IF_Unit u on b.HUnitID=u.HItemID
- // where a.HInterID=" + MouldMaintainRuleID);
+ // string sql2 = string.Format(@"select b.HMaterID,m.HNumber HMaterNumber,m.HName HMaterName, m.HModel HMaterSpec,b.HUnitID,u.HNumber HUnitNumber,u.HName HUnitName,b.HQty,b.HQtyMust,b.HRemark from Sc_MouldMaintainRuleBillMain a
+ //left join Sc_MouldMaintainRuleBillSub b on a.HInterID=b.HInterID
+ // left join h_v_IF_Material m on b.HMaterID=m.HItemID
+ //left join h_v_IF_Unit u on b.HUnitID=u.HItemID
+ // where a.HInterID=" + MouldMaintainRuleID);
string sql1 = string.Format(@"select * from h_v_Sc_MouldMaintainRuleBillSub_Item where hmainid=" + MouldMaintainRuleID);
string sql2 = string.Format(@"select * from h_v_Sc_MouldMaintainRuleBillSub where hmainid=" + MouldMaintainRuleID);
@@ -12134,16 +12496,16 @@
List<object> list = new List<object>();
DataSet ds2;
DataSet ds1;
- // string sql1 = string.Format(@"select t.HMaintainItemID HMaintainItemID,m.HNumber HMaintainItemNumber,t.HMaintainItem HMaintainItem,t.HMaintainPart HMaintainPart,t.HClaim HClaim,t.HManagerID HManagerID,e.HNumber HManagerNumber,e.HName HManagerName,a.HRemark
- // from Sb_EquipMaintainRuleBillMain a left join Sb_EquipMaintainRuleBillSub_Item t on a.HInterID=t.HInterID
- // left join Gy_Maintain m on m.HItemID=t.HMaintainItemID
- // left join Gy_Employee e on e.HItemID=t.HManagerID
- // where a.HInterID=" + EquipProjectID);
- // string sql2 = string.Format(@"select b.HMaterID,m.HNumber HMaterNumber,m.HName HMaterName,b.HUnitID,u.HNumber HUnitNumber,u.HName HUnitName,b.HQty,b.HRemark from Sb_EquipMaintainRuleBillMain a
- //left join Sb_EquipMaintainRuleBillSub b on a.HInterID=b.HInterID
- // left join h_v_IF_Material m on b.HMaterID=m.HItemID
- //left join h_v_IF_Unit u on b.HUnitID=u.HItemID
- // where a.HInterID=" + EquipProjectID);
+ // string sql1 = string.Format(@"select t.HMaintainItemID HMaintainItemID,m.HNumber HMaintainItemNumber,t.HMaintainItem HMaintainItem,t.HMaintainPart HMaintainPart,t.HClaim HClaim,t.HManagerID HManagerID,e.HNumber HManagerNumber,e.HName HManagerName,a.HRemark
+ // from Sb_EquipMaintainRuleBillMain a left join Sb_EquipMaintainRuleBillSub_Item t on a.HInterID=t.HInterID
+ // left join Gy_Maintain m on m.HItemID=t.HMaintainItemID
+ // left join Gy_Employee e on e.HItemID=t.HManagerID
+ // where a.HInterID=" + EquipProjectID);
+ // string sql2 = string.Format(@"select b.HMaterID,m.HNumber HMaterNumber,m.HName HMaterName,b.HUnitID,u.HNumber HUnitNumber,u.HName HUnitName,b.HQty,b.HRemark from Sb_EquipMaintainRuleBillMain a
+ //left join Sb_EquipMaintainRuleBillSub b on a.HInterID=b.HInterID
+ // left join h_v_IF_Material m on b.HMaterID=m.HItemID
+ //left join h_v_IF_Unit u on b.HUnitID=u.HItemID
+ // where a.HInterID=" + EquipProjectID);
string sql1 = string.Format(@"select * from h_v_Sb_EquipMaintainRuleBillList where HInterID=" + EquipProjectID);
string sql2 = string.Format(@"select * from h_v_Sb_EquipMaintainRuleSub where hmainid=" + EquipProjectID);
@@ -12228,7 +12590,7 @@
/// <returns></returns>
[Route("Web/GetItemByEquipFile")]
[HttpGet]
- public object GetItemByEquipFile(int EquipProjectID,string Type,string HDate)
+ public object GetItemByEquipFile(int EquipProjectID, string Type, string HDate)
{
if (EquipProjectID <= 0)
{
@@ -12311,7 +12673,7 @@
{
case "DJ":
HView = "h_v_QJ_GetDotCheckItemList";
- break;
+ break;
default:
objjson.code = "0";
objjson.count = 0;
@@ -12369,8 +12731,8 @@
}
try
{
-
- string sql = string.Format(@"select * from h_v_QJ_GetDotCheckItemList where 鐐规璁″垝ID = " + HInterID );
+
+ string sql = string.Format(@"select * from h_v_QJ_GetDotCheckItemList where 鐐规璁″垝ID = " + HInterID);
ds = oCN.RunProcReturn(sql, "h_v_QJ_GetDotCheckItemList");
if (ds == null || ds.Tables[0].Rows.Count <= 0)
{
@@ -12405,8 +12767,8 @@
/// <returns></returns>
[Route("Web/GetEquipmentBillsList")]
[HttpGet]
- public object GetEquipmentBillsList(string sWhere, string Type,string user)
- {
+ public object GetEquipmentBillsList(string sWhere, string Type, string user)
+ {
try
{
List<object> columnNameList = new List<object>();
@@ -12807,26 +13169,26 @@
/// <returns></returns>
[Route("Web/GetHSourceBillType")]
[HttpGet]
- public object GetHSourceBillType(string HName,int Num)
+ public object GetHSourceBillType(string HName, int Num)
{
try
{
ClsCN oCn = new ClsCN();
DataSet oDs = new DataSet();
//鏈夌殑鍗曞瓙婧愬崟鍒嗕负绾㈣摑鍗� 0浠ｈ〃钃濆崟 1浠ｈ〃绾㈠崟
- if (Num==0)
+ if (Num == 0)
{ //婧愬崟涓鸿摑鍗�
- oDs = oCn.RunProcReturn("select * from Xt_BillSourceSet where HName='" + HName + "'and HRedBlueFlag ='"+ Num+"' ", "Xt_BillSourceSet");
+ oDs = oCn.RunProcReturn("select * from Xt_BillSourceSet where HName='" + HName + "'and HRedBlueFlag ='" + Num + "' ", "Xt_BillSourceSet");
}
- else if (Num==1)
+ else if (Num == 1)
{ //婧愬崟涓虹孩鍗�
oDs = oCn.RunProcReturn("select * from Xt_BillSourceSet where HName='" + HName + "' and HRedBlueFlag ='" + Num + "' ", "Xt_BillSourceSet");
}
- else if(Num==2)
+ else if (Num == 2)
{ //涓嶅垎绾㈣摑鍗�
oDs = oCn.RunProcReturn("select * from Xt_BillSourceSet where HName='" + HName + "'", "Xt_BillSourceSet");
}
-
+
objjson.code = "1";
objjson.count = 1;
objjson.Message = "鑾峰彇鎴愬姛锛�";
@@ -12901,7 +13263,7 @@
SQLHelper.ClsCN oCn = new SQLHelper.ClsCN(); //鏁版嵁搴撴搷浣滃伐鍏�
string sql = "select HItemID,HPartentID,HNumber,HName,HLevel,Hurl,HType,HPicNum from Gy_MenuDefineSet where HMakeName = '" + HMakeName + "' and HType = '" + HType + "' order by HPosition";
ds = oCn.RunProcReturn(sql, "Gy_MenuDefineSet"); //鏌ヨ褰撳墠鐢ㄦ埛鐨勮嚜瀹氫箟鑿滃崟鏁版嵁
- if (ds.Tables[0]==null || ds.Tables[0].Rows.Count == 0) //鍒ゆ柇褰撳墠鐢ㄦ埛鏄惁鏈夎缃繃鑷畾涔変俊鎭紝鑻ヨ褰曟暟涓�0锛屽垯娌℃湁璁剧疆杩囷紝鍔犺浇鎵�鏈夌殑鑿滃崟淇℃伅
+ if (ds.Tables[0] == null || ds.Tables[0].Rows.Count == 0) //鍒ゆ柇褰撳墠鐢ㄦ埛鏄惁鏈夎缃繃鑷畾涔変俊鎭紝鑻ヨ褰曟暟涓�0锛屽垯娌℃湁璁剧疆杩囷紝鍔犺浇鎵�鏈夌殑鑿滃崟淇℃伅
{
sql = "Select * from Gy_Menu_1 where HType = '" + HType + "' Order by HPosition,len(HitemID),HitemID ";
ds = oCn.RunProcReturn(sql, "Gy_Menu");
@@ -13026,7 +13388,7 @@
List<MenuInit> menuInitList = new List<MenuInit>(); //鐢ㄤ互鑾峰彇Gy_Menu_1涓殑鎵�鏈夎彍鍗曚俊鎭紝浠ュ強瀵瑰簲鑺傜偣鏄惁琚�変腑闇�瑕佸姞杞芥樉绀�
SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
- ds = oCn.RunProcReturn("Select * from Gy_Menu_1 where HType = '" +HType + "' Order by HItemID ", "Gy_Menu"); //鑾峰彇Gy_Menu_1涓殑鎵�鏈夎彍鍗曚俊鎭紝鐢ㄤ簬涓簃enuInitList鍒楄〃鍏呭疄鏁版嵁
+ ds = oCn.RunProcReturn("Select * from Gy_Menu_1 where HType = '" + HType + "' Order by HItemID ", "Gy_Menu"); //鑾峰彇Gy_Menu_1涓殑鎵�鏈夎彍鍗曚俊鎭紝鐢ㄤ簬涓簃enuInitList鍒楄〃鍏呭疄鏁版嵁
DataSet ds1 = new DataSet();
for (int i = 0; i < ds.Tables[0].Rows.Count; i++) //灏咷y_Menu_1涓殑鑿滃崟淇℃伅鍙婇�変腑鎯呭喌淇濆瓨鍒癿enuInitList鍒楄〃涓紝
@@ -13123,16 +13485,16 @@
//璁剧疆鏁版嵁搴撴搷浣滅殑鍥炴粴鐐癸紝鑻ュ湪鎻愪氦鍓嶆姤閿欙紝鍒欏洖婊氬埌璇ョ偣锛屾湡闂存搷浣滃彇娑�
oCN.BeginTran();
-
+
//鍒犻櫎褰撳墠鐢ㄦ埛鐨勮嚜瀹氫箟鏁版嵁
string sql = "delete from Gy_MenuDefineSet where HMakeName = '" + HMakeName + "' and HType = '" + HTypes + "'";
oCN.RunProc(sql);
//鎻掑叆褰撳墠鐢ㄦ埛鏈�鏂扮殑鑷畾涔夋暟鎹�
- for(int i=0;i< saveDataList.Count; i++)
+ for (int i = 0; i < saveDataList.Count; i++)
{
sql = "select * from Gy_Menu_1 where HItemID = '" + saveDataList[i].HItemID + "'";
- ds = oCn.RunProcReturn(sql,"Gy_Menu_1");
+ ds = oCn.RunProcReturn(sql, "Gy_Menu_1");
if (ds.Tables[0].Rows.Count > 0)
{
string HPartentID = ds.Tables[0].Rows[0]["HPartentID"].ToString();
@@ -13142,7 +13504,7 @@
string HType = ds.Tables[0].Rows[0]["HType"].ToString();
string HPicNum = ds.Tables[0].Rows[0]["HPicNum"].ToString();
- if(HPartentID == "0" || HPartentID == ds.Tables[0].Rows[0]["HItemID"].ToString())
+ if (HPartentID == "0" || HPartentID == ds.Tables[0].Rows[0]["HItemID"].ToString())
{
string HPosition = ds.Tables[0].Rows[0]["HPosition"].ToString();
sql = "insert into Gy_MenuDefineSet(HItemID,HPartentID,HNumber,HName,HLevel,Hurl,HType,HMakeName,HPicNum,HPosition) values('" + saveDataList[i].HItemID + "','" + HPartentID + "','" + HNumber + "','" + saveDataList[i].HName + "'," + HLevel + ",'" + Hurl + "','" + HType + "','" + HMakeName + "','" + HPicNum + "','" + HPosition + "')";
@@ -13153,12 +13515,12 @@
sql = "insert into Gy_MenuDefineSet(HItemID,HPartentID,HNumber,HName,HLevel,Hurl,HType,HMakeName,HPicNum,HPosition) values('" + saveDataList[i].HItemID + "','" + HPartentID + "','" + HNumber + "','" + saveDataList[i].HName + "'," + HLevel + ",'" + Hurl + "','" + HType + "','" + HMakeName + "','" + HPicNum + "','z')";
oCN.RunProc(sql);
}
-
+
}
}
//鎻愪氦鏁版嵁搴撴搷浣�
oCN.Commit();
-
+
objJsonResult.code = "1";
objJsonResult.count = 1;
objJsonResult.Message = "淇濆瓨鎴愬姛锛�";
@@ -13591,15 +13953,15 @@
/// <returns></returns>
[Route("Web/GetOtherInBillMain_TempList_New")]
[HttpGet]
- public object GetOtherInBillMain_TempList_New (string HBillType, string sHMaker, Int64 HOrgID)
+ public object GetOtherInBillMain_TempList_New(string HBillType, string sHMaker, Int64 HOrgID)
{
WebS.WebService1 oWebs = new WebS.WebService1();
try
{
List<object> columnNameList = new List<object>();
-
+
DataSet ds = oCN.RunProcReturn("exec h_p_KF_GetPonderationBillMain_TempList_New1 '" + HBillType + "','" + sHMaker + "'," + HOrgID.ToString(), "h_p_KF_GetPonderationBillMain_TempList_New1");
-
+
//娣诲姞鍒楀悕
foreach (DataColumn col in ds.Tables[0].Columns)
{
@@ -13645,12 +14007,12 @@
/// <returns></returns>
[Route("Web/GetProcNoList")]
[HttpGet]
- public object GetProcNoList(int HInterID,string sWhere,string UserID)
+ public object GetProcNoList(int HInterID, string sWhere, string UserID)
{
List<object> columnNameList = new List<object>();
try
{
- ds = oCN.RunProcReturn("exec h_p_Sc_ProcNoList '" + HInterID + "','" + sWhere + "','" + UserID + "'" , "h_p_Sc_ProcNoList");
+ ds = oCN.RunProcReturn("exec h_p_Sc_ProcNoList '" + HInterID + "','" + sWhere + "','" + UserID + "'", "h_p_Sc_ProcNoList");
objJsonResult.code = "1";
objJsonResult.count = 1;
--
Gitblit v1.9.1