MES-WEB-API.git

			@@ -580,7 +580,94 @@
			oCn.RunProc("update Xs_SeOrderBillMain set HPrintQty=HPrintQty + 1 Where HInterID= " + sInterID.ToString());
			}


			//åèµ·å®¡æ¹
			public bool startCheckFlow(Int64 lngBillKey,Int64 HCheckFlowID_select, ref string sReturn)
			{
			try
			{
			string HBillNo = ""; //åæ®å·
			string HCheckFlowID = ""; //å®¡æ¹æµID
			string HCheckItemNowID = ""; //å½åå®¡æ ¸é¡¹ç®ID
			string HCheckItemNextID = ""; //å¾å®¡æ ¸é¡¹ç®ID

			//å¤ææ¯å¦å·²ç»åèµ·å®¡æ¹
			string sql0 = "select * from Xt_BillCheckFlowStatus where HBillInterID = " + lngBillKey + " and HBillTypeID = '" + this.BillType + "'";
			DataSet ds0 = oCn.RunProcReturn(sql0, "Xt_BillCheckFlowStatus");
			if (ds0 != null && ds0.Tables[0].Rows.Count > 0)
			{
			sReturn = "åæ®å·²åèµ·å®¡æ¹ï¼ä¸å¯éå¤å®¡æ¹ï¼";
			return false;
			}

			//è·ååæ®æ°æ®
			string sql = "select * from " + this.MvarItemKey + " where HInterID = " + lngBillKey;
			DataSet ds = oCn.RunProcReturn(sql, this.MvarItemKey);
			if (ds == null \|\| ds.Tables[0].Rows.Count == 0)
			{
			sReturn = "åæ®ä¸åå¨ï¼";
			return false;
			}
			HBillNo = ds.Tables[0].Rows[0]["HBillNo"].ToString();

			//è·ååæ®ç±»åå¯¹åºçé»è®¤å®¡æ¹æµ
			string sql1 = "select b.HInterID,b.HCheckItemID from Xt_CheckFlowMain as a " +
			"inner join Xt_CheckFlowSub as b on a.HInterID = b.HInterID " +
			"where a.HBillTypeID = '" + this.BillType + "' " +
			"and a.HInterID = " + HCheckFlowID_select + " " +
			"order by b.HFlowNo asc";
			DataSet ds1 = oCn.RunProcReturn(sql1, "Xt_CheckFlowMain");
			if (ds1 == null \|\| ds1.Tables[0].Rows.Count == 0)
			{
			sReturn = "é»è®¤å®¡æ¹æµä¸åå¨ï¼";
			return false;
			}

			HCheckFlowID = ds1.Tables[0].Rows[0]["HInterID"].ToString();
			HCheckItemNowID = ds1.Tables[0].Rows[0]["HCheckItemID"].ToString();
			if (ds1.Tables[0].Rows.Count >= 2)
			{
			HCheckItemNextID = ds1.Tables[0].Rows[1]["HCheckItemID"].ToString();
			}
			else
			{
			HCheckItemNextID = "0";
			}

			oCn.BeginTran();
			//å¢å åæ®å®¡æ¹ç¶æè¡¨ æ°æ®
			for (int i = 0; i < ds1.Tables[0].Rows.Count; i++)
			{
			string sql2 = "insert into Xt_BillCheckFlowStatus" +
			"(HBillTypeID,HBillInterID,HBillNo,HCheckFlowID,HCheckItemID,HChecker,HCheckDate,HCheckNote) " +
			"values(" +
			"'" + this.BillType + "'," +
			"" + lngBillKey + "," +
			"'" + HBillNo + "'," +
			"" + ds1.Tables[0].Rows[i]["HInterID"].ToString() + "," +
			"" + ds1.Tables[0].Rows[i]["HCheckItemID"].ToString() + "," +
			"" + "''" + "," +
			"" + "''" + "," +
			"" + "''" + "" +
			")";

			oCn.RunProc(sql2);
			}

			//æ´æ°ä¸»è¡¨ å®¡æ¹æµ æ°æ®
			string sql3 = "update " + this.MvarItemKey + " set HCheckFlowID = " + HCheckFlowID + ",HCheckItemNowID=" + HCheckItemNowID + ",HCheckItemNextID=" + HCheckItemNextID + " where HInterID = " + lngBillKey;
			oCn.RunProc(sql3);


			oCn.Commit();

			return true;
			}
			catch(Exception e)
			{
			sReturn += e.Message;
			return false;
			}
			}
			}

			}