| | |
| | | { |
| | | //判断单据是否已经审核 |
| | | DataSet ds; |
| | | string sql = "select * from Gy_QCCheckProjectMain where HInterID = " + HInterID; |
| | | string sql; |
| | | if(HInterID=="0") |
| | | { |
| | | sql = "select top 1 * from Gy_QCCheckProjectMain order by HInterID desc"; |
| | | |
| | | } |
| | | else |
| | | sql = "select * from Gy_QCCheckProjectMain where HInterID = " + HInterID; |
| | | ds = oCN.RunProcReturn(sql, oBill.MvarItemKey); |
| | | if(ds!=null) |
| | | { |
| | | oBill.omodel.HInterID = Convert.ToInt64(ds.Tables[0].Rows[0]["HInterID"]); |
| | | HInterID = Convert.ToInt64(ds.Tables[0].Rows[0]["HInterID"]).ToString(); |
| | | } |
| | | |
| | | if (ds.Tables[0].Rows[0]["HChecker"] != null && ds.Tables[0].Rows[0]["HChecker"].ToString() != "") |
| | | { |
| | | objJsonResult.code = "0"; |