public DataTable GetLastDepartmentPercentage(string supplierCode, string GradeMessageCode, string MainDefineCode) { GradeDepartmentPercentage percentage; DataTable table = new DataTable(); if (GradeMessageCode != "") { percentage = new GradeDepartmentPercentage(); percentage.GradeMessageCode = "'" + GradeMessageCode + "'"; percentage.MainDefineCode = MainDefineCode; percentage.dao = this.dao; return(percentage.GetGradeDepartmentPercentages()); } GradeMessage message = new GradeMessage(); message.SupplierCode = supplierCode; message.MainDefineCode = MainDefineCode; DataTable gradeMessages = new DataTable(); message.dao = this.dao; gradeMessages = message.GetGradeMessages(); string text = ""; int num = 0; if (gradeMessages != null) { foreach (DataRow row in gradeMessages.Select()) { if (num != (gradeMessages.Rows.Count - 1)) { text = text + "'" + row["GradeMessageCode"].ToString() + "',"; } else { text = text + "'" + row["GradeMessageCode"].ToString() + "'"; } num++; } } percentage = new GradeDepartmentPercentage(); percentage.GradeMessageCode = text; percentage.MainDefineCode = MainDefineCode; percentage.dao = this.dao; return(percentage.GetGradeDepartmentPercentages()); }
public static bool GradeMessageStatusChange(string GradeMessageCode, int gm_iStatus, int?gm_iOriginalStatus, bool gm_bSubmitData) { GradeMessage message = new GradeMessage(); return(GradeMessageStatusChange(message.GetGradeMessageByCode(GradeMessageCode), GradeMessageCode, gm_iStatus, gm_iOriginalStatus, gm_bSubmitData)); }