public DataTable GetDefaultValue(String bidEvaluationValue, MRState mrState) { int state = (int)mrState; String strSql = " Select IDKey , VendorName From Vendor Where Vendor.IDKey in(Select VendorID From MR_BIDSummary Where BIDEvaluationID = '" + bidEvaluationValue + "' And ISAwarded=1 And Status >=" + state + ")"; DataTable dt = _da.GetDataTable(strSql); return(dt); }
public DataTable GetDefaultValue(String bidEvaluationValue, MRState mrState) { DataTable dt = daePOBidFlow.GetDefaultValue(bidEvaluationValue, mrState); if (dt != null && dt.Rows.Count == 1) { return(dt); } return(null); }
// Add by ZZH on 2008-1-18 添加验证是否可以删除的方法 public bool CheckState(string strMREnquiryPrice, MRState state) { DataTable dt = daeEnquiryPrice.CheckState(strMREnquiryPrice); int strState = -1; int intState = (int)state; if (dt != null && dt.Rows.Count > 0) { strState = dt.Rows[0]["CheckState"] == DBNull.Value ? 0 : Convert.ToInt32(dt.Rows[0]["CheckState"]); } return(strState >= intState); }
// Add by ZZH on 2008-1-21 添加验证是否可以删除的方法当节点被下一节点引用时,不应被删除 public bool CheckDeleteRecord(String strPKValue, MRState state) { int strState = -1; int intState = (int)state; DataTable dt = daeBIDEvaluation.GetRecord(strPKValue); if (dt != null && dt.Rows.Count > 0) { strState = dt.Rows[0]["State"] == DBNull.Value ? 0 : Convert.ToInt32(dt.Rows[0]["State"]); } return(strState <= intState); }
// Add by ZZH on 2008-1-18 添加验证是否可以删除的方法 public bool CheckState(String strMRID, MRState state) { DataTable dt = _daeMaterialRequest.CheckState(strMRID); int strState = -1; int intState = (int)state; if (dt != null && dt.Rows.Count > 0) { strState = dt.Rows[0]["CheckState"] == DBNull.Value ? 0 : Convert.ToInt32(dt.Rows[0]["CheckState"]); } return(strState >= intState); }