private void LoadData(string chaseno) { string query = string.Format("select f_applicant, f_content, f_type, f_start, f_end, f_approver, f_title from TB_FORM where f_chaseno = '{0}'", chaseno); using (IDataReader reader = DataService.GetInstance().ExecuteReader(query)) { while (reader.Read()) { txtName.Text = reader.GetString(0); Byte[] content = new Byte[Convert.ToInt32((reader.GetBytes(1, 0, null, 0, Int32.MaxValue)))]; long bytesReceived = reader.GetBytes(1, 0, content, 0, content.Length); ASCIIEncoding encoding = new ASCIIEncoding(); rtbContent.Rtf = encoding.GetString(content, 0, Convert.ToInt32(bytesReceived)); string category = reader.GetString(2); if (category == "IT技術支援") { ckbSupport.Checked = true; } if (category == "IT意見箱") { ckbComment.Checked = true; } txtStart.Text = reader.GetString(3); txtEnd.Text = reader.GetString(4); txtApprover.Text = reader.GetString(5); txtTitle.Text = reader.GetString(6); } } lblExt.Text = "Ext. : " + ExtUtil.GetExt(txtName.Text.Trim()); }
private void LoadData(string mode) { dgvOverview.Rows.Clear(); string query = mode == "" ? "select f_chaseno, f_type, f_created, f_start, f_end, f_approval, f_applicant, f_title, f_status, f_handleby from TB_FORM where f_status != N'申請處理完成' and f_status != N'上司已拒絕' order by f_created desc" : "select f_chaseno, f_type, f_created, f_start, f_end, f_approval, f_applicant, f_title, f_status, f_handleby from TB_FORM order by f_created desc"; tb1 = new DataTable(); tb2 = new DataTable(); string[] headers = { "idle", "chaseno", "st", "type", "created", "applicant", "title", "start", "end", "approval" }; foreach (string header in headers) { tb1.Columns.Add(header); tb2.Columns.Add(header); } tb1.Columns.Add("app", typeof(Image)); tb2.Columns.Add("app", typeof(Image)); tb1.Columns.Add("handle", typeof(string)); tb2.Columns.Add("handle", typeof(string)); using (IDataReader reader = DataService.GetInstance().ExecuteReader(query)) { while (reader.Read()) { string chaseno = reader.GetString(0).Trim(); string category = reader.GetString(1).Trim(); string created = Convert.ToDateTime(reader.GetString(2).Trim()).ToString("yyyy/MM/dd"); string start = reader.GetString(3).Trim(); string end = reader.GetString(4).Trim(); string approval = reader.GetString(5).Trim(); string applicant = reader.GetString(6).Trim(); string title = reader.GetString(7).Trim(); string status = reader.GetString(8).Trim(); string handleby = reader.GetString(9).Trim(); int diff = (int)(DateTime.Today - Convert.ToDateTime(created)).TotalDays; //if (diff != 0) diff += 1; string dt = Convert.ToDateTime(created).ToString("yyyy/MM/dd"); Image app = approval == "---" && (category == "IT技術支援" || category == "IT意見箱") ? Properties.Resources.bullet_grey24 : approval == "---" && category != "IT技術支援" && category != "IT意見箱" ? Properties.Resources.bullet_yellow24 : approval == "Reject" ? Properties.Resources.bullet_red24 : Properties.Resources.bullet_green24; //tb1.Rows.Add(diff, chaseno, status, category, created, applicant, title, start, end, approval, app); if (diff == 0) { tb1.Rows.Add(diff, chaseno, status, category, dt, applicant, title, start, end, approval, app, handleby); } else { tb2.Rows.Add(diff, chaseno, status, category, dt, applicant, title, start, end, approval, app, handleby); } //dgvOverview.Rows.Add(diff,"", category, title, applicant, dt, start, end, app, chaseno, approval); } } /*string r3Text = "select r_chaseno, r_created, r_start, r_title, r_applicant, r_approval, r_status from TB_FORM_R3 where r_status != N'申請處理完成' and r_status != N'經管承認中' and r_status != N'經管已拒絕'"; * using (IDataReader reader = DataService.GetInstance().ExecuteReader(r3Text)) * { * while (reader.Read()) * { * string chaseno = reader.GetString(0).Trim(); * string created = reader.GetString(1); * string start = reader.GetString(2); * string title = reader.GetString(3); * string applicant = reader.GetString(4); * string approval = reader.GetString(5); * string status = reader.GetString(6); * * int diff = (int)(DateTime.Today - Convert.ToDateTime(created)).TotalDays; * * //if (diff != 0) diff += 1; * * string dt = Convert.ToDateTime(created).ToString("yyyy/MM/dd"); * * Image app = approval == "Yes" ? Properties.Resources.bullet_green24 * : approval == "No" ? Properties.Resources.bullet_yellow24 : Properties.Resources.bullet_red24; * * if (diff == 0) * tb1.Rows.Add(diff, chaseno, status, "R3申請", dt, applicant, title, start, "-", approval, app, Properties.Resources.tick_icon); * else * tb2.Rows.Add(diff, chaseno, status, "R3申請", dt, applicant, title, start, "-", approval, app, Properties.Resources.tick_icon); * } * }*/ foreach (DataRow row in tb1.Rows) { dgvOverview.Rows.Add(row.ItemArray[0].ToString(), row.ItemArray[1].ToString(), row.ItemArray[2].ToString(), row.ItemArray[3].ToString(), row.ItemArray[4].ToString(), row.ItemArray[5].ToString(), ExtUtil.GetExt(row.ItemArray[5].ToString().Trim()), row.ItemArray[6].ToString(), row.ItemArray[7].ToString(), row.ItemArray[8].ToString(), row.ItemArray[10], row.ItemArray[9], row.ItemArray[11]); } if (tb2.Rows.Count > 0) { tb2 = tb2.AsEnumerable().OrderByDescending(x => x.ItemArray[0]).CopyToDataTable(); foreach (DataRow row in tb2.Rows) { dgvOverview.Rows.Add(row.ItemArray[0].ToString(), row.ItemArray[1].ToString(), row.ItemArray[2].ToString(), row.ItemArray[3].ToString(), row.ItemArray[4].ToString(), row.ItemArray[5].ToString(), ExtUtil.GetExt(row.ItemArray[5].ToString().Trim()), row.ItemArray[6].ToString(), row.ItemArray[7].ToString(), row.ItemArray[8].ToString(), row.ItemArray[10], row.ItemArray[9], row.ItemArray[11]); } } }