From 10be6891dceb6e622ee980e9687c7ffa2544e564 Mon Sep 17 00:00:00 2001
From: zzr99 <1940172413@qq.com>
Date: 星期四, 16 九月 2021 17:45:03 +0800
Subject: [PATCH] 完善器具采购单
---
WebAPI/Controllers/MJGL/Sc_MouldMoveStockStepOutBillController.cs | 342 +++++++++++++++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 342 insertions(+), 0 deletions(-)
diff --git a/WebAPI/Controllers/MJGL/Sc_MouldMoveStockStepOutBillController.cs b/WebAPI/Controllers/MJGL/Sc_MouldMoveStockStepOutBillController.cs
new file mode 100644
index 0000000..3a3859e
--- /dev/null
+++ b/WebAPI/Controllers/MJGL/Sc_MouldMoveStockStepOutBillController.cs
@@ -0,0 +1,342 @@
+锘縰sing Newtonsoft.Json.Linq;
+using System;
+using System.Collections.Generic;
+using System.Data;
+using System.Web.Http;
+using WebAPI.Models;
+namespace WebAPI.Controllers
+{
+ public class Sc_MouldMoveStockStepOutBillController : ApiController
+ {
+ private json objJsonResult = new json();
+ public DataSet ds = new DataSet();
+
+
+
+ #region 鍣ㄥ叿鍒嗗竷寮忚皟鍑哄崟鎹垪琛�
+
+ [Route("Sc_MouldMoveStockStepOutBill/GetMouldMoveStockStepOutBillList")]
+ [HttpGet]
+ public object GetMouldMoveStockStepOutBill(string sWhere)
+ {
+ try
+ {
+
+ ds = Sc_MouldMoveStockStepOutBill(sWhere);
+ 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_MouldMoveStockStepOutBill(string sWhere)
+ {
+ if (sWhere == null || sWhere.Equals(""))
+ {
+ return new SQLHelper.ClsCN().RunProcReturn("select * from h_v_Sc_MouldMoveStockStepOutBill ", "h_v_Sc_MouldMoveStockStepOutBill");
+ }
+ else
+ {
+ string sql1 = "select * from h_v_Sc_MouldMoveStockStepOutBill where 1 = 1 ";
+ string sql = sql1 + sWhere;
+ return new SQLHelper.ClsCN().RunProcReturn(sql, "h_v_Sc_MouldMoveStockStepOutBill");
+ }
+
+ }
+
+ #endregion
+
+
+ #region sql璇彞
+
+
+ public static DataSet Sc_MouldOtherOutBillList_s(string sWhere)
+ {
+ return new SQLHelper.ClsCN().RunProcReturn("select * from h_v_Sc_MouldOtherOutBillList ", "h_v_Sc_MouldOtherOutBillList");
+ }
+ #endregion
+
+// #region 妯℃不鍏峰叾浠栧嚭搴撳崟 淇濆瓨/缂栬緫
+// /// <summary>
+// /// 淇濆瓨妯″叿缁翠慨鍗�
+// /// </summary>
+// /// <param name="msg"></param>
+// /// <returns></returns>
+// [Route("Sc_MouldOtherOutBill/SaveMouldOtherOutBillList")]
+// [HttpPost]
+// public object SaveMouldOtherOutBillList([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.ClsSc_MouldOtherOutBill oBill = new DAL.ClsSc_MouldOtherOutBill();
+// List<Model.ClsSc_MouldStockBillMain> lsmain = new List<Model.ClsSc_MouldStockBillMain>();
+// msg2 = msg2.Replace("\\", "");
+// msg2 = msg2.Replace("\n", ""); //\n
+// lsmain = oListModels.getObjectByJson_Sc_MouldStockBillMain(msg2);
+// foreach (Model.ClsSc_MouldStockBillMain oItem in lsmain)
+// {
+// //oItem.HMaker = "";
+// UserName = oItem.HMaker; //鍒跺崟浜�
+// oItem.HBillType = "3828";
+// oItem.HBillSubType = "3828";
+
+// //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_MouldStockBillSub> ls = new List<Model.ClsSc_MouldStockBillSub>();
+// ls = oListModels.getObjectByJson_Sc_MouldStockBillSub(msg3);
+// int i = 0;
+// foreach (Model.ClsSc_MouldStockBillSub oItemSub in ls)
+// {
+
+// i++;
+// 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("Sc_MouldOtherOutBill/DeltetMouldOtherOutBillList")]
+// [HttpGet]
+// public object DeltetMouldOtherOutBillList(string HInterID)
+// {
+// //缂栬緫鏉冮檺
+// //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;
+// //}
+
+
+// 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.ClsSc_MouldOtherOutBill oBill = new DAL.ClsSc_MouldOtherOutBill();
+// 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("Sc_MouldOtherOutBill/Sc_MouldOtherOutBillListCheckDetai")]
+// [HttpGet]
+// public ApiResult<DataSet> Sc_MouldOtherOutBillListCheckDetai(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_Sc_MouldOtherOutBillList where hmainid= " + HID + " ", "h_v_Sc_MouldOtherOutBillList");
+// 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("Sc_MouldOtherOutBill/Sc_MouldOtherOutBillListProjectDetai")]
+// [HttpGet]
+// public object Sc_MouldOtherOutBillListProjectDetai(string sqlWhere)
+// {
+// DataSet ds;
+// try
+// {
+// SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
+// if (sqlWhere == null || sqlWhere.Equals(""))
+// {
+// ds = oCN.RunProcReturn(@"select 妯″叿浠ｇ爜 HMaterID,妯″叿鍚嶇О HMaterName,瑙勬牸鍨嬪彿 HMaterSpec ,鎵规 HBatchNo,璁捐瀵垮懡 HDesignLife,鍓╀綑瀵垮懡 HLeaveLife,绱Н浣跨敤瀵垮懡 HUseLife,瀹炲彂鏁伴噺 HQty,鍗曚环 HPrice,閲戦 HMoney,妯″叿浠撳簱浠ｇ爜 HWHID,鍙戣揣浠撳簱 HWHName,琛ㄤ綋澶囨敞 HRemark
+//from h_v_Sc_MouldOtherOutBillList", "h_v_Sc_MouldOtherOutBillList_Edit");
+// objJsonResult.code = "0";
+// objJsonResult.count = 1;
+// objJsonResult.Message = "鑾峰彇淇℃伅鎴愬姛锛�";
+// objJsonResult.data = ds.Tables[0];
+// }
+// else
+// {
+// string sql1 = @"select 妯″叿浠ｇ爜 HMaterID,妯″叿鍚嶇О HMaterName,瑙勬牸鍨嬪彿 HMaterSpec ,鎵规 HBatchNo,璁捐瀵垮懡 HDesignLife,鍓╀綑瀵垮懡 HLeaveLife,绱Н浣跨敤瀵垮懡 HUseLife,瀹炲彂鏁伴噺 HQty,鍗曚环 HPrice,閲戦 HMoney,妯″叿浠撳簱浠ｇ爜 HWHID,鍙戣揣浠撳簱 HWHName,琛ㄤ綋澶囨敞 HRemark
+//from h_v_Sc_MouldOtherOutBillList where 1 = 1 ";
+// string sql = sql1 + sqlWhere;
+// ds = oCN.RunProcReturn(sql, "h_v_Sc_MouldOtherOutBillList");
+// 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
+
+
+
+
+
+
+
+ }
+}
\ No newline at end of file
--
Gitblit v1.9.1