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());
        }
Exemple #2
0
        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));
        }