~yxj/MES-WEB-API.git

New file
			@@ -0,0 +1,296 @@
			using Newtonsoft.Json.Linq;
			using Pub_Class;
			using System;
			using System.Collections;
			using System.Collections.Generic;
			using System.Data;
			using System.Data.SqlClient;
			using System.Web.Http;
			using WebAPI.Models;

			namespace WebAPI.Controllers
			{
			//工序检验单Controller
			public class QC_OutCompCheckBillController : ApiController
			{
			public DBUtility.ClsPub.Enum_BillStatus BillStatus;

			private json objJsonResult = new json();
			public DataSet ds = new DataSet();
			public WebServer webserver = new WebServer();
			SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();



			/// <summary>
			/// 返回出厂检验单列表
			///参数：string sql。
			///返回值：object。
			/// </summary>
			[Route("QC_OutCompCheckBill/GetOutCompCheckBillList")]
			[HttpGet]
			public object GetOutCompCheckBillList(string sWhere)
			{
			try
			{
			if (sWhere == null \|\| sWhere.Equals(""))
			{
			ds = oCN.RunProcReturn("select * from h_v_QC_OutCompCheckBillList order by hmainid desc ", "h_v_QC_OutCompCheckBillList");
			}
			else
			{
			string sql1 = "select * from h_v_QC_OutCompCheckBillList where 1 = 1 ";
			string sql = sql1 + sWhere+ " order by hmainid desc ";
			ds = oCN.RunProcReturn(sql, "h_v_QC_OutCompCheckBillList");
			}
			if (ds == null \|\| ds.Tables[0].Rows.Count == 0)
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "false！";
			objJsonResult.data = null;
			return objJsonResult;
			}
			else
			{
			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;
			}
			}
			#region[编辑时获取表头数据]
			[Route("QC_OutCompCheckBill/QC_OutCompCheckBillListCheckDetail")]
			[HttpGet]
			public ApiResult<DataSet> QC_OutCompCheckBillListCheckDetail(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_QC_OutCompCheckBillList where hmainid= " + HID + " ", "h_v_QC_OutCompCheckBillList");
			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("QC_OutCompCheckBill/QC_OutCompCheckBillListProjectDetai")]
			[HttpGet]
			public object QC_OutCompCheckBillListProjectDetai(string sqlWhere)
			{
			DataSet ds;
			try
			{
			SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
			string sql1 = "SELECT 日期,单据号,表头备注,客户名称" +
			",客户代码,产品内码, 产品名称, 产品型号, 检验员代码" +
			", 检验员名称, 制单人, 制单日期, 审核人, 审核日期" +
			", 修改人, 修改日期, 关闭人, 关闭日期,单据类型 FROM h_v_QC_OutCompCheckBillList where 1 = 1 ";
			string sql = sql1 + sqlWhere;
			ds = oCN.RunProcReturn(sql, "h_v_QC_OutCompCheckBillList");
			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

			/// <summary>
			/// 新增单据-保存按钮
			///参数：string sql。
			///返回值：object。
			/// </summary>
			[Route("QC_OutCompCheckBill/AddBill")]
			[HttpPost]
			public object AddBill([FromBody] JObject sMainSub)
			{
			var _value = sMainSub["sMainSub"].ToString();
			string msg1 = _value.ToString();
			oCN.BeginTran();
			//保存主表
			objJsonResult = AddBillMain(msg1);
			if (objJsonResult.code == "0")
			{
			oCN.RollBack();
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = objJsonResult.Message;
			objJsonResult.data = null;
			return objJsonResult;
			}
			oCN.Commit();
			objJsonResult.code = "1";
			objJsonResult.count = 1;
			objJsonResult.Message = "新增单据成功！";
			return objJsonResult;
			}

			public json AddBillMain(string msg1)
			{
			string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries);
			string msg2 = sArray[0].ToString();
			string msg3 = sArray[1].ToString();
			try
			{
			msg2 = "[" + msg2.ToString() + "]";
			List<QC_OutCompCheckBillMain> mainList = Newtonsoft.Json.JsonConvert.DeserializeObject<List<QC_OutCompCheckBillMain>>(msg2);
			int HYear = 2021;
			double HPeriod = 1;
			string HBillType = "7504";
			string HBillSubType = "7504";
			long HInterID = mainList[0].HInterID;//递入type得到的单据ID
			DateTime HDate = mainList[0].HDate;//日期
			string HBillNo = mainList[0].HBillNo;//递入type得到的单据号
			long HBillStatus = mainList[0].HBillStatus;
			string HRemark = mainList[0].HRemark;//备注
			string HBacker = mainList[0].HBacker;
			DateTime HBackDate = mainList[0].HBackDate;
			string HBackRemark = mainList[0].HBackRemark;
			string HChecker = mainList[0].HChecker;
			DateTime HCheckDate = mainList[0].HCheckDate;
			string HMaker = mainList[0].HMaker;
			DateTime HMakeDate = mainList[0].HMakeDate;
			long HCusID = mainList[0].HCusID;
			long HMaterID = mainList[0].HMaterID;
			long HFirstCheckEmp = mainList[0].HFirstCheckEmp;
			string HCheckerResult = mainList[0].HCheckerResult;
			double HInStockQty = mainList[0].HInStockQty;
			double HCheckQty = mainList[0].HCheckQty;
			double HRightQty = mainList[0].HRightQTy;
			double HBadQty = mainList[0].HBadQty;

			//主表
			oCN.RunProc("Insert Into QC_OutCompCheckBillMain " +
			"(HBillType,HBillSubType,HInterID,HBillNo,HBillStatus,HDate,HMaker,HMakeDate" +
			",HYear,HPeriod,HRemark" +
			",HCusID,HMaterID,HInStockQty,HCheckQty,HRightQty" +
			",HBadQty,HFirstCheckEmp,HCheckerResult" +
			") " +
			" values('" + HBillType + "','" + HBillSubType + "'," + HInterID.ToString() + ",'" + HBillNo + "'," + HBillStatus.ToString() + ",'" + HDate + "','" + DBUtility.ClsPub.CurUserName + "',getdate()" +
			"," + HYear.ToString() + "," + HPeriod.ToString() + ",'" + HRemark + "'" +
			"," + HCusID.ToString() + "," + HMaterID.ToString() + "," + HInStockQty.ToString() + "," + HCheckQty.ToString() + "," + HRightQty.ToString() +
			"," + HBadQty.ToString() + "," + HFirstCheckEmp.ToString() + ",'" + HCheckerResult + "'" +
			") ");


			//保存子表
			objJsonResult = AddBillSub(msg3, HInterID);
			if (objJsonResult.code == "0")
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = objJsonResult.Message;
			objJsonResult.data = null;
			return objJsonResult;
			}

			objJsonResult.code = "1";
			objJsonResult.count = 1;
			objJsonResult.Message = null;
			objJsonResult.data = null;
			return objJsonResult;
			}
			catch (Exception e)
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "Exception！" + e.ToString();
			objJsonResult.data = null;
			return objJsonResult;
			}
			}

			public json AddBillSub(string msg3, long HInterID)
			{
			List<QC_OutCompCheckBillSub> subList = Newtonsoft.Json.JsonConvert.DeserializeObject<List<QC_OutCompCheckBillSub>>(msg3);
			for (int i = 0; i < subList.ToArray().Length; i++)
			{
			string HBillNo_bak = subList[0].HBillNo_bak;
			long HEntryID = subList[0].HEntryID;//工段ID
			string HCloseMan = subList[0].HCloseMan;
			long HCloseType = subList[0].HCloseType;
			string HRemark = subList[0].HRemark;
			long HSourceInterID = subList[0].HSourceInterID;
			long HSourceEntryID = subList[0].HSourceEntryID;
			string HSourceBillNo = subList[0].HSourceBillNo;
			string HSourceBillType = subList[0].HSourceBillType;
			double HRelationQty = subList[0].HRelationQty;
			double HRelationMoney = subList[0].HRelationMoney;
			long HQCCheckClassID = subList[0].HQCCheckClassID;
			long HQCCheckItemID = subList[0].HQCCheckItemID;
			string HQCStd = subList[0].HQCStd;
			string HResult = subList[0].HResult;

			oCN.RunProc("Insert into QC_OutCompCheckBillSub " +
			" (HInterID,HBillNo_bak,HEntryID,HCloseMan" +
			",HEntryCloseDate,HCloseType,HRemark,HSourceInterID" +
			",HSourceEntryID,HSourceBillNo,HSourceBillType,HRelationQty,HRelationMoney" +
			",HQCCheckClassID,HQCCheckItemID,HQCStd,HResult" +
			") values("
			+ HInterID.ToString() + ",'" + HBillNo_bak + "'," + HEntryID.ToString() + ",'" + HCloseMan + "'" +
			",getdate()," + HCloseType + ",'" + HRemark + "'," + HSourceInterID.ToString() +
			"," + HSourceEntryID.ToString() + ",'" + HSourceBillNo + "','" + HSourceBillType + "'," + HRelationQty.ToString() + "," + HRelationMoney.ToString() +
			"," + HQCCheckClassID.ToString() + "," + HQCCheckItemID.ToString() + ",'" + HQCStd + "','" + HResult + "'" + ") ");
			}

			objJsonResult.code = "1";
			objJsonResult.count = 1;
			objJsonResult.Message = null;
			objJsonResult.data = null;
			return objJsonResult;
			}
			/// <summary>
			///删除功能
			/// </summary>
			/// <returns></returns>
			[Route("QC_OutCompCheckBill/DeltetOutCompCheckBill")]
			[HttpGet]
			public object DeltetOutCompCheckBill(string HInterID)
			{
			try
			{
			oCN.BeginTran();
			oCN.RunProc("Delete From QC_OutCompCheckBillMain where HInterID = " + HInterID);
			oCN.RunProc("Delete From QC_OutCompCheckBillSub where HInterID = " + HInterID);
			oCN.Commit();
			objJsonResult.code = "1";
			objJsonResult.count = 1;
			objJsonResult.Message = "删除成功！";
			objJsonResult.data = null;
			return objJsonResult;
			}
			catch (Exception e)
			{
			oCN.RollBack();
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "Exception！" + e.ToString();
			objJsonResult.data = null;
			return objJsonResult;
			}
			}
			//
			}
			}