MES-WEB-API.git

			@@ -18,138 +18,63 @@
			//获取系统参数
			Pub_Class.ClsXt_SystemParameter oSystemParameter = new Pub_Class.ClsXt_SystemParameter();
			public DBUtility.ClsPub.Enum_BillStatus BillStatus;
			public DAL.ClsXs_SeOrderBill BillOld = new DAL.ClsXs_SeOrderBill();
			public DAL.ClsXs_SeOrderBill BillNew0 = new DAL.ClsXs_SeOrderBill();

			public DAL.ClsXs_ContractBill BillOld = new DAL.ClsXs_ContractBill();
			private json objJsonResult = new json();
			SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
			DataSet ds;

			/// <summary>
			/// 根据基础资料ID 查找记录
			///参数：string sql。
			///返回值：object。
			/// </summary>
			[Route("Xs_SeOrderBill/cx")]

			#region 获取合同列表
			[Route("Xs_ContractBill/list")]
			[HttpGet]
			public object cx(long HInterID)
			public object list(string sWhere, string user)
			{
			try
			{
			List<object> columnNameList = new List<object>();
			//判断是否有查询权限

			ds = oCN.RunProcReturn("select * from h_v_IF_SeOrderBillList where hmainid =" + HInterID, "h_v_IF_SeOrderBillList");
			if (ds == null \|\| ds.Tables[0].Rows.Count == 0)
			if (!DBUtility.ClsPub.Security_Log("Xs_ContractBill", 1, false, user))
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "false！";
			objJsonResult.Message = "无权限查看!";
			objJsonResult.data = null;
			return objJsonResult;
			}
			string sql = "select * from h_v_Xs_ContractBillAllList where 1 = 1 ";

			if (sWhere == "" \|\| sWhere == null)
			{
			ds = oCN.RunProcReturn(sql + " order by hmainid desc", "h_v_Xs_ContractBillAllList");
			}
			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;
			}
			}
			/// <summary>
			/// 返回销售订单列表
			///参数：string sql。
			///返回值：object。
			/// </summary>
			[Route("Xs_SeOrderBill/list")]
			[HttpGet]
			public object list(string sWhere,string user)
			{
			try
			{
			//判断查询权限
			if (!DBUtility.ClsPub.Security_Log("Xs_SeOrderBillQuery", 1, false, user))
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "无权限查询!";
			objJsonResult.data = null;
			return objJsonResult;
			ds = oCN.RunProcReturn(sql + sWhere + " order by hmainid desc", "h_v_Xs_ContractBillAllList");
			}

			if (sWhere == null \|\| sWhere.Equals(""))
			{
			ds = oCN.RunProcReturn("select * from h_v_IF_SeOrderBillList order by hmainid desc", "h_v_IF_SeOrderBillList");
			}
			else
			{
			string sql1 = "select * from h_v_IF_SeOrderBillList where 1 = 1 ";
			string sql = sql1 + sWhere+ " order by hmainid desc";
			ds = oCN.RunProcReturn(sql, "h_v_IF_SeOrderBillList");
			}
			//判断是否有采购经理权限（安瑞）
			//bool isCgjl = Security_Log("Cg_POOrderBill_PurchasManager", 1, true, user);
			//if (!isCgjl)
			//{
			// sWhere += $" and HEmpID in (select HEmpID from Gy_Czygl where Czymc='{user}' and HEmpID >0 )";
			//}
			//string sql = "select * from h_v_IF_POOrderBillList where 1 = 1 " + sWhere;
			//ds = oCN.RunProcReturn(sql, "h_v_Xs_ContractBillList");

			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;
			}
			}

			/// <summary>
			/// 返回销售订单动态列表
			/// </summary>
			/// <param name="sWhere"></param>
			/// <param name="user"></param>
			/// <returns></returns>
			[Route("Xs_SeOrderBill/DyColList")]
			[HttpGet]
			public object DyColList(string sWhere, string user)
			{
			try
			{
			//判断查询权限
			if (!DBUtility.ClsPub.Security_Log("Xs_SeOrderBillQuery", 1, false, user))
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "无权限查询!";
			objJsonResult.data = null;
			return objJsonResult;
			}

			ds = oCN.RunProcReturn("select * from h_v_IF_SeOrderBillList where 1 = 1 " + sWhere + " order by hmainid desc ", "h_v_IF_SeOrderBillList");
			List<object> listCol = new List<object>();
			foreach (DataColumn col in ds.Tables[0].Columns)
			{
			Type dataType = col.DataType;
			string str = "{\"ColmCols\":\"" + col.ColumnName + "\",\"ColmType\":\"" + dataType.Name + "\"}";
			listCol.Add(JsonConvert.DeserializeObject(str));
			string ColmString = "{\"ColmCols\":\"" + col.ColumnName + "\",\"ColmType\":\"" + dataType.Name + "\"}";
			columnNameList.Add(JsonConvert.DeserializeObject(ColmString));//获取到DataColumn列对象的列名
			}

			objJsonResult.code = "1";
			objJsonResult.count = 1;
			objJsonResult.Message = "Sucess！";
			objJsonResult.data = ds.Tables[0];
			objJsonResult.list = listCol;
			objJsonResult.list = columnNameList;
			return objJsonResult;

			}
			catch (Exception e)
			{
			@@ -161,10 +86,12 @@
			}
			}

			#region 销售订单保存/编辑功能
			[Route("Xs_SeOrder/SeOrderBillEdit")]
			#endregion

			#region 采购合同保存/编辑功能
			[Route("Xs_ContractBill/ContractBillEdit")]
			[HttpPost]
			public object SeOrderBillEdit([FromBody] JObject sMainSub)
			public object ContractBillEdit([FromBody] JObject sMainSub)
			{
			try
			{
			@@ -200,94 +127,142 @@
			return objJsonResult;
			}
			}

			/// <summary>
			/// 新增与更新合同
			/// </summary>
			public json AddBillMain(string msg1)
			{
			string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries);
			string msg2 = sArray[0].ToString(); //主表数据
			string msg3 = sArray[1].ToString(); //子表数据
			int OperationType = int.Parse(sArray[2].ToString()); // 数据类型 1添加 3修改
			string user = sArray[3].ToString();
			string msg4 = sArray[2].ToString(); //子表2数据
			int OperationType = int.Parse(sArray[3].ToString()); // 数据类型 1添加 3修改
			string user = sArray[4].ToString();
			string msg_allVal = sArray[4].ToString(); //主表+子表所有数据

			try
			{
			msg2 = "[" + msg2.ToString() + "]";
			List<ClsXs_SeOrderBillMain> mainList = Newtonsoft.Json.JsonConvert.DeserializeObject<List<ClsXs_SeOrderBillMain>>(msg2);
			List<ClsXs_ContractBillMain> mainList = Newtonsoft.Json.JsonConvert.DeserializeObject<List<ClsXs_ContractBillMain>>(msg2);

			long HInterID = mainList[0].HInterID;//递入type得到的单据ID
			string HBillNo = mainList[0].HBillNo;//递入type得到的单据号
			long HPRDORGID = mainList[0].HPRDORGID;//组织
			DateTime HDate = mainList[0].HDate;//日期
			string HRemark = mainList[0].HRemark;//备注
			long HCusID = mainList[0].HCusID;//客户
			long HEmpID = mainList[0].HEmpID;//业务员
			long HDeptID = mainList[0].HDeptID;//部门
			long HCurID = mainList[0].HCurID;//币别
			Single HExRate = mainList[0].HExRate;//汇率
			long HManagerID = mainList[0].HManagerID;//主管
			long HSellSID = mainList[0].HSellSID;//销售方式
			Single HExRate = (float)mainList[0].HExRate;//汇率
			long HSSID = mainList[0].HSSID;//结算方式
			DateTime HSSDate = mainList[0].HSSDate;//结算日期
			string HMaker = user;//制单人
			string HAddress = mainList[0].HAddress;//地址
			string HContractName = mainList[0].HContractName;//合同名称
			DateTime HContractDate = mainList[0].HContractDate;//结算日期

			List<ClsXs_SeOrderBillMain> mainList2 = Newtonsoft.Json.JsonConvert.DeserializeObject<List<ClsXs_SeOrderBillMain>>(msg2);
			string HMaker = user;//制单人
			string HAddress = mainList[0].HAddress;//交货地址
			string HExplanation = mainList[0].HExplanation;//摘要
			string HInnerBillNo = mainList[0].HInnerBillNo;//内部单据号

			List<ClsXs_ContractBillMain> mainList2 = Newtonsoft.Json.JsonConvert.DeserializeObject<List<ClsXs_ContractBillMain>>(msg2);
			DateTime dt = DateTime.Now;
			long HYear = mainList2[0].HYear == null ? 0 : mainList2[0].HYear;
			long HPeriod = mainList2[0].HPeriod == null ? 0 : mainList2[0].HPeriod;
			string HBillType = mainList2[0].HBillType == null ? "''" : mainList2[0].HBillType;
			string HBillSubType = mainList2[0].HBillSubType == null ? "''" : mainList2[0].HBillSubType;
			int HBillStatus = mainList2[0].HBillStatus == null ? 0 : mainList2[0].HBillStatus;
			long HBillStatus = mainList2[0].HBillStatus == null ? 0 : mainList2[0].HBillStatus;
			string HChecker = mainList2[0].HChecker == null ? "''" : mainList2[0].HChecker;
			string HUpDater = mainList2[0].HUpDater == null ? "''" : mainList2[0].HUpDater;
			string HCloseMan = mainList2[0].HCloseMan == null ? "''" : mainList2[0].HCloseMan;
			string HDeleteMan = mainList2[0].HDeleteMan == null ? "''" : mainList2[0].HDeleteMan;
			string HCheckDate = mainList2[0].HCheckDate == null ? "''" : mainList2[0].HCheckDate;
			string HMakeDate = mainList2[0].HMakeDate == null ? "''" : mainList2[0].HMakeDate;
			string HCloseMan = mainList2[0].HCloseMan == null ? "''" : mainList2[0].HCloseMan;
			string HCloseDate = mainList2[0].HCloseDate == null ? "''" : mainList2[0].HCloseDate;
			long HERPInterID = mainList2[0].HERPInterID == null ? 0 : mainList2[0].HERPInterID;
			string HERPBillType = mainList2[0].HERPBillType == null ? "''" : mainList2[0].HERPBillType;
			long HSALEORGID = mainList2[0].HSALEORGID == null ? 0 : mainList2[0].HSALEORGID;
			string HUpDateDate = mainList2[0].HUpDateDate == null ? "''" : mainList2[0].HUpDateDate;
			string HDeleteDate = mainList2[0].HDeleteDate == null ? "''" : mainList2[0].HDeleteDate;

			ds = oCN.RunProcReturn("select * from h_v_IF_SeOrderBillList where hmainid=" + HInterID + " and 单据号='" + HBillNo + "'", "h_v_IF_SeOrderBillList");

			//进行会计期间结账的判断和控制
			string s = "";
			int sYear = 0;
			int sPeriod = 0;
			if (DBUtility.Xt_BaseBillFun.Fun_AllowYearPeriod(HDate, ref sYear, ref sPeriod, ref s) == false)
			{
			objJsonResult.Message = s;
			return objJsonResult;
			}

			ds = oCN.RunProcReturn("select * from h_v_Xs_ContractBillList where hmainid=" + HInterID + " and 单据号='" + HBillNo + "'", "h_v_Xs_ContractBillList");

			if ((OperationType == 1 \|\| OperationType == 2) && ds.Tables[0].Rows.Count == 0)//新增
			{

			//保存前控制=========================================
			ds = oCN.RunProcReturn("exec h_p_Xs_ContractBill_BeforeSaveCtrl " + HInterID, "h_p_Xs_ContractBill_BeforeSaveCtrl ");
			if (ds == null \|\| ds.Tables[0].Rows.Count == 0)
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "保存前判断失败！";
			objJsonResult.data = null;
			return objJsonResult;
			}
			if (DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HBack"]) != "0")
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "保存失败！" + DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HBackRemark"]);
			objJsonResult.data = null;
			return objJsonResult;
			}
			//=========================================================
			DataSet Ds;
			Int64 NewHInterID = 1;
			Ds = oCN.RunProcReturn("select MAX(HInterID)HInterID from Xs_SeOrderBillMain", "Xs_SeOrderBillMain");
			Ds = oCN.RunProcReturn("select MAX(HInterID)HInterID from Xs_ContractBillMain", "Xs_ContractBillMain");
			if (Ds.Tables[0].Rows.Count != 0 && ClsPub.isLong(Ds.Tables[0].Rows[0]["HInterID"].ToString()) != 0)
			{
			NewHInterID = ClsPub.isLong(Ds.Tables[0].Rows[0]["HInterID"].ToString());
			NewHInterID += 1;
			}
			//主表
			oCN.RunProc(@"Insert Into Xs_SeOrderBillMain
			(HBillType,HInterID,HBillNo,HDate
			,HYear,HPeriod,HRemark,HMaker,HMakeDate
			,HEmpID,HCusID
			,HBillSubType,HAddress,HSSDate,HSSID,HSellSID,HCurID,HExRate, HManagerID,HDeptID
			,HExplanation,HCheckFlow,HBillStatus,HInnerBillNo
			,HICMOFlag,HChangeMan,HSALEORGID,HERPInterID,HERPBillType
			,HCloseDate,HCloseMan)
			values(" + "1401," + HInterID + ",'" + HBillNo + "','" + HDate + "','" +
			DateTime.Now.Year + "','" + DateTime.Now.Month + "','" + HRemark + "','" + HMaker + "','" + HMakeDate +
			"'," + HEmpID + "," + HCusID + ",'" + HBillType + "','" + HAddress + "','" + HSSDate +
			"'," + HSSID + "," + HSellSID + "," + HCurID + "," + HExRate + "," + HManagerID + "," + HDeptID + ",'" + "''" + "'," + "0," + HBillStatus + ",'" + "''" + "'," +
			0 + ",'" + "''" + "'," + HSALEORGID + "," + HERPInterID + ",'" + HERPBillType + "','" + HCloseDate + "','" + HCloseMan + "')");
			oCN.RunProc(@"Insert Into Xs_ContractBillMain
			(HInterID,HYear,HPeriod,HBillType,HBillSubType,HDate,HBillNo,HBillStatus
			,HRemark,HPrintQty
			,HMaker,HMakeDate
			,HContractDate,HContractName,HAddress,HSSID,HCusID,HCurID,HExRate,HEmpID,HDeptID,HExplanation,HInnerBillNo
			)
			values(" + HInterID + "," + DateTime.Now.Year + "," + DateTime.Now.Month + ",'" + 1400 + "','" +
			1400 + "','" + HDate + "','" + HBillNo + "','" + HBillStatus + "','" +
			HRemark + "'," + 0 + ",'" +
			HMaker + "',getdate(),'" +
			HContractDate + "','" + HContractName + "','" + HAddress + "'," + HSSID + "," + HCusID + "," + HCurID + "," + HExRate + "," + HEmpID + "," + HDeptID + ",'" + HExplanation + "','" + HInnerBillNo + "'" +
			")");
			}
			else if (OperationType == 3 \|\| ds.Tables[0].Rows.Count != 0)
			{ //修改
			oCN.RunProc("update Xs_SeOrderBillMain set " +
			"HRemark='" + HRemark + "', HChecker='" + HMaker + "', HCheckDate=getdate()" +
			", HEmpID=" + HEmpID + ", HCusID=" + HCusID + ",HAddress='" + HAddress + "',HDeptID=" + HDeptID
			+ ",HCurID=" + HCurID + ",HExRate=" + HExRate + ",HManagerID=" + HManagerID + ",HSellSID=" + HSellSID
			+ ",HSSID=" + HSSID + ",HSSDate='" + HSSDate + "' where HInterID=" + HInterID);
			{
			//修改
			DataSet dss;
			dss = oCN.RunProcReturn("select * from h_v_Xs_ContractBillList where hmainid=" + HInterID + " and 单据号='" + HBillNo + "'", "h_v_Xs_ContractBillList");
			//判断是否可编辑
			if (dss.Tables[0].Rows[0]["审核人"].ToString() != "" && dss.Tables[0].Rows[0]["审核人"] != null)
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "此单据已经被审核，不允许修改！";
			objJsonResult.data = 1;
			return objJsonResult;
			}
			oCN.RunProc("update Xs_ContractBillMain set " +
			"HRemark='" + HRemark + "', HUpDater='" + HMaker + "', HUpDateDate=getdate()" +
			",HSSID=" + HSSID + ",HCusID=" + HCusID + ",HCurID=" + HCurID
			+ ",HExRate=" + HExRate + ",HEmpID=" + HEmpID + ",HDeptID=" + HDeptID
			+ ",HAddress='" + HAddress + "',HContractName='" + HContractName + "',HContractDate= '" + HContractDate
			+ "' where HInterID=" + HInterID);

			//删除子表
			oCN.RunProc("delete from Xs_SeOrderBillSub where HInterID='" + HInterID + "'");
			oCN.RunProc("delete from Xs_ContractBillSub where HInterID='" + HInterID + "'");
			oCN.RunProc("delete from Xs_ContractBillScheme where HInterID='" + HInterID + "'");
			}
			//保存子表
			objJsonResult = AddBillSub(msg3, HInterID, OperationType);
			objJsonResult = AddBillSubAndScheme(msg3, msg4, HInterID, HBillNo, OperationType);

			if (objJsonResult.code == "0")
			{
			@@ -313,33 +288,25 @@
			return objJsonResult;
			}
			}

			public json AddBillSub(string msg3, long HInterID, int OperationType)
			/// <summary>
			/// 保存页签
			/// </summary>
			/// <param name="msg3">物料明细</param>
			/// <param name="msg4">付款计划</param>
			/// <param name="HInterID">单据内码</param>
			/// <param name="OperationType"></param>
			/// <param name="HBillNo">单据号</param>
			/// <returns></returns>
			public json AddBillSubAndScheme(string msg3, string msg4, long HInterID, string HBillNo, int OperationType)
			{
			List<ClsXs_SeOrderBillSub> DetailColl = Newtonsoft.Json.JsonConvert.DeserializeObject<List<ClsXs_SeOrderBillSub>>(msg3);
			List<ClsXs_ContractBillSub> DetailColl = Newtonsoft.Json.JsonConvert.DeserializeObject<List<ClsXs_ContractBillSub>>(msg3);

			List<ClsXs_SeOrderBillSub> DetailColl2 = Newtonsoft.Json.JsonConvert.DeserializeObject<List<ClsXs_SeOrderBillSub>>(msg3);

			long HSourceInterID = DetailColl2[0].HSourceInterID == null ? 0 : DetailColl2[0].HSourceInterID;
			long HSourceEntryID = DetailColl2[0].HSourceEntryID == null ? 0 : DetailColl2[0].HSourceEntryID;
			string HSourceBillNo = DetailColl2[0].HSourceBillNo == null ? "''" : DetailColl2[0].HSourceBillNo;
			string HSourceBillType = DetailColl2[0].HSourceBillType == null ? "''" : DetailColl2[0].HSourceBillType;
			double HRelationQty = DetailColl2[0].HRelationQty == null ? 0 : DetailColl2[0].HRelationQty;
			long HPropertyID = DetailColl2[0].HPropertyID == null ? 0 : DetailColl2[0].HPropertyID;
			string HBatChNo = DetailColl2[0].HBatChNo == null ? "''" : DetailColl2[0].HBatChNo;
			long HAuxPropID = DetailColl2[0].HAuxPropID == null ? 0 : DetailColl2[0].HAuxPropID;
			string HMTONo = DetailColl2[0].HMTONo == null ? "''" : DetailColl2[0].HMTONo;
			long HERPInterID = DetailColl2[0].HERPInterID == null ? 0 : DetailColl2[0].HERPInterID;
			long HERPEntryID = DetailColl2[0].HERPEntryID == null ? 0 : DetailColl2[0].HERPEntryID;
			decimal HBackRelationQty = DetailColl2[0].HBackRelationQty == null ? 0 : DetailColl2[0].HBackRelationQty;
			long HWhID = DetailColl2[0].HWhID == null ? 0 : DetailColl2[0].HWhID;
			long HSPID = DetailColl2[0].HSPID == null ? 0 : DetailColl2[0].HSPID;

			List<ClsXs_ContractBillScheme> SchemeColl = Newtonsoft.Json.JsonConvert.DeserializeObject<List<ClsXs_ContractBillScheme>>(msg4);
			int i = 0;
			foreach (ClsXs_SeOrderBillSub oSub in DetailColl)
			foreach (ClsXs_ContractBillSub oSub in DetailColl)
			{
			i++;
			if (oSub.HQty <= 0 \|\| oSub.HQty == null)
			if (oSub.HQty <= 0 \|\| oSub.HQty == 0)
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			@@ -377,47 +344,144 @@

			DataSet Cs;
			Int64 NewHEntryID = 1;
			Cs = oCN.RunProcReturn("select MAX(HEntryID)HEntryID from Xs_SeOrderBillSub", "Xs_SeOrderBillSub");
			Cs = oCN.RunProcReturn("select MAX(HEntryID)HEntryID from Xs_ContractBillSub", "Xs_ContractBillSub");
			if (Cs.Tables[0].Rows.Count != 0 && ClsPub.isLong(Cs.Tables[0].Rows[0]["HEntryID"].ToString()) != 0)
			{
			NewHEntryID = ClsPub.isLong(Cs.Tables[0].Rows[0]["HEntryID"].ToString());
			NewHEntryID += 1;
			}

			oCN.RunProc($@"Insert into Xs_SeOrderBillSub
			(HInterID,HENTRYID,HQty,HMaterID,HUnitID,HRemark
			,HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType
			,HRelationQty,HRelationMoney,HPrice,HTaxPrice,HMoney,HDiscountRate
			,HRelTaxPrice,HTaxRate,HTaxMoney,HlineTotal,HlineTotalBB,HDate,HOutStockQty,HInvoiceQty
			,HPropertyID,HBatChNo,HAuxPropID,HMTONo,HERPInterID,HERPEntryID,HBackRelationQty,HWhID,HSPID)
			values({HInterID},{NewHEntryID},{(oSub.HQty == null ? 0 : oSub.HQty)}
			,{oSub.HMaterID},{oSub.HUnitID},'{oSub.HRemark}',{HSourceInterID},{HSourceEntryID},{HSourceBillNo},{HSourceBillType},{HRelationQty},0,{oSub.HPrice},{oSub.HTaxPrice},{oSub.HMoney},{oSub.HDiscountRate},{oSub.HRelTaxPrice},{oSub.HTaxRate},{oSub.HTaxMoney},{oSub.HlineTotal},{oSub.HlineTotalBB},getdate(),{oSub.HOutStockQty},{oSub.HInvoiceQty},{HPropertyID},{HBatChNo},{HAuxPropID},
			{HMTONo},{HERPInterID},{HERPEntryID},{HBackRelationQty},{HWhID},{HSPID})");
			oCN.RunProc($@"Insert into Xs_ContractBillSub
			(HInterID,HBillNo_bak,HEntryID,HRemark,HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HRelationQty,HRelationMoney,
			HMaterID,HUnitID,HQty,HPrice,HMoney,HTaxRate,HTaxMoney,HlineTotal
			)
			values({HInterID},'{HBillNo}',{NewHEntryID},'{oSub.HRemark}',{oSub.HSourceInterID},{oSub.HSourceEntryID},'{oSub.HSourceBillNo}','{oSub.HSourceBillType}',{oSub.HRelationQty},{oSub.HRelationMoney}
			,{oSub.HMaterID},{oSub.HUnitID},{oSub.HQty},{oSub.HPrice},{oSub.HMoney},{oSub.HTaxRate},{oSub.HTaxMoney},{oSub.HPrice})");
			}
			i = 0;
			//付款计划保存
			foreach (ClsXs_ContractBillScheme oSub in SchemeColl)
			{
			i++;
			DataSet Cs;
			Int64 NewHEntryID = 1;
			Cs = oCN.RunProcReturn("select MAX(HEntryID)HEntryID from Xs_ContractBillScheme", "Xs_ContractBillScheme");
			if (Cs.Tables[0].Rows.Count != 0 && ClsPub.isLong(Cs.Tables[0].Rows[0]["HEntryID"].ToString()) != 0)
			{
			NewHEntryID = ClsPub.isLong(Cs.Tables[0].Rows[0]["HEntryID"].ToString());
			NewHEntryID += 1;
			}

			oCN.RunProc($@"Insert into Xs_ContractBillScheme
			(HInterID,HBillNo_bak,HEntryID,HRemark,HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HRelationQty,HRelationMoney,
			HDate,HMoney,HCurID,HExRate)
			values({HInterID},'{HBillNo}',{NewHEntryID},'{oSub.HRemark}',{oSub.HSourceInterID},{oSub.HSourceEntryID},'{oSub.HSourceBillNo}','{oSub.HSourceBillType}',{oSub.HRelationQty},{oSub.HRelationMoney}
			,'{oSub.HDate}',{oSub.HMoney},{oSub.HCurID},{oSub.HExRate})");
			}
			//保存后控制=========================================
			ds = oCN.RunProcReturn("exec h_p_Xs_ContractBill_AfterSaveCtrl " + HInterID, "h_p_Cg_POOrderBill_AfterSaveCtrl");

			if (ds == null \|\| ds.Tables[0].Rows.Count == 0)
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "保存后判断失败！";
			objJsonResult.data = null;
			return objJsonResult;
			}
			if (DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HBack"]) != "0")
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "保存失败！" + DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HBackRemark"]);
			objJsonResult.data = null;
			return objJsonResult;
			}
			//=========================================================
			objJsonResult.code = "1";
			objJsonResult.count = 1;
			objJsonResult.Message = null;
			objJsonResult.data = null;
			return objJsonResult;
			}

			#endregion

			#region 删除
			/// <summary>
			///删除功能
			/// </summary>
			/// <returns></returns>
			[Route("Xs_SeOrderBill/DeltetSeOrderBill")]
			[Route("Xs_ContractBill/DeltetXs_ContractBill")]
			[HttpGet]
			public object DeltetSeOrderBill(string HInterID)
			public object DeltetXs_ContractBill(string HInterID, string user)
			{
			try
			{

			string HBillNo = "";
			//删除前控制=========================================
			string sql1 = "exec h_p_Xs_ContractBill_BeforeDelCtrl " + HInterID + ",'" + HBillNo + "','" + user + "'";
			ds = oCN.RunProcReturn(sql1, "h_p_Xs_ContractBill_BeforeDelCtrl");
			if (ds == null \|\| ds.Tables.Count == 0 \|\| ds.Tables[0].Rows.Count == 0)
			{
			objJsonResult.code = "0";
			objJsonResult.count = 1;
			objJsonResult.Message = "删除失败!原因:删除前判断失败，请与网络管理人员联系";
			objJsonResult.data = null;
			return objJsonResult;
			}

			if (ds.Tables[0].Rows[0]["HBack"].ToString() != "0")
			{
			objJsonResult.code = "0";
			objJsonResult.count = 1;
			objJsonResult.Message = "删除失败!原因:" + ds.Tables[0].Rows[0]["HRemark"].ToString(); ;
			objJsonResult.data = null;
			return objJsonResult;
			}
			//==================================================================================
			//进行会计期间结账的判断和控制
			string s = "";
			int sYear = 0;
			int sPeriod = 0;
			DateTime HDate = DateTime.Now;
			if (DBUtility.Xt_BaseBillFun.Fun_AllowYearPeriod(HDate, ref sYear, ref sPeriod, ref s) == false)
			{
			objJsonResult.Message = s;
			return objJsonResult;
			}
			string sReturn = "";
			oCN.BeginTran();
			oCN.RunProc("Delete From Xs_SeOrderBillMain where HInterID = " + HInterID);
			oCN.RunProc("Delete From Xs_SeOrderBillSub where HInterID = " + HInterID);
			oCN.RunProc("Delete From Xs_ContractBillMain where HInterID = " + HInterID);
			oCN.RunProc("Delete From Xs_ContractBillSub where HInterID = " + HInterID);
			oCN.RunProc("Delete From Xs_ContractBillScheme where HInterID = " + HInterID);
			oCN.Commit();

			//删除后控制==================================================================================
			string sql2 = "exec h_p_Xs_ContractBill_AfterDelCtrl " + HInterID + ",'" + HBillNo + "','" + user + "'";
			ds = oCN.RunProcReturn(sql2, "h_p_Xs_ContractBill_AfterDelCtrl");
			if (ds == null \|\| ds.Tables.Count == 0 \|\| ds.Tables[0].Rows.Count == 0)
			{
			sReturn = "删除后判断失败，请与网络管理人员联系";
			objJsonResult.code = "0";
			objJsonResult.count = 1;
			objJsonResult.Message = "删除失败!原因:" + sReturn;
			objJsonResult.data = null;
			oCN.RollBack();
			return objJsonResult;
			}
			if (ds.Tables[0].Rows[0]["HBack"].ToString() != "0")
			{
			sReturn = ds.Tables[0].Rows[0]["HRemark"].ToString();
			objJsonResult.code = "0";
			objJsonResult.count = 1;
			objJsonResult.Message = "删除失败!原因:" + sReturn;
			objJsonResult.data = null;
			oCN.RollBack();
			return objJsonResult;
			}
			//==============================================================================================

			objJsonResult.code = "1";
			objJsonResult.count = 1;
			objJsonResult.Message = "删除成功！";
			@@ -434,841 +498,22 @@
			return objJsonResult;
			}
			}

			#region [同步插件]
			[Route("Xs_SeOrderBill/Xs_SeOrderBillSaveApi")]
			[HttpPost]
			public object Xs_SeOrderBillSaveApi([FromBody] JObject sMainSub)
			{
			try
			{
			//LogService.Write("销售订单同步,保存方法执行完成异常：" + sMainSub.ToString());
			var model = sMainSub["model"].ToString();
			var entry = sMainSub["model"]["HENTRY"].ToString();

			model = "[" + model.ToString() + "]";
			LogService.Write("销售订单同步 sMainSub:" + sMainSub);
			List<ClsXs_SeOrderBillMain> mainList = Newtonsoft.Json.JsonConvert.DeserializeObject<List<ClsXs_SeOrderBillMain>>(model);
			List<ClsXs_SeOrderBillSub> subList = Newtonsoft.Json.JsonConvert.DeserializeObject<List<ClsXs_SeOrderBillSub>>(entry);
			string sql = string.Empty;
			oCN.BeginTran();
			sql = $"delete Xs_SeOrderBillMain where HinterID = {mainList[0].HInterID}";
			oCN.RunProc(sql);
			sql = $"delete Xs_SeOrderBillSub where HinterID = {mainList[0].HInterID}";
			oCN.RunProc(sql);
			//主表
			oCN.RunProc(@"Insert Into Xs_SeOrderBillMain
			(HInterID,HYear,HPeriod,HBillType,HBillSubType,HDate
			,HBillNo,HBillStatus
			,HAddress,HSSID,HSSDate,HCusID,HCurID,HExRate
			,HEmpID,HManagerID,HDeptID,HExplanation,HRemark,HInnerBillNo
			,HChecker,HCheckDate,HMaker,HMakeDate,HCloseMan,HCloseDate
			,HERPInterID,HERPBillType,HSALEORGID,HSALEGROUPID,HRECEIVEID,HSETTLEID
			,HCHARGEID,HHEADLOCID,HRECCONTACTID,HCORRESPONDORGID,HBUSINESSTYPE)
			values(" + mainList[0].HInterID + "," + DateTime.Now.Year + "," + DateTime.Now.Month + ",'" + 1401 + "','" +
			mainList[0].HBillSubType + "','" + mainList[0].HDate + "','" + mainList[0].HBillNo + "','" + mainList[0].HBillStatus + "','" + mainList[0].HAddress + "'," + mainList[0].HSSID +
			",'" + mainList[0].HSSDate + "'," + mainList[0].HCusID + "," + mainList[0].HCurID + "," + mainList[0].HExRate + "," + mainList[0].HEmpID + "," + mainList[0].HManagerID + "," + mainList[0].HDeptID + ",'" + mainList[0].HExplanation + "','" + mainList[0].HRemark + "','" +
			mainList[0].HInnerBillNo + "','" + mainList[0].HChecker + "','" + mainList[0].HCheckDate + "','" + mainList[0].HMaker + "','" + mainList[0].HMakeDate + "','"
			+ mainList[0].HCloseMan + "','" + mainList[0].HCloseDate + "'," + mainList[0].HERPInterID + ",'"
			+ mainList[0].HERPBillType + "'," + mainList[0].HSALEORGID + "," + mainList[0].HSALEGROUPID + "," + mainList[0].HRECEIVEID + "," + mainList[0].HSETTLEID + "," + mainList[0].HCHARGEID + "," + mainList[0].HHEADLOCID + "," + mainList[0].HRECCONTACTID + "," + mainList[0].HCORRESPONDORGID + ",'" + mainList[0].HBUSINESSTYPE + "'" + ")");
			//保存子表
			foreach (var oSub in subList)
			{
			sql = $@"
			Insert into Xs_SeOrderBillSub
			(HInterID,HEntryID,HMaterID,HUnitID,HQty,HPrice
			,HTaxPrice,HDiscountRate,HRelTaxPrice,HMoney,HTaxRate,HTaxMoney
			,HLineTotal,HlineTotalBB,HDate,HOutStockQty,HInvoiceQty,HRemark
			,HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType
			,HRelationQty,HPropertyID,HBatChNo,HAuxPropID,HMTONo
			,HERPInterID,HERPEntryID,HBackRelationQty,HWhID,HSPID
			,HSTOCKORGID,HOWNERID,HOWNERTYPEID,HMAPID,HSTOCKUNITID,HBASEUNITID
			,HBFLOWID,HSETTLEORGID,HTAXCOMBINATION,HPRICEUNITID,HISFREE,HPRICECOEFFICIENT
			,HSYSPRICE,HLIMITDOWNPRICE,HPARENTMATID,HROWTYPE,HROWID,HPARENTROWID
			,HDELIVERYCONTROL,HLOCALCURRID,HEXCHANGETYPEID,HSETTLECURRID,HSETTLEMODEID
			,HRECCONDITIONID,HISINCLUDEDTAX,HISPRICEEXCLUDETAX,HEXCHANGERATE,HTAXRATEID
			,HCOSTPERCENT,HVAT,HSELLERWITHHOLDING,HBUYERWITHHOLDING,HPRICELISTENTRY)
			values('{oSub.HInterID}','{oSub.HEntryID}','{oSub.HMaterID}','{oSub.HUnitID}','{oSub.HQty}','{oSub.HPrice}','{oSub.HTaxPrice}','{oSub.HDiscountRate}','{oSub.HRelTaxPrice}','{oSub.HMoney}','{oSub.HTaxRate}','{oSub.HTaxMoney}','{oSub.HLineTotal}','{oSub.HlineTotalBB}','{oSub.HDate}','{oSub.HOutStockQty}','{oSub.HInvoiceQty}','{oSub.HRemark}','{oSub.HSourceInterID}','{oSub.HSourceEntryID}','{oSub.HSourceBillNo}','{oSub.HSourceBillType}','{oSub.HRelationQty}','{oSub.HPropertyID}','{oSub.HBatChNo}','{oSub.HAuxPropID}','{oSub.HMTONo}','{oSub.HERPInterID}','{oSub.HERPEntryID}','{oSub.HBackRelationQty}','{oSub.HWhID}','{oSub.HSPID}','{oSub.HSTOCKORGID}','{oSub.HOWNERID}','{oSub.HOWNERTYPEID}','{oSub.HMAPID}','{oSub.HSTOCKUNITID}','{oSub.HBASEUNITID}','{oSub.HBFLOWID}','{oSub.HSETTLEORGID}','{oSub.HTAXCOMBINATION}','{oSub.HPRICEUNITID}','{oSub.HISFREE}','{oSub.HPRICECOEFFICIENT}','{oSub.HSYSPRICE}','{oSub.HLIMITDOWNPRICE}','{oSub.HPARENTMATID}','{oSub.HROWTYPE}','{oSub.HROWID}','{oSub.HPARENTROWID}','{oSub.HDELIVERYCONTROL}','{oSub.HLOCALCURRID}','{oSub.HEXCHANGETYPEID}','{oSub.HSETTLECURRID}','{oSub.HSETTLEMODEID}','{oSub.HRECCONDITIONID}','{oSub.HISINCLUDEDTAX}','{oSub.HISPRICEEXCLUDETAX}','{oSub.HEXCHANGERATE}','{oSub.HTAXRATEID}','{oSub.HCOSTPERCENT}','{oSub.HVAT}','{oSub.HSELLERWITHHOLDING}','{oSub.HBUYERWITHHOLDING}','{oSub.HPRICELISTENTRY}')";
			oCN.RunProc(sql);
			}
			oCN.Commit();
			objJsonResult.code = "1";
			objJsonResult.count = 1;
			objJsonResult.Message = "单据保存成功！";
			objJsonResult.data = null;
			return objJsonResult;

			}
			catch (Exception e)
			{
			LogService.Write("销售订单同步异常,保存方法执行完成异常：" + e.Message.ToString());

			oCN.RollBack();
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "保存失败！" + e.ToString();
			objJsonResult.data = null;
			return objJsonResult;
			}
			}
			#endregion

			#region [同步单据]
			[Route("Xs_SeOrderBill/Xs_SeOrderBillViewApi")]
			#region 根据基础资料ID 查找记录(加载表用)
			/// <summary>
			/// 根据基础资料ID 查找记录
			///参数：string sql。
			///返回值：object。
			/// </summary>
			[Route("Xs_ContractBill/cx")]
			[HttpGet]
			public json Xs_SeOrderBillViewApi(string BillNo, string BillType)
			{
			string sql = string.Empty;
			string sReturn = "";
			if (oSystemParameter.ShowBill(ref sReturn) == true)
			{
			//系统参数是否为私有云模式,N为公有云模式，Y为私有云模式
			if (oSystemParameter.omodel.WMS_CloudMode == "Y")
			{
			#region [私有云模式，直接调用数据库存储过程更新]
			try
			{
			oCN.BeginTran();
			SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
			DataSet DS = oCn.RunProcReturn("exec h_p_WMS_ERPSourceBillToLocal '" + BillNo + "','" + BillType + "'", "h_p_WMS_ERPSourceBillToLocal");
			if (DS == null)
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "单据同步失败";
			objJsonResult.data = null;
			return objJsonResult;
			}
			else
			{
			if (DBUtility.ClsPub.isStrNull(DS.Tables[0].Rows[0]["HBack"]) == "2")
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "ERP中不存在该单据号";
			objJsonResult.data = null;
			return objJsonResult;
			}
			else
			{
			objJsonResult.code = "1";
			objJsonResult.count = 1;
			objJsonResult.Message = "单据同步成功";
			objJsonResult.data = null;
			return objJsonResult;
			}
			}

			}
			catch (Exception e)
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "Exception！" + e.ToString();
			objJsonResult.data = null;
			return objJsonResult;
			}
			#endregion
			}
			else
			{
			#region [公有云模式，调用WEBAPI的方式进行更新]
			var json = new
			{
			CreateOrgId = 0,
			Number = BillNo,
			Id = ""
			};
			#region [金蝶部分]
			//登录金蝶
			var loginRet = InvokeHelper.Login();
			var isSuccess = JObject.Parse(loginRet)["LoginResultType"].Value<int>();
			//判断是否登录成功
			if (isSuccess < 0)
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = loginRet;
			objJsonResult.data = null;
			return objJsonResult;
			}
			//查看获取数据
			var _result = InvokeHelper.View("SAL_SaleOrder", JsonConvert.SerializeObject(json));
			var _saveObj = JObject.Parse(_result);
			//判断数据是否获取成功
			if (_saveObj["Result"]["ResponseStatus"]["IsSuccess"].ToString().ToUpper() != "TRUE")
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "金蝶销售订单同步失败jsonRoot：" + _result;
			objJsonResult.data = null;
			return objJsonResult;
			}

			#endregion
			//获取主表数据
			DataSet Ds;
			Int64 InterID = 0;
			Ds = oCN.RunProcReturn("select * from Xs_SeOrderBillMain where HBillNo = '" + BillNo + "'", "Xs_SeOrderBillMain");
			if (Ds.Tables[0].Rows.Count != 0 && ClsPub.isLong(Ds.Tables[0].Rows[0]["HInterID"].ToString()) != 0)
			{
			InterID = ClsPub.isLong(Ds.Tables[0].Rows[0]["HInterID"].ToString());
			}

			#region [主表数据赋值]
			var jsonData = new
			{
			HInterID = _saveObj["Result"]["Result"]["Id"],
			HYear = DateTime.Now.Year,
			HPeriod = DateTime.Now.Month,
			HBillType = 1401,
			HBillSubType = 1401,
			HDate = _saveObj["Result"]["Result"]["Date"],
			HBillNo = _saveObj["Result"]["Result"]["BillNo"],
			HBillStatus = _saveObj["Result"]["Result"]["ApproverId_Id"].ToString() == Convert.ToString(0) ? 1 : 2,
			HAddress = _saveObj["Result"]["Result"]["ReceiveAddress"],
			HSSID = 0,
			HSSDate = _saveObj["Result"]["Result"]["Date"],
			HCusID = _saveObj["Result"]["Result"]["CustId_Id"],
			HCurID = 0,
			HExRate = 0,
			HEmpID = _saveObj["Result"]["Result"]["SalerId_Id"],
			HManagerID = 0,
			HDeptID = _saveObj["Result"]["Result"]["SaleDeptId_Id"],
			HExplanation = "",
			HRemark = "CLOUD导入",
			HInnerBillNo = _saveObj["Result"]["Result"]["Note"],
			HChecker = _saveObj["Result"]["Result"]["ApproverId"]["Name"],
			HCheckDate = _saveObj["Result"]["Result"]["ApproveDate"],
			HMaker = _saveObj["Result"]["Result"]["CreatorId"]["Name"],
			HMakeDate = _saveObj["Result"]["Result"]["CreateDate"],
			HCloseMan = _saveObj["Result"]["Result"]["CloserId_Id"],
			HCloseDate = _saveObj["Result"]["Result"]["CloseDate"],
			HERPInterID = _saveObj["Result"]["Result"]["Id"],
			HERPBillType = _saveObj["Result"]["Result"]["BillTypeId_Id"],
			HSALEORGID = _saveObj["Result"]["Result"]["SaleOrgId_Id"],
			HSALEGROUPID = _saveObj["Result"]["Result"]["SaleGroupId_Id"],
			HRECEIVEID = _saveObj["Result"]["Result"]["ReceiveId_Id"],
			HSETTLEID = _saveObj["Result"]["Result"]["SettleId_Id"],
			HCHARGEID = _saveObj["Result"]["Result"]["ChargeId_Id"],
			HHEADLOCID = _saveObj["Result"]["Result"]["HeadLocId_Id"],
			HRECCONTACTID = 0,
			HCORRESPONDORGID = _saveObj["Result"]["Result"]["CorrespondOrgId_Id"],
			HBUSINESSTYPE = _saveObj["Result"]["Result"]["BusinessType"],
			};
			#endregion
			// 删除主表对应数据
			sql = $"delete from Xs_SeOrderBillMain where HInterID = " + InterID;
			oCN.RunProc(sql);

			//插入主表
			sql = $@"
			insert into Xs_SeOrderBillMain
			(HInterID,HYear,HPeriod,HBillType,HBillSubType,HDate
			,HBillNo,HBillStatus
			,HAddress,HSSID,HSSDate,HCusID,HCurID,HExRate
			,HEmpID,HManagerID,HDeptID,HExplanation,HRemark,HInnerBillNo
			,HChecker,HCheckDate,HMaker,HMakeDate,HCloseMan,HCloseDate
			,HERPInterID,HERPBillType,HSALEORGID,HSALEGROUPID,HRECEIVEID,HSETTLEID
			,HCHARGEID,HHEADLOCID,HRECCONTACTID,HCORRESPONDORGID,HBUSINESSTYPE
			)
			values
			({jsonData.HInterID},{jsonData.HYear},{jsonData.HPeriod},{jsonData.HBillType},{jsonData.HBillSubType},
			'{jsonData.HDate}','{jsonData.HBillNo}',{jsonData.HBillStatus},'{jsonData.HAddress}',{jsonData.HSSID},'{jsonData.HSSDate}',{jsonData.HCusID},
			{jsonData.HCurID},{jsonData.HExRate},{jsonData.HEmpID},{jsonData.HManagerID},{jsonData.HDeptID},
			'{jsonData.HExplanation}','{jsonData.HRemark}','{jsonData.HInnerBillNo}','{jsonData.HChecker}','{jsonData.HCheckDate}',
			'{jsonData.HMaker}','{jsonData.HMakeDate}','{jsonData.HCloseMan}','{jsonData.HCloseDate}',{jsonData.HERPInterID},
			'{jsonData.HERPBillType}',{jsonData.HSALEORGID},{jsonData.HSALEGROUPID},{jsonData.HRECEIVEID},{jsonData.HSETTLEID},{jsonData.HCHARGEID},
			{jsonData.HHEADLOCID},{jsonData.HRECCONTACTID},{jsonData.HCORRESPONDORGID},'{jsonData.HBUSINESSTYPE}')";

			oCN.RunProc(sql);

			#region [申请子表变量]
			var dataArr = _saveObj["Result"]["Result"]["SaleOrderEntry"];

			DataSet Cs;
			double RelationQty = 0;
			#endregion
			int i = 0;

			// 获取子表数据
			Cs = oCN.RunProcReturn("select * from Xs_SeOrderBillSub where HInterID = " + InterID, "Xs_SeOrderBillSub");
			// 删除子表对应数据
			sql = $"delete from Xs_SeOrderBillSub where HInterID = " + InterID;
			oCN.RunProc(sql);

			foreach (var oSub in dataArr)
			{
			#region [子表数据赋值]

			if (Cs.Tables[0].Rows.Count != 0 && ClsPub.isLong(Cs.Tables[0].Rows[0]["HInterID"].ToString()) != 0)
			{
			RelationQty = ClsPub.isDoule(Cs.Tables[0].Rows[i]["HRelationQty"].ToString());

			i++;
			}

			var subData = new
			{
			HInterID = _saveObj["Result"]["Result"]["Id"],
			HEntryID = oSub["Id"],
			HMaterID = oSub["MaterialId_Id"],
			HUnitID = oSub["UnitId_Id"],
			HQty = oSub["Qty"],
			HPrice = oSub["Price"],
			HTaxPrice = oSub["TaxPrice"],
			HDiscountRate = oSub["DiscountRate"],
			HRelTaxPrice = 0,
			HMoney = 0,
			HTaxRate = oSub["TaxRate"],
			HTaxMoney = 0,
			HLineTotal = 0,
			HlineTotalBB = 0,
			HDate = oSub["MinPlanDeliveryDate"],
			HOutStockQty = oSub["StockBaseQty"],
			HInvoiceQty = 0,
			HRemark = oSub["Note"],
			HSourceInterID = 0,
			HSourceEntryID = 0,
			HSourceBillNo = oSub["SrcBillNo"],
			HSourceBillType = oSub["SrcType"],
			HRelationQty = Convert.ToInt32(oSub["Qty"]) - Convert.ToInt32(oSub["BaseCanOutQty"]),
			HPropertyID = 0,
			HBatChNo = oSub["Lot_Text"],
			HAuxPropID = oSub["AuxPropId_Id"],
			HMTONo = oSub["MtoNo"],
			HERPInterID = _saveObj["Result"]["Result"]["Id"],
			HERPEntryID = oSub["Id"],
			HBackRelationQty = Convert.ToInt32(oSub["Qty"]) - Convert.ToInt32(oSub["BaseCanReturnQty"]),
			HWhID = oSub["SOStockId_Id"],
			HSPID = oSub["SOStockLocalId_Id"],
			HSTOCKORGID = oSub["StockOrgId_Id"],
			HOWNERID = oSub["OwnerId_Id"],
			HOWNERTYPEID = oSub["OwnerTypeId"],
			HMAPID = oSub["MapId_Id"],
			HSTOCKUNITID = oSub["StockUnitID_Id"],
			HBASEUNITID = oSub["BaseUnitId_Id"],
			HBFLOWID = oSub["FBFLowId_Id"],
			HSETTLEORGID = oSub["SettleOrgId_Id"],
			HTAXCOMBINATION = oSub["TaxCombination_Id"],
			HPRICEUNITID = oSub["PriceUnitId_Id"],
			HISFREE = oSub["IsFree"],
			HPRICECOEFFICIENT = oSub["PriceCoefficient"],
			HSYSPRICE = oSub["SysPrice"],
			HLIMITDOWNPRICE = oSub["LimitDownPrice"],
			HPARENTMATID = oSub["ParentMatId_Id"],
			HROWTYPE = oSub["RowType"],
			HROWID = oSub["RowId"],
			HPARENTROWID = oSub["ParentRowId"],
			HDELIVERYCONTROL = oSub["DeliveryControl"],
			HLOCALCURRID = _saveObj["Result"]["Result"]["SaleOrderFinance"][0]["LocalCurrId_Id"],
			HEXCHANGETYPEID = oSub["ExchangeTypeId_Id"],
			HSETTLECURRID = _saveObj["Result"]["Result"]["SaleOrderFinance"][0]["SettleCurrId_Id"],
			HSETTLEMODEID = _saveObj["Result"]["Result"]["SaleOrderFinance"][0]["SettleModeId_Id"],
			HRECCONDITIONID = _saveObj["Result"]["Result"]["SaleOrderFinance"][0]["RecConditionId_Id"],
			HISINCLUDEDTAX = _saveObj["Result"]["Result"]["SaleOrderFinance"][0]["IsIncludedTax"],
			HISPRICEEXCLUDETAX = _saveObj["Result"]["Result"]["SaleOrderFinance"][0]["IsPriceExcludeTax"],
			HEXCHANGERATE = _saveObj["Result"]["Result"]["SaleOrderFinance"][0]["ExchangeRate"],
			HTAXRATEID = 0,
			HCOSTPERCENT =0,
			HVAT = 0,
			HSELLERWITHHOLDING = 0,
			HBUYERWITHHOLDING = 0,
			HPRICELISTENTRY = oSub["PriceListEntry_Id"]
			};
			#endregion

			//插入子表
			sql = $@"
			insert into Xs_SeOrderBillSub
			(HInterID,HEntryID,HMaterID,HUnitID,HQty,HPrice
			,HTaxPrice,HDiscountRate,HRelTaxPrice,HMoney,HTaxRate,HTaxMoney
			,HLineTotal,HlineTotalBB,HDate,HOutStockQty,HInvoiceQty,HRemark
			,HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType
			,HRelationQty,HPropertyID,HBatChNo,HAuxPropID,HMTONo
			,HERPInterID,HERPEntryID,HBackRelationQty,HWhID,HSPID
			,HSTOCKORGID,HOWNERID,HOWNERTYPEID,HMAPID,HSTOCKUNITID,HBASEUNITID
			,HBFLOWID,HSETTLEORGID,HTAXCOMBINATION,HPRICEUNITID,HISFREE,HPRICECOEFFICIENT
			,HSYSPRICE,HLIMITDOWNPRICE,HPARENTMATID,HROWTYPE,HROWID,HPARENTROWID
			,HDELIVERYCONTROL,HLOCALCURRID,HEXCHANGETYPEID,HSETTLECURRID,HSETTLEMODEID
			,HRECCONDITIONID,HISINCLUDEDTAX,HISPRICEEXCLUDETAX,HEXCHANGERATE,HTAXRATEID
			,HCOSTPERCENT,HVAT,HSELLERWITHHOLDING,HBUYERWITHHOLDING,HPRICELISTENTRY
			)
			values
			({subData.HInterID},{subData.HEntryID},{subData.HMaterID},{subData.HUnitID},{subData.HQty},{subData.HPrice},
			{subData.HTaxPrice},{subData.HDiscountRate},{subData.HRelTaxPrice},{subData.HMoney},{subData.HTaxRate},{subData.HTaxMoney},
			{subData.HLineTotal},{subData.HlineTotalBB},'{subData.HDate}',{subData.HOutStockQty},{subData.HInvoiceQty},'{subData.HRemark}',
			{subData.HSourceInterID},{subData.HSourceEntryID},'{subData.HSourceBillNo}','{subData.HSourceBillType}',{subData.HRelationQty},
			{subData.HPropertyID},'{subData.HBatChNo}',{subData.HAuxPropID},'{subData.HMTONo}',{subData.HERPInterID},{subData.HERPEntryID},
			{subData.HBackRelationQty},{subData.HWhID},{subData.HSPID},{subData.HSTOCKORGID},{subData.HOWNERID},
			'{subData.HOWNERTYPEID}','{subData.HMAPID}',{subData.HSTOCKUNITID},{subData.HBASEUNITID},'{subData.HBFLOWID}',
			{subData.HSETTLEORGID},{subData.HTAXCOMBINATION},{subData.HPRICEUNITID},'{subData.HISFREE}',
			{subData.HPRICECOEFFICIENT},{subData.HSYSPRICE},{subData.HLIMITDOWNPRICE},{subData.HPARENTMATID},'{subData.HROWTYPE}',
			'{subData.HROWID}','{subData.HPARENTROWID}','{subData.HDELIVERYCONTROL}',{subData.HLOCALCURRID},'{subData.HEXCHANGETYPEID}',
			{subData.HSETTLECURRID},{subData.HSETTLEMODEID},{subData.HRECCONDITIONID},'{subData.HISINCLUDEDTAX}','{subData.HISPRICEEXCLUDETAX}',
			{subData.HEXCHANGERATE},{subData.HTAXRATEID},{subData.HCOSTPERCENT},{subData.HVAT},{subData.HSELLERWITHHOLDING},
			{subData.HBUYERWITHHOLDING},{subData.HPRICELISTENTRY})";

			oCN.RunProc(sql);
			}


			objJsonResult.code = "1";
			objJsonResult.count = 1;
			objJsonResult.Message = "单据同步成功！";
			objJsonResult.data = null;
			return objJsonResult;

			#endregion
			}
			}
			else
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "单据读取失败！";
			objJsonResult.data = null;
			return objJsonResult;
			}
			}
			#endregion

			#region 销售订单审核/反审核功能
			[Route("Xs_SeOrderBill/CheckXs_SeOrderBill")]
			[HttpGet]
			public object CheckXs_SeOrderBill(string HInterID, int Type, string user)
			{
			try
			{
			//判断是否有删除权限
			if (!DBUtility.ClsPub.Security_Log("Xs_SeOrderBill_Check", 1, false, user))
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "无权限审核!";
			objJsonResult.data = null;
			return objJsonResult;
			}

			if (string.IsNullOrWhiteSpace(HInterID))
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "HInterID为空！";
			objJsonResult.data = null;
			return objJsonResult;
			}

			ClsPub.CurUserName = user;
			oCN.BeginTran();//开始事务

			//Type 1 审核 2 反审核
			if (Type == 1)
			{
			if (!BillOld.CheckBill(int.Parse(HInterID), ref ClsPub.sExeReturnInfo))
			{
			objJsonResult.code = "0";
			objJsonResult.count = 1;
			objJsonResult.Message = "审核失败!原因:" + ClsPub.sExeReturnInfo;
			objJsonResult.data = null;
			return objJsonResult;
			}
			}
			else
			{
			if (BillOld.AbandonCheck(int.Parse(HInterID), ref ClsPub.sExeReturnInfo))
			{
			SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
			//DataSet DSet = oCn.RunProcReturn("exec h_p_Sc_ICMOBill_AbandonCheckCtrl " + int.Parse(HInterID), "h_p_Sc_ICMOBill_AbandonCheckCtrl");
			//if (DBUtility.ClsPub.isInt(DSet.Tables[0].Rows[0]["Hback"]) != 0)
			//{
			// objJsonResult.code = "0";
			// objJsonResult.count = 1;
			// objJsonResult.Message = "该任务单已下推流转卡，不允许反审核" + DBUtility.ClsPub.isStrNull(DSet.Tables[0].Rows[0]["HBackRemark"]);
			// objJsonResult.data = null;
			// return objJsonResult;
			//}
			}
			else
			{
			objJsonResult.code = "0";
			objJsonResult.count = 1;
			objJsonResult.Message = "审核失败!原因:" + ClsPub.sExeReturnInfo;
			objJsonResult.data = null;
			return objJsonResult;
			}
			}

			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;
			}
			}
			#endregion

			#region 销售订单关闭/反关闭功能
			[Route("Xs_SeOrderBill/CloseXs_SeOrderBill")]
			[HttpGet]
			public object CloseXs_SeOrderBill(string HInterID, int Type, string user)
			{
			try
			{
			//判断是否有删除权限
			if (!DBUtility.ClsPub.Security_Log("Xs_SeOrderBill_Close", 1, false, user))
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "无权限关闭!";
			objJsonResult.data = null;
			return objJsonResult;
			}

			if (string.IsNullOrWhiteSpace(HInterID))
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "HInterID为空！";
			objJsonResult.data = null;
			return objJsonResult;
			}

			ClsPub.CurUserName = user;

			oCN.BeginTran();//开始事务

			//Type 1 关闭 2 反关闭
			if (Type == 1)
			{
			if (!BillOld.CloseBill(int.Parse(HInterID), ref ClsPub.sExeReturnInfo))
			{
			objJsonResult.code = "0";
			objJsonResult.count = 1;
			objJsonResult.Message = "关闭失败!原因:" + ClsPub.sExeReturnInfo;
			objJsonResult.data = null;
			return objJsonResult;
			}
			}
			else
			{
			if (!BillOld.CancelClose(int.Parse(HInterID), ref ClsPub.sExeReturnInfo))
			{
			objJsonResult.code = "0";
			objJsonResult.count = 1;
			objJsonResult.Message = "反关闭失败!原因:" + ClsPub.sExeReturnInfo;
			objJsonResult.data = null;
			return objJsonResult;
			}
			}

			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;
			}
			}
			#endregion

			#region 销售订单作废/反作废功能
			[Route("Xs_SeOrderBill/CancellXs_SeOrderBill")]
			[HttpGet]
			public object CancellXs_SeOrderBill(string HInterID, int Type, string user)
			{
			try
			{
			//判断是否有删除权限
			if (!DBUtility.ClsPub.Security_Log("Xs_SeOrderBill_Delete", 1, false, user))
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "无权限作废!";
			objJsonResult.data = null;
			return objJsonResult;
			}

			if (string.IsNullOrWhiteSpace(HInterID))
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "HInterID为空！";
			objJsonResult.data = null;
			return objJsonResult;
			}

			ClsPub.CurUserName = user;

			oCN.BeginTran();//开始事务

			//Type 1 作废 2 反作废
			if (Type == 1)
			{
			if (!BillOld.Cancelltion(int.Parse(HInterID), ref ClsPub.sExeReturnInfo))
			{
			objJsonResult.code = "0";
			objJsonResult.count = 1;
			objJsonResult.Message = "作废失败!原因:" + ClsPub.sExeReturnInfo;
			objJsonResult.data = null;
			return objJsonResult;
			}
			}
			else
			{
			if (!BillOld.AbandonCancelltion(int.Parse(HInterID), ref ClsPub.sExeReturnInfo))
			{
			objJsonResult.code = "0";
			objJsonResult.count = 1;
			objJsonResult.Message = "反作废失败!原因:" + ClsPub.sExeReturnInfo;
			objJsonResult.data = null;
			return objJsonResult;
			}
			}

			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;
			}
			}
			#endregion



			#region 销售订单保存新增/编辑
			[Route("Xs_SeOrderBill/SaveXs_SeOrderBill")]
			[HttpPost]
			public object SaveXs_SeOrderBill([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(); //子表1数据
			string refSav = sArray[2].ToString(); //操作方式
			string msg4 = sArray[3].ToString(); //用户

			DBUtility.ClsPub.CurUserName = msg4;

			string UserName = "";
			string s = "";
			ListModels oListModels = new ListModels();
			try
			{
			//编辑权限
			if (!DBUtility.ClsPub.Security_Log_second("Xs_SeOrderBill_Edit", 1, false, msg4))
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "无保存权限！";
			objJsonResult.data = null;
			return objJsonResult;
			}

			DAL.ClsXs_SeOrderBill oBill = new DAL.ClsXs_SeOrderBill();
			List<Model.ClsXs_SeOrderBillMain> lsmain = new List<Model.ClsXs_SeOrderBillMain>();
			msg2 = msg2.Replace("\\", "");
			msg2 = msg2.Replace("\n", ""); //\n
			lsmain = oListModels.getObjectByJson_Xs_SeOrderBillMain(msg2);
			foreach (Model.ClsXs_SeOrderBillMain oItem in lsmain)
			{
			if (refSav == "Add")
			{
			//单据号是否重复
			if (BillNew0.IsExistBillNo(ref ClsPub.sExeReturnInfo, oItem.HBillNo, BillStatus, BillOld.omodel.HInterID))
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "单据号重复！不允许保存！";
			objJsonResult.data = 1;
			return objJsonResult;
			}
			}
			if (refSav == "Update")
			{
			if (BillOld.ShowBill(oItem.HInterID, ref s) == false)
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "此单据有误！";
			objJsonResult.data = 1;
			return objJsonResult;
			}
			//判断是否可编辑
			if (BillOld.omodel.HChecker != "" && BillOld.omodel.HChecker != null)
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "此单据已经被审核，不允许修改！";
			objJsonResult.data = 1;
			return objJsonResult;
			}
			if (BillOld.omodel.HBillStatus > 1)
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "此单据处于不可编辑状态，不允许修改！";
			objJsonResult.data = 1;
			return objJsonResult;
			}
			if (!DBUtility.Xt_BaseBillFun.Fun_AllowEditBill(BillOld, ref s))
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = s + "，不允许修改";
			objJsonResult.data = 1;
			return objJsonResult;
			}

			string sql = "select count(*) Xs_ExceptiveCheckRequestBillCount from Xs_ExceptiveCheckRequestBillMain where HMainSourceInterID = " + BillOld.omodel.HInterID;
			ds = oCN.RunProcReturn(sql, "Xs_ExceptiveCheckRequestBillMain");
			if (ds != null && Int64.Parse(ds.Tables[0].Rows[0]["Xs_ExceptiveCheckRequestBillCount"].ToString()) > 0)
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "保存失败，单据存在下游单据[特批申请单]！";
			objJsonResult.data = 1;
			return objJsonResult;
			}
			}
			UserName = oItem.HMaker; //制单人
			oItem.HBillType = "1401";
			//oItem.HBillSubType = "1401";
			oItem.HSALEORGID = oItem.HOrgID;

			oItem.HYear = DBUtility.ClsPub.isLong(DateTime.Now.Year);
			oItem.HPeriod = DBUtility.ClsPub.isLong(DateTime.Now.Month);
			oItem.HMakeDate = DBUtility.ClsPub.isStrNull(DateTime.Now.ToString("yyyy-MM-dd"));

			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.ClsXs_SeOrderBillSub> ls = new List<Model.ClsXs_SeOrderBillSub>();
			ls = oListModels.getObjectByJson_Xs_SeOrderBillSub(msg3);
			int i = 0;
			foreach (Model.ClsXs_SeOrderBillSub 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; //关联金额

			if (oItemSub.HMaterID != 0)
			{
			oBill.DetailColl.Add(oItemSub);
			}
			}
			//保存
			//保存完毕后处理
			bool bResult;
			if (refSav == "Add")
			{
			// bResult = oBill.AddBill(ref DBUtility.ClsPub.sExeReturnInfo);
			bResult = oBill.AddBill(ref DBUtility.ClsPub.sExeReturnInfo);
			}
			else if (refSav == "Update")
			{
			bResult = oBill.ModifyBill(oBill.omodel.HInterID, ref DBUtility.ClsPub.sExeReturnInfo);
			}
			else
			{
			bResult = false;
			}
			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 销售订单加载编辑页面
			[Route("Xs_SeOrderBill/loadXs_SeOrderBill_Edit")]
			[HttpGet]
			public object loadXs_SeOrderBill_Edit(long HInterID)
			public object cx(long HInterID)
			{
			try
			{

			ds = oCN.RunProcReturn("select * from h_v_IF_SeOrderBillList where hmainid =" + HInterID, "h_v_IF_SeOrderBillList");
			ds = oCN.RunProcReturn("select * from h_v_Xs_ContractBillAllList where hmainid =" + HInterID, "h_v_Xs_ContractBillAllList");
			if (ds == null \|\| ds.Tables[0].Rows.Count == 0)
			{
			objJsonResult.code = "0";
			@@ -1297,137 +542,41 @@
			}
			#endregion

			#region 销售订单删除
			[Route("Xs_SeOrderBill/DropXs_SeOrderBill")]

			#region 根据物料内码获取物料信息
			[Route("Xs_ContractBill/getMaterialByMaterID")]
			[HttpGet]
			public object dropXs_SeOrderBill(string HInterID, string user)
			public ApiResult<DataTable> getMaterialByMaterID(Int64 HMaterID)
			{
			try
			{
			string s = "";
			SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();

			//查看权限
			if (!DBUtility.ClsPub.Security_Log("Xs_SeOrderBill_Drop", 1, false, user))
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "无删除权限！";
			objJsonResult.data = null;
			return objJsonResult;
			}
			string sql = "select a.HItemID HMaterID,a.HNumber HMaterNumber,a.HName HMaterName,a.HMaterRuleType,a.HModel HMaterModel,a.HUnitID, b.HNumber HUnitNumber, b.HName HUnitName" +
			" from Gy_Material AS a " +
			" LEFT OUTER JOIN Gy_Unit AS b on a.HUnitID = b.HItemID " +
			" where a.HItemID =" + HMaterID;

			if (HInterID == null \|\| HInterID.Equals(""))
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "HInterID不能为空！";
			objJsonResult.data = null;
			return objJsonResult;
			}

			if (BillOld.ShowBill(long.Parse(HInterID), ref s) == false)
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "此单据有误！";
			objJsonResult.data = 1;
			return objJsonResult;
			}
			//判断是否可编辑
			if (BillOld.omodel.HChecker != "" && BillOld.omodel.HChecker != null)
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "此单据已经被审核，不允许删除！";
			objJsonResult.data = 1;
			return objJsonResult;
			}

			//删除前控制=========================================
			string sql1 = "exec h_p_Xs_SeOrderBill_BeforeDelCtrl " + BillOld.omodel.HInterID + ",'" + BillOld.omodel.HBillNo + "','" + user + "'";
			ds = oCN.RunProcReturn(sql1, "h_p_Xs_SeOrderBill_BeforeDelCtrl");
			if (ds == null \|\| ds.Tables.Count == 0 \|\| ds.Tables[0].Rows.Count == 0)
			{
			objJsonResult.code = "0";
			objJsonResult.count = 1;
			objJsonResult.Message = "删除失败!原因:删除前判断失败，请与网络管理人员联系";
			objJsonResult.data = null;
			return objJsonResult;
			}

			if (ds.Tables[0].Rows[0]["HBack"].ToString() != "0")
			{
			objJsonResult.code = "0";
			objJsonResult.count = 1;
			objJsonResult.Message = "删除失败!原因:" + ds.Tables[0].Rows[0]["HRemark"].ToString(); ;
			objJsonResult.data = null;
			return objJsonResult;
			}
			//==================================================================================

			oCN.BeginTran();

			oCN.RunProc("delete from Xs_SeOrderBillMain where HInterID = " + HInterID);
			oCN.RunProc("delete from Xs_SeOrderBillSub where HInterID='" + HInterID + "'");

			//删除后控制==================================================================================
			string sql2 = "exec h_p_Xs_SeOrderBill_AfterDelCtrl " + BillOld.omodel.HInterID + ",'" + BillOld.omodel.HBillNo + "','" + user + "'";
			ds = oCN.RunProcReturn(sql2, "h_p_Xs_SeOrderBill_AfterDelCtrl");
			if (ds == null \|\| ds.Tables.Count == 0 \|\| ds.Tables[0].Rows.Count == 0)
			{
			s = "删除后判断失败，请与网络管理人员联系";
			objJsonResult.code = "0";
			objJsonResult.count = 1;
			objJsonResult.Message = "删除失败!原因:" + s;
			objJsonResult.data = null;
			oCN.RollBack();
			return objJsonResult;
			}
			if (ds.Tables[0].Rows[0]["HBack"].ToString() != "0")
			{
			s = ds.Tables[0].Rows[0]["HRemark"].ToString();
			objJsonResult.code = "0";
			objJsonResult.count = 1;
			objJsonResult.Message = "删除失败!原因:" + s;
			objJsonResult.data = null;
			oCN.RollBack();
			return objJsonResult;
			}
			//==============================================================================================
			var dataSet = oCN.RunProcReturn(sql, "Gy_Material");


			oCN.Commit();
			if (dataSet == null \|\| dataSet.Tables[0].Rows.Count == 0)
			return new ApiResult<DataTable> { code = -1, msg = "不存在该物料" };

			objJsonResult.code = "1";
			objJsonResult.count = 1;
			objJsonResult.Message = "您已删除单据号为" + BillOld.omodel.HBillNo + "的销售订单！";
			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;
			}
			return new ApiResult<DataTable> { code = 1, msg = "查询成功", data = dataSet.Tables[0] };
			}
			#endregion

			#region 销售订单审核/反审核
			#region 销售合同审核/反审核
			/// <summary>
			/// </summary>
			/// <param name="HInterID">单据ID</param>
			/// <param name="IsAudit">审核(0),反审核(1)</param>
			/// <param name="CurUserName">审核人</param>
			/// <returns></returns>
			[Route("Xs_SeOrderBill/AuditXs_SeOrderBill")]
			[Route("Xs_ContractBill/AuditXs_ContractBill")]
			[HttpGet]
			public object AuditXs_SeOrderBill(int HInterID, int IsAudit, string CurUserName)
			public object AuditXs_ContractBill(int HInterID, int IsAudit, string CurUserName)
			{
			string ModRightNameCheck = "Xs_SeOrderBill_Check";
			string ModRightNameCheck = "Xs_ContractBill_Check";
			DBUtility.ClsPub.CurUserName = CurUserName;
			try
			{
			@@ -1453,7 +602,7 @@

			Int64 lngBillKey = 0;
			lngBillKey = DBUtility.ClsPub.isLong(HInterID); //对HInterID进行类型的转换
			DAL.ClsXs_SeOrderBill oBill = new DAL.ClsXs_SeOrderBill(); //实例化单据操作类，用于进行相关操作
			DAL.ClsXs_ContractBill oBill = new DAL.ClsXs_ContractBill(); //实例化单据操作类，用于进行相关操作

			//针对需要进行的操作，检验当前单据的状态是否支持需要进行的操作
			if (oBill.ShowBill(lngBillKey, ref DBUtility.ClsPub.sExeReturnInfo)) //根据HInterID获取该单据的数据
			@@ -1495,18 +644,6 @@
			objJsonResult.data = null;
			return objJsonResult;
			}

			foreach(Model.ClsXs_SeOrderBillSub oSub in oBill.DetailColl)
			{
			if (oSub.HCloseMan != "")
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "单据中存在行关闭的记录!反审核失败！";
			objJsonResult.data = null;
			return objJsonResult;
			}
			}
			}
			}
			else
			@@ -1522,19 +659,10 @@
			//进行需要进行的审核/反审核操作
			if (IsAudit == 0) //审核提交
			{
			ds = oCN.RunProcReturn("exec h_p_Kf_CheckSeOrderBill_CrediControl " + oBill.omodel.HInterID, "h_p_Kf_CheckSeOrderBill_CrediControl");
			if(ds.Tables[0].Rows[0]["HBack"].ToString() == "1")
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "审核失败!原因:" + ds.Tables[0].Rows[0]["HRemark"].ToString();
			objJsonResult.data = null;
			return objJsonResult;
			}

			//审核前控制=========================================
			string sql1 = "exec h_p_Xs_SeOrderBill_BeforeCheckCtrl " + oBill.omodel.HInterID + ",'" + oBill.omodel.HBillNo + "','" + CurUserName + "'";
			ds = oCN.RunProcReturn(sql1, "h_p_Xs_SeOrderBill_BeforeCheckCtrl");
			string sql1 = "exec h_p_Xs_ContractBill_BeforeCheckCtrl " + oBill.omodel.HInterID + ",'" + oBill.omodel.HBillNo + "','" + CurUserName + "'";
			ds = oCN.RunProcReturn(sql1, "h_p_Xs_ContractBill_BeforeCheckCtrl");
			if (ds == null \|\| ds.Tables.Count == 0 \|\| ds.Tables[0].Rows.Count == 0)
			{
			objJsonResult.code = "0";
			@@ -1555,7 +683,7 @@
			//==================================================================================

			//审核提交
			if (oBill.CheckBill(oBill.omodel.HInterID, oBill.omodel.HBillNo, "h_p_Xs_SeOrderBill_AfterCheckCtrl", CurUserName, ref DBUtility.ClsPub.sExeReturnInfo) == true)
			if (oBill.CheckBill(oBill.omodel.HInterID, oBill.omodel.HBillNo, "h_p_Xs_ContractBill_AfterCheckCtrl", CurUserName, ref DBUtility.ClsPub.sExeReturnInfo) == true)
			{
			objJsonResult.code = "1";
			objJsonResult.count = 1;
			@@ -1575,7 +703,7 @@
			if (IsAudit == 1) //反审核提交
			{
			//反审核前控制=========================================
			DataSet ds = oCN.RunProcReturn("Exec h_p_Xs_SeOrderBill_BeforeAbandonCheckCtrl " + oBill.omodel.HInterID + ",'" + oBill.omodel.HBillNo + "','" + CurUserName + "'", "h_p_Xs_SeOrderBill_BeforeAbandonCheckCtrl");
			DataSet ds = oCN.RunProcReturn("Exec h_p_Xs_ContractBill_BeforeUnCheckCtrl " + oBill.omodel.HInterID + ",'" + oBill.omodel.HBillNo + "','" + CurUserName + "'", "h_p_Xs_ContractBill_BeforeUnCheckCtrl");
			if (ds == null)
			{
			objJsonResult.code = "0";
			@@ -1595,7 +723,7 @@
			//=========================================================

			//反审核提交AbandonCheck
			if (oBill.AbandonCheck(oBill.omodel.HInterID, oBill.omodel.HBillNo, "h_p_Xs_SeOrderBill_AfterUnCheckCtrl", CurUserName, ref DBUtility.ClsPub.sExeReturnInfo) == true)
			if (oBill.AbandonCheck(oBill.omodel.HInterID, oBill.omodel.HBillNo, "h_p_Xs_ContractBill_AfterUnCheckCtrl", CurUserName, ref DBUtility.ClsPub.sExeReturnInfo) == true)
			{
			objJsonResult.code = "1";
			objJsonResult.count = 1;
			@@ -1625,280 +753,84 @@
			}
			#endregion

			#region 销售订单关闭/反关闭
			/// <summary>
			/// </summary>
			/// <param name="HInterID">单据ID</param>
			/// <param name="IsAudit">关闭(0),反关闭(1)</param>
			/// <param name="CurUserName">关闭人</param>
			/// <returns></returns>
			[Route("Xs_SeOrderBill/CloseXs_SeOrderBill_1")]
			#region 销售合同关闭/反关闭功能
			[Route("Xs_ContractBill/CloseXs_ContractBill")]
			[HttpGet]
			public object CloseXs_SeOrderBill_1(int HInterID, int IsAudit, string CurUserName)
			public object CloseXs_ContractBill(string HInterID, int Type, string user)
			{
			string ModRightNameCheck = "Xs_SeOrderBill_Close";
			DBUtility.ClsPub.CurUserName = CurUserName;
			string sql = "";
			try
			{
			//检查权限
			if (!DBUtility.ClsPub.Security_Log_second(ModRightNameCheck, 1, false, CurUserName))
			//判断是否有删除权限
			if (!DBUtility.ClsPub.Security_Log("Xs_ContractBill_Close", 1, false, user))
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "关闭失败！无权限！";
			objJsonResult.data = null;
			return objJsonResult;
			}
			//HInterID数据判断
			if (HInterID <= 0)
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "HInterID小于0！";
			objJsonResult.Message = "无权限关闭!";
			objJsonResult.data = null;
			return objJsonResult;
			}


			Int64 lngBillKey = 0;
			lngBillKey = DBUtility.ClsPub.isLong(HInterID); //对HInterID进行类型的转换
			DAL.ClsXs_SeOrderBill oBill = new DAL.ClsXs_SeOrderBill(); //实例化单据操作类，用于进行相关操作

			//针对需要进行的操作，检验当前单据的状态是否支持需要进行的操作
			if (oBill.ShowBill(lngBillKey, ref DBUtility.ClsPub.sExeReturnInfo)) //根据HInterID获取该单据的数据
			{
			if (oBill.omodel.HDeleteMan.Trim() != "")
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "单据已作废!不能进行关闭！";
			objJsonResult.data = null;
			return objJsonResult;
			}
			if (oBill.omodel.HChecker.Trim() == "")
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "单据未审核!不能进行关闭！";
			objJsonResult.data = null;
			return objJsonResult;
			}
			if (IsAudit == 0) //关闭判断
			{
			if (oBill.omodel.HCloseMan.Trim() != "")
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "单据已关闭!不能再次关闭！";
			objJsonResult.data = null;
			return objJsonResult;
			}
			}
			if (IsAudit == 1) //反关闭判断
			{
			if (oBill.omodel.HCloseMan.Trim() == "")
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "单据未关闭!不需要反关闭！";
			objJsonResult.data = null;
			return objJsonResult;
			}

			//判断单据是否为自动关闭
			sql = "select * from Xs_SeOrderBillMain where HInterID = " + HInterID;
			ds = oCN.RunProcReturn(sql, "Xs_SeOrderBillMain");
			if (ds.Tables[0].Rows[0]["HCloseType"].ToString() == "False")
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "反关闭失败!单据为自动关闭，不能进行手动反关闭！";
			objJsonResult.data = null;
			return objJsonResult;
			}
			}
			}
			else
			if (string.IsNullOrWhiteSpace(HInterID))
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "单据不存在!原因:" + DBUtility.ClsPub.sExeReturnInfo;
			objJsonResult.Message = "HInterID为空！";
			objJsonResult.data = null;
			return objJsonResult;
			}

			ClsPub.CurUserName = user;
			BillOld.MvarItemKey = "Xs_ContractBillMain";
			oCN.BeginTran();//开始事务

			//进行需要进行的关闭/反关闭操作
			if (IsAudit == 0) //关闭提交
			//Type 1 关闭 2 反关闭
			if (Type == 1)
			{
			//关闭提交
			if (oBill.CloseBill(lngBillKey, ref DBUtility.ClsPub.sExeReturnInfo) == true)
			{
			objJsonResult.code = "1";
			objJsonResult.count = 1;
			objJsonResult.Message = "关闭成功";
			objJsonResult.data = null;
			return objJsonResult;
			}
			else
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "关闭失败!原因:" + DBUtility.ClsPub.sExeReturnInfo;
			objJsonResult.data = null;
			return objJsonResult;
			}
			}
			if (IsAudit == 1) //反关闭提交
			{
			ds = oCN.RunProcReturn("exec h_p_Kf_CheckSeOrderBill_CrediControl " + oBill.omodel.HInterID, "h_p_Kf_CheckSeOrderBill_CrediControl");
			if (ds.Tables[0].Rows[0]["HBack"].ToString() == "1")
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "审核失败!原因:" + ds.Tables[0].Rows[0]["HRemark"].ToString();
			objJsonResult.data = null;
			return objJsonResult;
			}
			//反关闭提交
			if (oBill.CancelClose(lngBillKey, ref DBUtility.ClsPub.sExeReturnInfo) == true)
			{
			objJsonResult.code = "1";
			objJsonResult.count = 1;
			objJsonResult.Message = "反关闭成功";
			objJsonResult.data = null;
			return objJsonResult;
			}
			else
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "反关闭失败!原因:" + DBUtility.ClsPub.sExeReturnInfo;
			objJsonResult.data = null;
			return objJsonResult;
			}
			}
			return objJsonResult;
			}
			catch (Exception e)
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "关闭失败或者反关闭失败！" + e.ToString();
			objJsonResult.data = null;
			return objJsonResult;
			}
			}
			#endregion

			#region 销售订单行关闭/行反关闭
			/// <summary>
			/// </summary>
			/// <param name="HInterID">单据ID</param>
			/// <param name="IsAudit">关闭(0),反关闭(1)</param>
			/// <param name="CurUserName">关闭人</param>
			/// <returns></returns>
			[Route("Xs_SeOrderBill/CloseRowXs_SeOrderBill")]
			[HttpGet]
			public object CloseRowXs_SeOrderBill(int HInterID,int HEntryID, int IsAudit, string CurUserName)
			{
			string ModRightNameCheck = "Xs_SeOrderBill_Close";
			string SubBillName = "Xs_SeOrderBillSub"; //子表表名
			DBUtility.ClsPub.CurUserName = CurUserName;
			DataSet ds = null;
			try
			{
			//检查权限
			if (!DBUtility.ClsPub.Security_Log_second(ModRightNameCheck, 1, false, CurUserName))
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "行关闭失败！无权限！";
			objJsonResult.data = null;
			return objJsonResult;
			}
			//HInterID数据判断
			if (HInterID <= 0)
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "HInterID小于0！";
			objJsonResult.data = null;
			return objJsonResult;
			}

			Int64 lngBillKey = 0;
			lngBillKey = DBUtility.ClsPub.isLong(HInterID); //对HInterID进行类型的转换
			DAL.ClsXs_SeOrderBill oBill = new DAL.ClsXs_SeOrderBill(); //实例化单据操作类，用于进行相关操作

			//针对需要进行的操作，检验当前单据的状态是否支持需要进行的操作
			if (oBill.ShowBill(lngBillKey, ref DBUtility.ClsPub.sExeReturnInfo)) //根据HInterID获取该单据的数据
			{
			if (oBill.omodel.HDeleteMan.Trim() != "")
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "单据已作废!不能进行行关闭！";
			objJsonResult.data = null;
			return objJsonResult;
			}
			if (oBill.omodel.HCloseMan.Trim() != "")
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "单据已关闭!不能进行行关闭！";
			objJsonResult.data = null;
			return objJsonResult;
			}
			if (oBill.omodel.HChecker.Trim() == "")
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "单据未审核!不能进行行关闭！";
			objJsonResult.data = null;
			return objJsonResult;
			}

			string sql = "select * from " + SubBillName + " where HInterID = " + HInterID + " and HEntryID = " + HEntryID;
			ds = oCN.RunProcReturn(sql, "Xs_SeOrderBillSub");
			//判断单据是否已经关闭
			DataSet ds;
			string sql = "select * from " + BillOld.MvarItemKey + " where HinterID = " + HInterID;
			ds = oCN.RunProcReturn(sql, BillOld.MvarItemKey);
			if (ds == null \|\| ds.Tables[0].Rows.Count == 0)
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "该行数据不存在!原因:" + DBUtility.ClsPub.sExeReturnInfo;
			objJsonResult.Message = "单据不存在！";
			objJsonResult.data = null;
			return objJsonResult;
			}
			if (IsAudit == 0) //行关闭判断
			if (ds.Tables[0] != null && ds.Tables[0].Rows.Count > 0)
			{
			if (ds.Tables[0].Rows[0]["HCloseMan"].ToString().Trim() != "")
			if (ds.Tables[0].Rows[0]["HDeleteMan"] != null && ds.Tables[0].Rows[0]["HDeleteMan"].ToString() != "")
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "行已关闭!不能再次行关闭！";
			objJsonResult.Message = "单据已作废!不能进行关闭!";
			objJsonResult.data = null;
			return objJsonResult;
			}
			}
			if (IsAudit == 1) //行反关闭判断
			{
			if (ds.Tables[0].Rows[0]["HCloseMan"].ToString().Trim() == "")
			if (ds.Tables[0].Rows[0]["HChecker"] == null \|\| ds.Tables[0].Rows[0]["HChecker"].ToString() == "")
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "行未关闭!不需要再行反关闭！";
			objJsonResult.Message = "单据未审核!不能进行关闭!";
			objJsonResult.data = null;
			return objJsonResult;
			}

			//判断行是否为自动关闭
			string temp = ds.Tables[0].Rows[0]["HCloseType"].ToString();
			if (ds.Tables[0].Rows[0]["HCloseType"].ToString() == "False")
			if (ds.Tables[0].Rows[0]["HCloseMan"] != null && ds.Tables[0].Rows[0]["HCloseMan"].ToString() != "")
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "行反关闭失败!行为自动关闭，不能进行手动反关闭！";
			objJsonResult.Message = "单据已关闭!不能再次关闭!";
			objJsonResult.data = null;
			return objJsonResult;
			}
			//关闭单据
			if (!BillOld.CloseBill(Int64.Parse(HInterID), ref ClsPub.sExeReturnInfo))
			{
			objJsonResult.code = "0";
			objJsonResult.count = 1;
			objJsonResult.Message = "关闭失败!原因:" + ClsPub.sExeReturnInfo;
			objJsonResult.data = null;
			return objJsonResult;
			}
			@@ -1906,149 +838,362 @@
			}
			else
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "单据不存在!原因:" + DBUtility.ClsPub.sExeReturnInfo;
			objJsonResult.data = null;
			return objJsonResult;
			}


			//进行需要进行的行关闭/行反关闭操作
			if (IsAudit == 0) //行关闭提交
			{
			//行关闭提交
			if (oBill.CloseRow(lngBillKey,HEntryID,oBill.omodel.HBillNo,CurUserName, ref DBUtility.ClsPub.sExeReturnInfo) == true)
			//判断单据是否已经反关闭
			DataSet ds;
			string sql = "select * from " + BillOld.MvarItemKey + " where HinterID = " + HInterID;
			ds = oCN.RunProcReturn(sql, BillOld.MvarItemKey);
			if (ds.Tables[0] != null && ds.Tables[0].Rows.Count > 0)
			{
			objJsonResult.code = "1";
			objJsonResult.count = 1;
			objJsonResult.Message = "行关闭成功";
			objJsonResult.data = null;
			return objJsonResult;
			}
			else
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "行关闭失败!原因:" + DBUtility.ClsPub.sExeReturnInfo;
			objJsonResult.data = null;
			return objJsonResult;
			}
			}
			if (IsAudit == 1) //行反关闭提交
			{
			oBill.oCn.BeginTran();
			//行反关闭提交
			if (oBill.CancelRow(lngBillKey, HEntryID, oBill.omodel.HBillNo, CurUserName, ref DBUtility.ClsPub.sExeReturnInfo) == true)
			{
			ds = oCN.RunProcReturn("exec h_p_Kf_CheckSeOrderBill_CrediControl " + oBill.omodel.HInterID, "h_p_Kf_CheckSeOrderBill_CrediControl");
			if (ds.Tables[0].Rows[0]["HBack"].ToString() == "1")
			if (ds.Tables[0].Rows[0]["HDeleteMan"] != null && ds.Tables[0].Rows[0]["HDeleteMan"].ToString() != "")
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "审核失败!原因:" + ds.Tables[0].Rows[0]["HRemark"].ToString();
			objJsonResult.Message = "单据已作废!不能进行关闭!";
			objJsonResult.data = null;
			oBill.oCn.RollBack();
			return objJsonResult;
			}
			objJsonResult.code = "1";
			objJsonResult.count = 1;
			objJsonResult.Message = "反关闭成功";
			objJsonResult.data = null;
			oBill.oCn.Commit();
			return objJsonResult;
			}
			else
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "反关闭失败!原因:" + DBUtility.ClsPub.sExeReturnInfo;
			objJsonResult.data = null;
			oBill.oCn.RollBack();
			return objJsonResult;
			if (ds.Tables[0].Rows[0]["HChecker"] == null \|\| ds.Tables[0].Rows[0]["HChecker"].ToString() == "")
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "单据未审核!不能进行关闭!";
			objJsonResult.data = null;
			return objJsonResult;
			}
			if (ds.Tables[0].Rows[0]["HCloseMan"] == null \|\| ds.Tables[0].Rows[0]["HCloseMan"].ToString() == "")
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "单据未关闭!不需要再反关闭!";
			objJsonResult.data = null;
			return objJsonResult;
			}
			//反关闭单据
			if (!BillOld.CancelClose(Int64.Parse(HInterID), ref ClsPub.sExeReturnInfo))
			{
			objJsonResult.code = "0";
			objJsonResult.count = 1;
			objJsonResult.Message = "反关闭失败!原因:" + ClsPub.sExeReturnInfo;
			objJsonResult.data = null;
			return objJsonResult;
			}
			}
			}
			return objJsonResult;

			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.Message = "执行失败！" + e.ToString();
			objJsonResult.data = null;
			return objJsonResult;
			}
			}
			#endregion

			#region 销售订单作废/反作废
			#region 销售合同行关闭/行反关闭（未完善）
			/// <summary>
			/// </summary>
			/// <param name="HInterID">单据ID</param>
			/// <param name="IsAudit">作废(0),反作废(1)</param>
			/// <param name="CurUserName">作废人</param>
			/// <param name="HEntryID2">子内码付款计划</param>
			/// <param name="HEntryID">子内码物料明细</param>
			/// <param name="IsAudit">关闭(0),反关闭(1)</param>
			/// <param name="CurUserName">关闭人</param>
			/// <returns></returns>
			[Route("Xs_SeOrderBill/DeleteXs_SeOrderBill")]
			//[Route("Xs_ContractBill/CloseRowXs_ContractBill")]
			//[HttpGet]
			//public object CloseRowXs_ContractBill(int HInterID, int HEntryID, int HEntryID2, int IsAudit, string CurUserName)
			//{
			// string ModRightNameCheck = "Xs_ContractBill_Close";
			// string SubBillName = "Xs_ContractBillSub";
			// string SchemeBillName = "Xs_ContractBillScheme"; //子表表名
			// DBUtility.ClsPub.CurUserName = CurUserName;
			// DataSet ds = null;
			// try
			// {
			// //检查权限
			// if (!DBUtility.ClsPub.Security_Log_second(ModRightNameCheck, 1, false, CurUserName))
			// {
			// objJsonResult.code = "0";
			// objJsonResult.count = 0;
			// objJsonResult.Message = "行关闭失败！无权限！";
			// objJsonResult.data = null;
			// return objJsonResult;
			// }
			// //HInterID数据判断
			// if (HInterID <= 0)
			// {
			// objJsonResult.code = "0";
			// objJsonResult.count = 0;
			// objJsonResult.Message = "HInterID小于0！";
			// objJsonResult.data = null;
			// return objJsonResult;
			// }

			// Int64 lngBillKey = 0;
			// lngBillKey = DBUtility.ClsPub.isLong(HInterID); //对HInterID进行类型的转换
			// DAL.ClsXs_ContractBill oBill = new DAL.ClsXs_ContractBill(); //实例化单据操作类，用于进行相关操作

			// //针对需要进行的操作，检验当前单据的状态是否支持需要进行的操作
			// if (oBill.ShowBill(lngBillKey, ref DBUtility.ClsPub.sExeReturnInfo)) //根据HInterID获取该单据的数据
			// {
			// //判断单据条件
			// if (oBill.omodel.HDeleteMan.Trim() != "")
			// {
			// objJsonResult.code = "0";
			// objJsonResult.count = 0;
			// objJsonResult.Message = "单据已作废!不能进行行关闭！";
			// objJsonResult.data = null;
			// return objJsonResult;
			// }
			// if (oBill.omodel.HCloseMan.Trim() != "")
			// {
			// objJsonResult.code = "0";
			// objJsonResult.count = 0;
			// objJsonResult.Message = "单据已关闭!不能进行行关闭！";
			// objJsonResult.data = null;
			// return objJsonResult;
			// }
			// if (oBill.omodel.HChecker.Trim() == "")
			// {
			// objJsonResult.code = "0";
			// objJsonResult.count = 0;
			// objJsonResult.Message = "单据未审核!不能进行行关闭！";
			// objJsonResult.data = null;
			// return objJsonResult;
			// }
			// //判断物料明细表条件
			// string sql = "select * from " + SubBillName + " where HInterID = " + HInterID + " and HEntryID = " + HEntryID;
			// ds = oCN.RunProcReturn(sql, "Xs_ContractBillSub");
			// if (ds == null \|\| ds.Tables[0].Rows.Count == 0)
			// {
			// objJsonResult.code = "0";
			// objJsonResult.count = 0;
			// objJsonResult.Message = "该物料行数据不存在!原因:" + DBUtility.ClsPub.sExeReturnInfo;
			// objJsonResult.data = null;
			// return objJsonResult;
			// }
			// if (IsAudit == 0) //行关闭判断
			// {
			// if (ds.Tables[0].Rows[0]["HCloseMan"].ToString().Trim() != "")
			// {
			// objJsonResult.code = "0";
			// objJsonResult.count = 0;
			// objJsonResult.Message = "物料行已关闭!不能再次行关闭！";
			// objJsonResult.data = null;
			// return objJsonResult;
			// }
			// }
			// if (IsAudit == 1) //行反关闭判断
			// {
			// if (ds.Tables[0].Rows[0]["HCloseMan"].ToString().Trim() == "")
			// {
			// objJsonResult.code = "0";
			// objJsonResult.count = 0;
			// objJsonResult.Message = "物料行未关闭!不需要再行反关闭！";
			// objJsonResult.data = null;
			// return objJsonResult;
			// }

			// //判断行是否为自动关闭
			// string temp = ds.Tables[0].Rows[0]["HCloseType"].ToString();
			// if (ds.Tables[0].Rows[0]["HCloseType"].ToString() == "False")
			// {
			// objJsonResult.code = "0";
			// objJsonResult.count = 0;
			// objJsonResult.Message = "物料行反关闭失败!行为自动关闭，不能进行手动反关闭！";
			// objJsonResult.data = null;
			// return objJsonResult;
			// }
			// }
			// //判断付款计划表条件
			// sql = "select * from " + SchemeBillName + " where HInterID = " + HInterID + " and HEntryID = " + HEntryID2;
			// ds = oCN.RunProcReturn(sql, "Xs_ContractBillScheme");
			// if (ds == null \|\| ds.Tables[0].Rows.Count == 0)
			// {
			// objJsonResult.code = "0";
			// objJsonResult.count = 0;
			// objJsonResult.Message = "该计划行数据不存在!原因:" + DBUtility.ClsPub.sExeReturnInfo;
			// objJsonResult.data = null;
			// return objJsonResult;
			// }
			// if (IsAudit == 0) //行关闭判断
			// {
			// if (ds.Tables[0].Rows[0]["HCloseMan"].ToString().Trim() != "")
			// {
			// objJsonResult.code = "0";
			// objJsonResult.count = 0;
			// objJsonResult.Message = "计划行已关闭!不能再次行关闭！";
			// objJsonResult.data = null;
			// return objJsonResult;
			// }
			// }
			// if (IsAudit == 1) //行反关闭判断
			// {
			// if (ds.Tables[0].Rows[0]["HCloseMan"].ToString().Trim() == "")
			// {
			// objJsonResult.code = "0";
			// objJsonResult.count = 0;
			// objJsonResult.Message = "计划行未关闭!不需要再行反关闭！";
			// objJsonResult.data = null;
			// return objJsonResult;
			// }

			// //判断行是否为自动关闭
			// string temp = ds.Tables[0].Rows[0]["HCloseType"].ToString();
			// if (ds.Tables[0].Rows[0]["HCloseType"].ToString() == "False")
			// {
			// objJsonResult.code = "0";
			// objJsonResult.count = 0;
			// objJsonResult.Message = "计划行反关闭失败!行为自动关闭，不能进行手动反关闭！";
			// objJsonResult.data = null;
			// return objJsonResult;
			// }
			// }
			// }
			// else
			// {
			// objJsonResult.code = "0";
			// objJsonResult.count = 0;
			// objJsonResult.Message = "单据不存在!原因:" + DBUtility.ClsPub.sExeReturnInfo;
			// objJsonResult.data = null;
			// return objJsonResult;
			// }

			// oCN.BeginTran();//开启事务
			// //进行需要进行的行关闭/行反关闭操作
			// if (IsAudit == 0) //行关闭提交
			// {
			// //行关闭提交
			// if (oBill.CloseRow(lngBillKey, HEntryID, HEntryID2, oBill.omodel.HBillNo, CurUserName, ref DBUtility.ClsPub.sExeReturnInfo) == true)
			// {
			// objJsonResult.code = "1";
			// objJsonResult.count = 1;
			// objJsonResult.Message = "行关闭成功";
			// objJsonResult.data = null;
			// return objJsonResult;
			// }
			// else
			// {
			// objJsonResult.code = "0";
			// objJsonResult.count = 0;
			// objJsonResult.Message = "行关闭失败!原因:" + DBUtility.ClsPub.sExeReturnInfo;
			// objJsonResult.data = null;
			// return objJsonResult;
			// }
			// }
			// if (IsAudit == 1) //行反关闭提交
			// {
			// //行反关闭提交
			// if (oBill.CancelRow(lngBillKey, HEntryID, HEntryID2, oBill.omodel.HBillNo, CurUserName, ref DBUtility.ClsPub.sExeReturnInfo) == true)
			// {
			// objJsonResult.code = "1";
			// objJsonResult.count = 1;
			// objJsonResult.Message = "反关闭成功";
			// objJsonResult.data = null;
			// return objJsonResult;
			// }
			// else
			// {
			// objJsonResult.code = "0";
			// objJsonResult.count = 0;
			// objJsonResult.Message = "反关闭失败!原因:" + DBUtility.ClsPub.sExeReturnInfo;
			// objJsonResult.data = null;
			// return objJsonResult;
			// }
			// }
			// oCN.Commit();
			// return objJsonResult;
			// }
			// catch (Exception e)
			// {
			// objJsonResult.code = "0";
			// objJsonResult.count = 0;
			// objJsonResult.Message = "关闭失败或者反关闭失败！" + e.ToString();
			// objJsonResult.data = null;
			// return objJsonResult;
			// }
			//}
			#endregion

			#region 销售合同作废/反作废功能
			[Route("Xs_ContractBill/DropXs_ContractBill")]
			[HttpGet]
			public object DeleteXs_SeOrderBill(int HInterID, int IsAudit, string CurUserName)
			public object DropXs_ContractBill(string HInterID, int Type, string user)
			{
			string ModRightNameCheck = "Xs_SeOrderBill_Delete";
			DBUtility.ClsPub.CurUserName = CurUserName;
			try
			{
			//检查权限
			if (!DBUtility.ClsPub.Security_Log_second(ModRightNameCheck, 1, false, CurUserName))
			//判断是否有作废权限
			if (!DBUtility.ClsPub.Security_Log("Xs_ContractBill_Drop", 1, false, user))
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "作废失败！无权限！";
			objJsonResult.data = null;
			return objJsonResult;
			}
			//HInterID数据判断
			if (HInterID <= 0)
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "HInterID小于0！";
			objJsonResult.Message = "无权限作废!";
			objJsonResult.data = null;
			return objJsonResult;
			}


			Int64 lngBillKey = 0;
			lngBillKey = DBUtility.ClsPub.isLong(HInterID); //对HInterID进行类型的转换
			DAL.ClsXs_SeOrderBill oBill = new DAL.ClsXs_SeOrderBill(); //实例化单据操作类，用于进行相关操作

			//针对需要进行的操作，检验当前单据的状态是否支持需要进行的操作
			if (oBill.ShowBill(lngBillKey, ref DBUtility.ClsPub.sExeReturnInfo)) //根据HInterID获取该单据的数据
			if (string.IsNullOrWhiteSpace(HInterID))
			{
			if (oBill.omodel.HChecker.Trim() != "")
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "HInterID为空！";
			objJsonResult.data = null;
			return objJsonResult;
			}

			ClsPub.CurUserName = user;
			BillOld.MvarItemKey = "Xs_ContractBillMain";
			oCN.BeginTran();//开始事务

			//Type 1 作废 2 反作废
			if (Type == 1)
			{
			//判断单据是否已经作废
			DataSet ds;
			string sql = "select * from " + BillOld.MvarItemKey + " where HinterID = " + HInterID;
			ds = oCN.RunProcReturn(sql, BillOld.MvarItemKey);
			if (ds == null \|\| ds.Tables[0].Rows.Count == 0)
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "单据已审核!不能进行作废！";
			objJsonResult.Message = "单据不存在！";
			objJsonResult.data = null;
			return objJsonResult;
			}
			if (IsAudit == 0) //作废判断
			if (ds.Tables[0] != null && ds.Tables[0].Rows.Count > 0)
			{
			if (oBill.omodel.HDeleteMan.Trim() != "")
			if (ds.Tables[0].Rows[0]["HChecker"] != null && ds.Tables[0].Rows[0]["HChecker"].ToString() != "")
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "单据已作废!不能再作废！";
			objJsonResult.Message = "单据已审核!不能进行作废!";
			objJsonResult.data = null;
			return objJsonResult;
			}
			}
			if (IsAudit == 1) //反作废判断
			{
			if (oBill.omodel.HDeleteMan.Trim() == "")
			if (ds.Tables[0].Rows[0]["HDeleteMan"] != null && ds.Tables[0].Rows[0]["HDeleteMan"].ToString() != "")
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "单据未作废!不需要反作废！";
			objJsonResult.Message = "单据已作废!不需要再作废!";
			objJsonResult.data = null;
			return objJsonResult;
			}
			//作废单据
			if (!BillOld.Cancelltion(Int64.Parse(HInterID), ref ClsPub.sExeReturnInfo))
			{
			objJsonResult.code = "0";
			objJsonResult.count = 1;
			objJsonResult.Message = "作废失败!原因:" + ClsPub.sExeReturnInfo;
			objJsonResult.data = null;
			return objJsonResult;
			}
			@@ -2056,512 +1201,58 @@
			}
			else
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "单据不存在!原因:" + DBUtility.ClsPub.sExeReturnInfo;
			objJsonResult.data = null;
			return objJsonResult;
			//判断单据是否已经反作废
			DataSet ds;
			string sql = "select * from " + BillOld.MvarItemKey + " where HinterID = " + HInterID;
			ds = oCN.RunProcReturn(sql, BillOld.MvarItemKey);
			if (ds.Tables[0] != null && ds.Tables[0].Rows.Count > 0)
			{
			if (ds.Tables[0].Rows[0]["HChecker"] != null && ds.Tables[0].Rows[0]["HChecker"].ToString() != "")
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "单据已审核!不能进行作废!";
			objJsonResult.data = null;
			return objJsonResult;
			}
			if (ds.Tables[0].Rows[0]["HDeleteMan"] == null \|\| ds.Tables[0].Rows[0]["HDeleteMan"].ToString() == "")
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "单据未作废!不需要再反作废!";
			objJsonResult.data = null;
			return objJsonResult;
			}
			//反作废单据
			if (!BillOld.AbandonCancelltion(Int64.Parse(HInterID), ref ClsPub.sExeReturnInfo))
			{
			objJsonResult.code = "0";
			objJsonResult.count = 1;
			objJsonResult.Message = "反作废失败!原因:" + ClsPub.sExeReturnInfo;
			objJsonResult.data = null;
			return objJsonResult;
			}
			}
			}

			oCN.Commit();//提交事务

			//进行需要进行的作废/反作废操作
			if (IsAudit == 0) //作废提交
			{
			//作废提交
			if (oBill.Cancelltion(lngBillKey, ref DBUtility.ClsPub.sExeReturnInfo) == true)
			{
			objJsonResult.code = "1";
			objJsonResult.count = 1;
			objJsonResult.Message = "作废成功";
			objJsonResult.data = null;
			return objJsonResult;
			}
			else
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "作废失败!原因:" + DBUtility.ClsPub.sExeReturnInfo;
			objJsonResult.data = null;
			return objJsonResult;
			}
			}
			if (IsAudit == 1) //反关闭提交
			{
			//反关闭提交
			if (oBill.AbandonCancelltion(lngBillKey, ref DBUtility.ClsPub.sExeReturnInfo) == true)
			{
			objJsonResult.code = "1";
			objJsonResult.count = 1;
			objJsonResult.Message = "反作废成功";
			objJsonResult.data = null;
			return objJsonResult;
			}
			else
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "反作废失败!原因:" + DBUtility.ClsPub.sExeReturnInfo;
			objJsonResult.data = null;
			return objJsonResult;
			}
			}
			return objJsonResult;
			}
			catch (Exception e)
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "作废失败或者反作废失败！" + e.ToString();
			objJsonResult.data = null;
			return objJsonResult;
			}
			}
			#endregion

			#region 销售订单根据客户获取币别、汇率、结算方式
			[Route("Xs_SeOrderBill/getCustomerByCusID")]
			[HttpGet]
			public object getCustomerByCusID(long HCusID)
			{
			try
			{
			string sql = @"select
			c.HItemID HCusID
			,c.HNumber HCusNumber
			,c.HName HCusName
			,c.HSSID
			,s.HName HSSName
			,c.HCurID
			,cur.HName HCurName
			,cur.HExchangeRate HExRate
			,c.HTaxRate
			,c.HLinkMan
			,c.HLinkPhone
			,c.HMobilePhone
			,ISNULL(cre.HCreditRating_Now,0) HCreditRating_Now
			from Gy_Customer as c
			left join Gy_SettleStyle as s on c.HSSID = s.HItemID
			left join Gy_Currency as cur on c.HCurID = cur.HItemID
			left join Gy_Customer_Credit as cre on c.HItemID = cre.HCusID
			where c.HItemID = " + HCusID;
			ds = oCN.RunProcReturn(sql,"Gy_Customer");


			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 = "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 销售订单根据用户获取销售员、销售部门、销售主管
			[Route("Xs_SeOrderBill/getCzyglByUser")]
			[HttpGet]
			public object getCzyglByUser(string CurUserName)
			{
			try
			{
			string sql = @"select
			ISNULL(c.HEmpID,0) HEmpID
			,e.HName HEmpName
			,ISNULL(c.HDeptID,0) HDeptID
			,d.HName HDeptName
			,ISNULL(d.HEmpID,0) HManagerID
			,e1.HName HManagerName
			from Gy_Czygl as c
			left join Gy_Employee as e on c.HEmpID = e.HItemID
			left join Gy_Department as d on c.HDeptID = d.HItemID
			left join Gy_Employee as e1 on d.HEmpID = e1.HItemID
			where c.Czymc = '" + CurUserName + "'";
			ds = oCN.RunProcReturn(sql, "Gy_Czygl");

			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 = "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 销售订单根据用户获取用户关联客户过滤条件
			[Route("Xs_SeOrderBill/getCusIDListByUser")]
			[HttpGet]
			public object getCusIDListByUser(string CurUserID, string CurUserName)
			{
			string sWhere = "";
			string ModRightNameCheck = "Gy_UserLookAllCus";
			DBUtility.ClsPub.CurUserName = CurUserName;
			try
			{
			//权限判断：是否可以查看所有客户
			if (DBUtility.ClsPub.Security_Log_second(ModRightNameCheck, 1, false, CurUserName))
			{
			sWhere = "";
			}
			else
			{
			sWhere = " and HCusID in (select hcusid from Gy_UserCustomerRelation Where HUserID = '" + CurUserID + "' union all select 166351 hcusid)";
			}

			objJsonResult.code = "1";
			objJsonResult.count = 1;
			objJsonResult.Message = "Sucess！";
			objJsonResult.data = sWhere;
			return objJsonResult;
			}
			catch (Exception e)
			{
			sWhere = " and 1=0 ";

			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "Exception！" + e.ToString();
			objJsonResult.data = sWhere;
			return objJsonResult;
			}
			}
			#endregion

			#region 销售订单下推生产订单(无列表)-获取数据
			[Route("Xs_SeOrderBill/loadXs_SeOrderBill_InitICMO")]
			[HttpGet]
			public object loadXs_SeOrderBill_InitICMO(long HInterID,long HEntryID)
			{
			try
			{
			string sql = "select * from h_v_IF_SeOrderBillList where hmainid = " + HInterID + " and HSubID = " + HEntryID;
			ds = oCN.RunProcReturn(sql, "h_v_IF_SeOrderBillList");
			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.Message = "执行成功！";
			objJsonResult.data = null;
			return objJsonResult;
			}
			}
			#endregion
			return objJsonResult; ;

			#region 销售订单检查单据是否存在
			/// <summary>
			/// </summary>
			/// <param name="HInterID">单据ID</param>
			/// <returns></returns>
			[Route("Xs_SeOrderBill/CheckSeOrderBill_IsExist")]
			[HttpGet]
			public object CheckSeOrderBill_IsExist(int HInterID)
			{
			try
			{
			//HInterID数据判断
			if (HInterID <= 0)
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "HInterID小于0！";
			objJsonResult.data = null;
			return objJsonResult;
			}

			Int64 lngBillKey = 0;
			lngBillKey = DBUtility.ClsPub.isLong(HInterID); //对HInterID进行类型的转换
			DAL.ClsXs_SeOrderBill oBill = new DAL.ClsXs_SeOrderBill(); //实例化单据操作类，用于进行相关操作

			//针对需要进行的操作，检验当前单据的状态是否支持需要进行的操作
			if (oBill.ShowBill(lngBillKey, ref DBUtility.ClsPub.sExeReturnInfo)) //根据HInterID获取该单据的数据
			{
			objJsonResult.code = "1";
			objJsonResult.count = 1;
			objJsonResult.Message = "单据存在";
			objJsonResult.data = null;
			return objJsonResult;
			}
			else
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "单据不存在!原因:" + DBUtility.ClsPub.sExeReturnInfo;
			objJsonResult.data = null;
			return objJsonResult;
			}
			}
			catch (Exception e)
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "程序错误！" + e.ToString();
			objJsonResult.data = null;
			return objJsonResult;
			}
			}
			#endregion

			#region 销售订单下查
			/// <summary>
			/// </summary>
			/// <param name="HInterID">单据ID</param>
			/// <returns></returns>
			[Route("Xs_SeOrderBill/SeOrderBill_LookDown")]
			[HttpGet]
			public object SeOrderBill_LookDown(int HInterID)
			{
			try
			{
			List<object> columnNameListSum = new List<object>();
			List<object> columnNameList0 = new List<object>();
			List<object> columnNameList1 = new List<object>();
			List<object> columnNameList2 = new List<object>();
			List<object> columnNameList3 = new List<object>();
			List<object> columnNameList4 = new List<object>();

			string sql = "exec h_p_Xs_SeOrderBill_lookdown " + HInterID;
			ds = oCN.RunProcReturn(sql, "h_p_Xs_SeOrderBill_lookdown");

			//添加销售订单变更单列名
			foreach (DataColumn col in ds.Tables[0].Columns)
			{
			Type dataType = col.DataType;
			string ColmString = "{\"ColmCols\":\"" + col.ColumnName + "\",\"ColmType\":\"" + dataType.Name + "\"}";
			columnNameList0.Add(JsonConvert.DeserializeObject(ColmString));//获取到DataColumn列对象的列名
			}

			//添加生产订单列名
			foreach (DataColumn col in ds.Tables[1].Columns)
			{
			Type dataType = col.DataType;
			string ColmString = "{\"ColmCols\":\"" + col.ColumnName + "\",\"ColmType\":\"" + dataType.Name + "\"}";
			columnNameList1.Add(JsonConvert.DeserializeObject(ColmString));//获取到DataColumn列对象的列名
			}

			//添加特批申请单列名
			foreach (DataColumn col in ds.Tables[2].Columns)
			{
			Type dataType = col.DataType;
			string ColmString = "{\"ColmCols\":\"" + col.ColumnName + "\",\"ColmType\":\"" + dataType.Name + "\"}";
			columnNameList2.Add(JsonConvert.DeserializeObject(ColmString));//获取到DataColumn列对象的列名
			}

			//添加销售出库单列名
			foreach (DataColumn col in ds.Tables[3].Columns)
			{
			Type dataType = col.DataType;
			string ColmString = "{\"ColmCols\":\"" + col.ColumnName + "\",\"ColmType\":\"" + dataType.Name + "\"}";
			columnNameList3.Add(JsonConvert.DeserializeObject(ColmString));//获取到DataColumn列对象的列名
			}

			//添加工序流转卡列名
			foreach (DataColumn col in ds.Tables[4].Columns)
			{
			Type dataType = col.DataType;
			string ColmString = "{\"ColmCols\":\"" + col.ColumnName + "\",\"ColmType\":\"" + dataType.Name + "\"}";
			columnNameList4.Add(JsonConvert.DeserializeObject(ColmString));//获取到DataColumn列对象的列名
			}

			columnNameListSum.Add(columnNameList0);
			columnNameListSum.Add(columnNameList1);
			columnNameListSum.Add(columnNameList2);
			columnNameListSum.Add(columnNameList3);
			columnNameListSum.Add(columnNameList4);

			objJsonResult.code = "1";
			objJsonResult.count = 1;
			objJsonResult.Message = "Sucess！";
			objJsonResult.data = ds.Tables;
			objJsonResult.list = columnNameListSum;
			return objJsonResult;
			}
			catch (Exception e)
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "Exception！" + e.ToString();
			objJsonResult.data = null;
			return objJsonResult;
			}
			}
			#endregion

			#region 销售订单根据主内码与子内码获取销售订单数据
			[Route("Xs_SeOrderBill/loadXs_SeOrderBill_Push")]
			[HttpGet]
			public object loadXs_SeOrderBill_Push(long HInterID,long HSubID)
			{
			try
			{

			ds = oCN.RunProcReturn("select * from h_v_IF_SeOrderBillList where hmainid =" + HInterID + " and hsubid = " + HSubID, "h_v_IF_SeOrderBillList");
			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 = "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 销售订单根据职员获取部门、主管
			[Route("Xs_SeOrderBill/getEmpInfoByHEmpID")]
			[HttpGet]
			public object getEmpInfoByHEmpID(long HEmpID)
			{
			try
			{
			string sql = "select a.HItemID HEmpID,a.HName HEmpName,ISNULL(a.HDeptID,0) HDeptID,b.HName HDeptName,ISNULL(b.HEmpID,0) HManagerID,c.HName HManagerName " +
			" from Gy_Employee as a " +
			" left join Gy_Department as b on a.HDeptID = b.HItemID " +
			" left join Gy_Employee as c on b.HEmpID = c.HItemID " +
			" where a.HItemID = " + HEmpID;
			ds = oCN.RunProcReturn(sql, "Gy_Employee");


			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 = "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 销售订单获取排序后的数据
			[Route("Xs_SeOrderBill/sortList")]
			[HttpGet]
			public object sortList(string sWhere, string user)
			{
			try
			{
			//判断查询权限
			if (!DBUtility.ClsPub.Security_Log("Xs_SeOrderBillQuery", 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_IF_SeOrderBillList order by hmainid desc", "h_v_IF_SeOrderBillList");
			}
			else
			{
			string sql1 = "select * from h_v_IF_SeOrderBillList where 1 = 1 ";
			string sql = sql1 + sWhere;
			ds = oCN.RunProcReturn(sql, "h_v_IF_SeOrderBillList");
			}

			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.Message = "执行失败！" + e.ToString();
			objJsonResult.data = null;
			return objJsonResult;
			}
			}
			#endregion
			}
			}
			}