MES-WEB-API.git

			@@ -43,6 +43,8 @@
			public DAL.ClsGy_ProjectMoneyBOMBill BillNew7 = new DAL.ClsGy_ProjectMoneyBOMBill(); //é¡¹ç®è´¹ç¨æ¸åå¯¹åºåæ®ç±»
			public DAL.ClsGy_ProjectMoneyBOMBill BillOld7 = new DAL.ClsGy_ProjectMoneyBOMBill();



			#region å·¥ç¨é¡¹ç® æ°å¢/ç¼è¾
			#region å·¥ç¨é¡¹ç® è¡¨å¤´æ°æ®
			public class PM_ProjectBill_Main
			@@ -101,6 +103,7 @@
			public string HProjectNote;
			public string HContacts;
			public string HContactNumber;
			public int HDeptID;

			public int HSupplierID; //åååä½ï¼gy_supllierï¼
			public int HMangerEmpID; //ç®¡çåï¼gy_Employeeï¼
			@@ -115,6 +118,10 @@
			public string HWaterSupplyDate; //éæ°´æ¥æ
			public string HWorkNote; //ç«£å·¥èµæï¼å¯ææ¬ï¼
			public string HWorkProcNote; //æ½å·¥å®ææåµï¼å¯ææ¬ï¼
			public string HProBeginDate; //å·¥ç¨å¼å·¥æ¥æ
			public string HProEndDate; //å·¥ç¨å®å·¥æ¥æ
			public int HProPMEmpID; //å·¥ç¨é¡¹ç®ç»ç
			public string HWorkPicNumber; //ç«£å·¥å¾ç¼å·

			public double HYuSuanMoney; //é¢ç®é ä»·
			public double HHeTongMoney; //ååé ä»·
			@@ -124,8 +131,8 @@
			public double HAnZhuangMoney; //å®è£è´¹
			public double HBanZuMoney; //çç»å·¥è´¹
			public double HYuShouKuanMoney; //é¢æ¶æ¬¾
			public double HGongFeiMoney; //å·¥è´¹ç»è´¦
			public double HJieZhangMoney; //ç»ç®ç»è´¦
			public string HGongFeiMoney; //å·¥è´¹ç»è´¦
			public string HJieZhangMoney; //ç»ç®ç»è´¦

			public int HTaskClassID; //ä»»å¡å¤§ç±»(Gy_TaskClass)
			public int HTaskClassEntryID; //ä»»å¡é¡¹ç®åç±»(Gy_TaskClass)
			@@ -317,7 +324,7 @@
			string HProjectNote = mainList[0].HProjectNote;
			string HContacts = mainList[0].HContacts;
			string HContactNumber = mainList[0].HContactNumber;

			int HDeptID = mainList[0].HDeptID; //é¨é¨

			int HSupplierID = mainList[0].HSupplierID; //åååä½ï¼gy_supllierï¼
			int HMangerEmpID = mainList[0].HMangerEmpID; //ç®¡çåï¼gy_Employeeï¼
			@@ -332,7 +339,10 @@
			string HWaterSupplyDate = mainList[0].HWaterSupplyDate; //éæ°´æ¥æ
			string HWorkNote = mainList[0].HWorkNote; //ç«£å·¥èµæï¼å¯ææ¬ï¼
			string HWorkProcNote = mainList[0].HWorkProcNote; //æ½å·¥å®ææåµï¼å¯ææ¬ï¼

			int HProPMEmpID = mainList[0].HProPMEmpID; //é¡¹ç®ç»ç
			string HWorkPicNumber = mainList[0].HWorkPicNumber; //ç«£å·¥å¾ç¼å·
			string HProBeginDate = mainList[0].HProBeginDate; //é¡¹ç®å¼å·¥æ¥æ
			string HProEndDate = mainList[0].HProEndDate; //é¡¹ç®å®å·¥æ¥æ
			double HYuSuanMoney = mainList[0].HYuSuanMoney; //é¢ç®é ä»·
			double HHeTongMoney = mainList[0].HHeTongMoney; //ååé ä»·
			double HJieSuanMoney = mainList[0].HJieSuanMoney; //ç»ç®é ä»·
			@@ -341,8 +351,8 @@
			double HAnZhuangMoney = mainList[0].HAnZhuangMoney; //å®è£è´¹
			double HBanZuMoney = mainList[0].HBanZuMoney; //çç»å·¥è´¹
			double HYuShouKuanMoney = mainList[0].HYuShouKuanMoney; //é¢æ¶æ¬¾
			double HGongFeiMoney = mainList[0].HGongFeiMoney; //å·¥è´¹ç»è´¦
			double HJieZhangMoney = mainList[0].HJieZhangMoney; //ç»ç®ç»è´¦
			string HGongFeiMoney = mainList[0].HGongFeiMoney; //å·¥è´¹ç»è´¦
			string HJieZhangMoney = mainList[0].HJieZhangMoney; //ç»ç®ç»è´¦

			int HTaskClassID = mainList[0].HTaskClassID; //ä»»å¡å¤§ç±»(Gy_TaskClass)
			int HTaskClassEntryID = mainList[0].HTaskClassEntryID; //ä»»å¡é¡¹ç®åç±»(Gy_TaskClass)
			@@ -403,7 +413,7 @@
			"(HYear,HPeriod,HBillType,HBillSubType,HInterID,HDate,HBillNo,HBillStatus,HRemark,HMaker,HMakeDate,HProNumber,HProName,HCusID,HBeginDate,HEndDate,HSumMoney," +
			"HProMoney,HWorkMoney,HOtherMoney,HProType,HPMEmpID,HWorkEmpID,HDepEmpID,HConWorkDays,HDepDays,HLastMoney,HPayCusID,HOrgID,HMaterID,HProjectClassID,HBuildComp,HBuildAddress,HWorkNo,HReDate,HPicNo,HWorkTask,HProjectNote,HContacts,HContactNumber" +
			",HSupplierID,HMangerEmpID,HMaterPlanDate,HWorkerID,HPlanWorkTimes,HRelWorkTimes,HTestDate,HTestCheckerID,HTestNote,HSewageDate,HWaterSupplyDate,HWorkNote,HWorkProcNote,HYuSuanMoney,HHeTongMoney,HJieSuanMoney,HShenJiMoney,HCaiLiaoMoney,HAnZhuangMoney,HBanZuMoney,HYuShouKuanMoney,HGongFeiMoney,HJieZhangMoney," +
			"HTaskClassID,HTaskClassEntryID,HTaskAddress,HBreakStatus,HWaterLeakage,HPipeDiameter,HPipeMaterial,HAlarmEmp,HAlarmLink,HReceEmp,HReceTime,HTaskMaterMoney,HTaskSetupMoney,HTaskOtherMoney,HTaskExamMoney,HTaskWorkMoney,HIsAccount,HAccountDate,HAccountWorkMoneyDate,HIsCheckExam,HIsCheckWorkMoney,HInfoBackTime,HInfoBackMan,HInfoNote,HTaskBTime,HTaskETime,HTaskNote,HTaskWorkEmp,HBeginCloseValveTime,HEndCloseValveTime,HCloseValveQty,HBeginOpenValveTime,HEndOpenValveTime,HOpenValveQty,HValveWorkEmp,HTaskRemark)" +
			"HTaskClassID,HTaskClassEntryID,HTaskAddress,HBreakStatus,HWaterLeakage,HPipeDiameter,HPipeMaterial,HAlarmEmp,HAlarmLink,HReceEmp,HReceTime,HTaskMaterMoney,HTaskSetupMoney,HTaskOtherMoney,HTaskExamMoney,HTaskWorkMoney,HIsAccount,HAccountDate,HAccountWorkMoneyDate,HIsCheckExam,HIsCheckWorkMoney,HInfoBackTime,HInfoBackMan,HInfoNote,HTaskBTime,HTaskETime,HTaskNote,HTaskWorkEmp,HBeginCloseValveTime,HEndCloseValveTime,HCloseValveQty,HBeginOpenValveTime,HEndOpenValveTime,HOpenValveQty,HValveWorkEmp,HTaskRemark,HDeptID,HProPMEmpID,HWorkPicNumber,HProBeginDate,HProEndDate)" +
			"values(" +
			"" + HYear +
			"," + HPeriod +
			@@ -473,7 +483,7 @@
			",'" + HTaskExamMoney + "'" + ",'" + HTaskWorkMoney + "'" + ",'" + (HIsAccount?1:0) + "'" + ",'" + HAccountDate + "'" + ",'" + HAccountWorkMoneyDate + "'" + ",'" + (HIsCheckExam ? 1 : 0) + "'" +
			",'" + (HIsCheckWorkMoney ? 1 : 0) + "'" + ",'" + HInfoBackTime + "'" + ",'" + HInfoBackMan + "'" + ",'" + HInfoNote + "'" + ",'" + HTaskBTime + "'" +
			",'" + HTaskETime + "'" + ",'" + HTaskNote + "'" + ",'" + HTaskWorkEmp + "'" + ",'" + HBeginCloseValveTime + "'" + ",'" + HEndCloseValveTime + "'" +
			",'" + HCloseValveQty + "'" + ",'" + HBeginOpenValveTime + "'" + ",'" + HEndOpenValveTime + "'" + ",'" + HOpenValveQty + "'" + ",'" + HValveWorkEmp + "'" + ",'" + HTaskRemark + "'" +
			",'" + HCloseValveQty + "'" + ",'" + HBeginOpenValveTime + "'" + ",'" + HEndOpenValveTime + "'" + ",'" + HOpenValveQty + "'" + ",'" + HValveWorkEmp + "'" + ",'" + HTaskRemark + "','" + HDeptID + "','" + HProPMEmpID + "','" + HWorkPicNumber + "','" + HProBeginDate + "','" + HProEndDate + "'"+
			")";

			//ä¸»è¡¨
			@@ -552,10 +562,9 @@
			"',HTaskSetupMoney = '" + HTaskSetupMoney + "',HTaskOtherMoney = '" + HTaskOtherMoney + "',HTaskExamMoney = '" + HTaskExamMoney + "',HTaskWorkMoney = '" + HTaskWorkMoney + "',HIsAccount = '" + (HIsAccount?1:0) + "',HAccountDate = '" + HAccountDate +
			"',HAccountWorkMoneyDate = '" + HAccountWorkMoneyDate + "',HIsCheckExam = '" + (HIsCheckExam?1:0) + "',HIsCheckWorkMoney = '" + (HIsCheckWorkMoney?1:0) + "',HInfoBackTime = '" + HInfoBackTime + "',HInfoBackMan = '" + HInfoBackMan + "',HInfoNote = '" + HInfoNote +
			"',HTaskBTime = '" + HTaskBTime + "',HTaskETime = '" + HTaskETime + "',HTaskNote = '" + HTaskNote + "',HTaskWorkEmp = '" + HTaskWorkEmp + "',HBeginCloseValveTime = '" + HBeginCloseValveTime + "',HEndCloseValveTime = '" + HEndCloseValveTime +
			"',HCloseValveQty = '" + HCloseValveQty + "',HBeginOpenValveTime = '" + HBeginOpenValveTime + "',HEndOpenValveTime = '" + HEndOpenValveTime + "',HOpenValveQty = '" + HOpenValveQty + "',HValveWorkEmp = '" + HValveWorkEmp + "',HTaskRemark = '" + HTaskRemark +

			"',HCloseValveQty = '" + HCloseValveQty + "',HBeginOpenValveTime = '" + HBeginOpenValveTime + "',HEndOpenValveTime = '" + HEndOpenValveTime + "',HOpenValveQty = '" + HOpenValveQty + "',HValveWorkEmp = '" + HValveWorkEmp + "',HTaskRemark = '" + HTaskRemark + "',HDeptID = '" + HDeptID + "'" +
			",HProBeginDate = '" + HProBeginDate + "',HProEndDate = '" + HProEndDate + "',HProPMEmpID = '" + HProPMEmpID + "',HWorkPicNumber = '" + HWorkPicNumber +
			"' where HInterID = " + HInterID;

			oCN.RunProc(sql);

			//å é¤åè¡¨
			@@ -809,6 +818,44 @@
			}
			#endregion

			#region (ä»»å¡ç±»ï¼çå·¥ç¨é¡¹ç®æ°å¢ æ ¹æ®ä»»å¡å¤§ç±» ä»»å¡é¡¹ç®åç±» æ¥æ æ´æ° é¡¹ç®ä»£ç
			[Route("PM_ProjectBill/GetHProjectHNumber")]
			[HttpGet]
			public object GetHProjectHNumber( int HDeptID, DateTime HDate,int HTaskClassID,int HTaskClassEntryID,int HType)
			{
			DataSet ds;
			try
			{
			List<object> columnNameList = new List<object>();


			ds = oCN.RunProcReturn("exec h_p_Xt_GetMaxBillNo_SubType '4750','" + HDate + "','" + HTaskClassID + "','" + HTaskClassEntryID + "','" + HDeptID + "',"+HType, "h_p_Xt_GetMaxBillNo_SubType");

			//æ·»å åå
			foreach (DataColumn col in ds.Tables[0].Columns)
			{
			Type dataType = col.DataType;
			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 = columnNameList;
			return objJsonResult;
			}
			catch (Exception e)
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "Exceptionï¼" + e.ToString();
			objJsonResult.data = null;
			return objJsonResult;
			}
			}
			#endregion

			#region å·¥ç¨é¡¹ç® ç¼è¾-é¡µé¢èµå¼
			/// <summary>
			@@ -1502,6 +1549,44 @@
			return objJsonResult;
			}
			}
			#endregion

			#region å·¥ç¨é¡¹ç® ä»»å¡å®è£è´¹ ãä»»å¡èæ ¸è´¹ãä»»å¡éå±è´¹ãä»»å¡å·¥è´¹ éæ©é¡¹ç®è´¹ç¨åç±»è¿å å¯¹åºåç±»çé¡¹ç®è´¹ç¨
			[Route("PM_ProjectBill/getGy_Project")]
			[HttpGet]
			public object getGy_Project(string HItemID)
			{
			try
			{

			ds = oCN.RunProcReturn("select top 1 * from Gy_ProjectMoney where HProjectMoneyClassID='"+HItemID+ "' and isnull(HCheckEmp,'') !='' and HStopflag=0 order by HItemID desc", "Gy_ProjectMoney");

			if (ds == null \|\| ds.Tables.Count == 0 \|\| ds.Tables[0].Rows.Count == 0)
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "è¯¥é¡¹ç®è´¹ç¨åç±»ä¸çé¡¹ç®è´¹ç¨æ æ°æ®";
			objJsonResult.data = null;
			return objJsonResult;
			}


			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 æåº¦é¶æ®µè®¡åä¿å/ç¼è¾
			@@ -5670,5 +5755,386 @@
			}
			#endregion
			#endregion


			#region é¡¹ç®è´¹ç¨å¾å®¡æ ¸åè¡¨
			#region å·¥ç¨é¡¹ç®è´¹ç¨å¾å®¡æ ¸åè¡¨
			[Route("PM_ProjectBill/NeedCheckQuery")]
			[HttpGet]
			public object PM_ProjectBillNeedCheckQuery(string user,string sWhere)
			{
			DataSet ds;
			try
			{
			List<object> columnNameList = new List<object>();
			//å¤ææé
			//if (!DBUtility.ClsPub.Security_Log("Cg_POInStockBillQuery", 1, false, user))
			//{
			// objJsonResult.code = CodeConstant.FAIL;
			// objJsonResult.count = CountConstant.FAIL;
			// objJsonResult.Message = "æ¨æ²¡æè¯¥æ¨¡åæé,è¯·ä¸ç®¡çåèç³»ï¼";
			// objJsonResult.data = null;
			// return objJsonResult;
			//}
			//sWhere = sWhere.Replace("'", "''");
			ds = oCN.RunProcReturn("exec h_p_PM_ProjectBillNeedCheckQuery " + sWhere, "h_p_PM_ProjectBillNeedCheckQuery");

			//æ·»å åå
			foreach (DataColumn col in ds.Tables[0].Columns)
			{
			Type dataType = col.DataType;
			string ColmString = "{\"ColmCols\":\"" + col.ColumnName + "\",\"ColmType\":\"" + dataType.Name + "\"}";
			columnNameList.Add(JsonConvert.DeserializeObject(ColmString));//è·åå°DataColumnåå¯¹è±¡çåå
			}

			objJsonResult.code = CodeConstant.SUCCEED;
			objJsonResult.count = CountConstant.SUCCEED;
			objJsonResult.Message = "Sucessï¼";
			objJsonResult.list = columnNameList;
			objJsonResult.data = ds.Tables[0];
			return objJsonResult;
			}
			catch (Exception e)
			{
			objJsonResult.code = CodeConstant.FAIL;
			objJsonResult.count = CountConstant.FAIL;
			objJsonResult.Message = "Exceptionï¼" + e.ToString();
			objJsonResult.data = null;
			return objJsonResult;
			}
			}
			#endregion

			#region å·¥ç¨é¡¹ç®è´¹ç¨ å®¡æ ¸/åå®¡æ ¸

			[Route("PM_ProjectBill/AuditTaskMoney")]
			[HttpGet]
			public object AuditTaskMoney(string HInterID, string Type, string user)
			{
			try
			{
			//å¤ææ¯å¦æå®¡æ ¸æé
			if (!DBUtility.ClsPub.Security_Log("Pm_ProjectBill_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;
			BillOld.MvarItemKey = "PM_ProjectBillMain";
			oCN.BeginTran();//å¼å§äºå¡
			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.data = null;
			return objJsonResult;
			}
			//Type ä»»å¡å®è£è´¹å®¡æ ¸æ è®°
			if (Type == "SetupMoneyCheck")
			{
			if (ds.Tables[0].Rows[0]["HTaskSetupMoneyCheckFlag"].ToString() == "False")
			{
			oCN.RunProcReturn("update PM_ProjectBillMain set HTaskSetupMoneyCheckFlag = 1 where HInterID = " + HInterID, "PM_ProjectBillMain");
			}
			else
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "è´¹ç¨å·²å®¡æ ¸ï¼";
			objJsonResult.data = null;
			return objJsonResult; ;
			}
			}
			//ä»»å¡éå±å®¡æ ¸
			else if (Type == "OtherMoneyCheck")
			{
			if (ds.Tables[0].Rows[0]["HTaskOtherMoneyCheckFlag"].ToString() == "False")
			{
			oCN.RunProcReturn("update PM_ProjectBillMain set HTaskOtherMoneyCheckFlag = 1 where HInterID = " + HInterID, "PM_ProjectBillMain");
			}
			else
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "è´¹ç¨å·²å®¡æ ¸ï¼";
			objJsonResult.data = null;
			return objJsonResult; ;
			}
			}
			//ä»»å¡èæ ¸è´¹å®¡æ ¸
			else if (Type == "ExamMoneyCheck")
			{
			if (ds.Tables[0].Rows[0]["HTaskExamMoneyCheckFlag"].ToString() == "False")
			{
			oCN.RunProcReturn("update PM_ProjectBillMain set HTaskExamMoneyCheckFlag = 1 where HInterID = " + HInterID, "PM_ProjectBillMain");
			}
			else
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "è´¹ç¨å·²å®¡æ ¸ï¼";
			objJsonResult.data = null;
			return objJsonResult; ;
			}
			}
			//ä»»å¡å·¥è´¹å®¡æ ¸æ è®°
			else if (Type == "WorkMoneyCheck")
			{
			if (ds.Tables[0].Rows[0]["HTaskWorkMoneyCheckFlag"].ToString() == "False")
			{
			oCN.RunProcReturn("update PM_ProjectBillMain set HTaskWorkMoneyCheckFlag = 1 where HInterID = " + HInterID, "PM_ProjectBillMain");
			}
			else
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "è´¹ç¨å·²å®¡æ ¸ï¼";
			objJsonResult.data = null;
			return objJsonResult; ;
			}
			}
			//åå®¡æ ¸è´¹ç¨
			else if (Type == "UnCheck")
			{

			oCN.RunProcReturn("update PM_ProjectBillMain set HTaskWorkMoneyCheckFlag = 0,HTaskExamMoneyCheckFlag = 0,HTaskOtherMoneyCheckFlag = 0,HTaskSetupMoneyCheckFlag = 0 where HInterID = " + HInterID, "PM_ProjectBillMain");
			}
			else
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "å®¡æ ¸ç±»åä¸åå¨ï¼";
			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

			#endregion

			#region é¡¹ç®è´¹ç¨å¾ä¿ååè¡¨
			#region å·¥ç¨é¡¹ç®è´¹ç¨å¾ä¿ååè¡¨
			[Route("PM_ProjectBill/NeedSaveQuery")]
			[HttpGet]
			public object PM_ProjectBillNeedSaveQuery(string user,string sWhere)
			{
			DataSet ds;
			try
			{
			List<object> columnNameList = new List<object>();
			//å¤ææé
			//if (!DBUtility.ClsPub.Security_Log("Cg_POInStockBillQuery", 1, false, user))
			//{
			// objJsonResult.code = CodeConstant.FAIL;
			// objJsonResult.count = CountConstant.FAIL;
			// objJsonResult.Message = "æ¨æ²¡æè¯¥æ¨¡åæé,è¯·ä¸ç®¡çåèç³»ï¼";
			// objJsonResult.data = null;
			// return objJsonResult;
			//}
			//sWhere = sWhere.Replace("'", "''");
			ds = oCN.RunProcReturn("exec h_p_PM_ProjectBillNeedSaveQuery "+sWhere, "h_p_PM_ProjectBillNeedSaveQuery");

			//æ·»å åå
			foreach (DataColumn col in ds.Tables[0].Columns)
			{
			Type dataType = col.DataType;
			string ColmString = "{\"ColmCols\":\"" + col.ColumnName + "\",\"ColmType\":\"" + dataType.Name + "\"}";
			columnNameList.Add(JsonConvert.DeserializeObject(ColmString));//è·åå°DataColumnåå¯¹è±¡çåå
			}

			objJsonResult.code = CodeConstant.SUCCEED;
			objJsonResult.count = CountConstant.SUCCEED;
			objJsonResult.Message = "Sucessï¼";
			objJsonResult.list = columnNameList;
			objJsonResult.data = ds.Tables[0];
			return objJsonResult;
			}
			catch (Exception e)
			{
			objJsonResult.code = CodeConstant.FAIL;
			objJsonResult.count = CountConstant.FAIL;
			objJsonResult.Message = "Exceptionï¼" + e.ToString();
			objJsonResult.data = null;
			return objJsonResult;
			}
			}
			#endregion

			#region å·¥ç¨é¡¹ç®è´¹ç¨ ä¿ååä¿å

			[Route("PM_ProjectBill/SaveTaskMoney")]
			[HttpGet]
			public object SaveTaskMoney(string HInterID, string Type, string user,int HMoney)
			{
			try
			{
			//å¤ææ¯å¦æå®¡æ ¸æé
			if (!DBUtility.ClsPub.Security_Log("Pm_ProjectBill_edit", 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;
			BillOld.MvarItemKey = "PM_ProjectBillMain";
			oCN.BeginTran();//å¼å§äºå¡
			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.data = null;
			return objJsonResult;
			}
			//Type ä»»å¡å®è£è´¹ä¿åæ è®°
			if (Type == "SetupMoneySave")
			{
			if (ds.Tables[0].Rows[0]["HTaskSetupMoneySaveFlag"].ToString() == "False")
			{
			oCN.RunProcReturn("update PM_ProjectBillMain set HTaskSetupMoneySaveFlag = 1,HTaskSetupMoney="+HMoney+" where HInterID = " + HInterID, "PM_ProjectBillMain");
			}
			else
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "è´¹ç¨å·²ä¿åï¼";
			objJsonResult.data = null;
			return objJsonResult; ;
			}
			}
			//ä»»å¡éå±ä¿å
			else if (Type == "OtherMoneySave")
			{
			if (ds.Tables[0].Rows[0]["HTaskOtherMoneySaveFlag"].ToString() == "False")
			{
			oCN.RunProcReturn("update PM_ProjectBillMain set HTaskOtherMoneySaveFlag = 1,HTaskOtherMoney=" + HMoney + " where HInterID = " + HInterID, "PM_ProjectBillMain");
			}
			else
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "è´¹ç¨å·²ä¿åï¼";
			objJsonResult.data = null;
			return objJsonResult; ;
			}
			}
			//ä»»å¡èæ ¸è´¹ä¿å
			else if (Type == "ExamMoneySave")
			{
			if (ds.Tables[0].Rows[0]["HTaskExamMoneySaveFlag"].ToString() == "False")
			{
			oCN.RunProcReturn("update PM_ProjectBillMain set HTaskExamMoneySaveFlag = 1,HTaskExamMoney=" + HMoney + " where HInterID = " + HInterID, "PM_ProjectBillMain");
			}
			else
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "è´¹ç¨å·²ä¿åï¼";
			objJsonResult.data = null;
			return objJsonResult; ;
			}
			}
			//ä»»å¡å·¥è´¹ä¿åæ è®°
			else if (Type == "WorkMoneySave")
			{
			if (ds.Tables[0].Rows[0]["HTaskWorkMoneySaveFlag"].ToString() == "False")
			{
			oCN.RunProcReturn("update PM_ProjectBillMain set HTaskWorkMoneySaveFlag = 1,HTaskWorkMoney=" + HMoney + " where HInterID = " + HInterID, "PM_ProjectBillMain");
			}
			else
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "è´¹ç¨å·²ä¿åï¼";
			objJsonResult.data = null;
			return objJsonResult; ;
			}
			}
			//åä¿åè´¹ç¨
			else if (Type == "UnSave")
			{

			oCN.RunProcReturn("update PM_ProjectBillMain set HTaskWorkMoneySaveFlag = 0,HTaskExamMoneySaveFlag = 0,HTaskOtherMoneySaveFlag = 0,HTaskSetupMoneySaveFlag = 0 where HInterID = " + HInterID, "PM_ProjectBillMain");
			}
			else
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "å®¡æ ¸ç±»åä¸åå¨ï¼";
			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

			#endregion
			}
			}