public void BindPPLDetail() { SchPPL.Text = ""; OracleQuery2 cc2 = new OracleQuery2(); SQLServerQuery ss = new SQLServerQuery(); DataTable dt = cc2.LoadPTTBPPL(); string result = ""; foreach (DataRow r in dt.Rows) { result = result + r["CODE"].ToString() + ","; } result = result.TrimEnd(','); result = result.TrimStart(','); DataTable dt_pis = ss.LoadPosecodeINPIS(result); DataTable dtppl = new DataTable(); dtppl.Columns.Add("POSCODE"); dtppl.Columns.Add("NAME"); dtppl.Columns.Add("POSITION"); dtppl.Columns.Add("COMPANY"); dtppl.Columns.Add("MOBILE"); dtppl.Columns.Add("UPDATE_BY"); dtppl.Columns.Add("LASTUPDATE", typeof(DateTime)); dtppl.Columns.Add("UNITCODE"); dtppl.Columns.Add("CODE"); dtppl.Columns.Add("Keyword"); dtppl.Columns.Add("GROUP_KEY"); dtppl.Columns.Add("MOBILE_FM"); dtppl.Columns.Add("STATUS"); if (dt != null && dt_pis != null && dt.Rows.Count > 0 && dt_pis.Rows.Count > 0) { var results = from table1 in dt.AsEnumerable() join table2 in dt_pis.AsEnumerable() on table1["CODE"].ToString() equals table2["P_ID"].ToString() select new { POSCODE = table1["POSCODE"].ToString(), FULLNAMETH = table2["FULLNAMETH"].ToString(), POSNAME = table2["POSNAME"].ToString(), unitname = table2["unitname"].ToString(), lastupdate = table1["LASTUPDATE"].ToString(), updateby = table1["UPDATE_BY"].ToString(), unitcode = table1["UNITCODE"].ToString(), code = table2["P_ID"].ToString(), keyword = table2["P_ID"].ToString() + " " + table2["FULLNAMETH"].ToString() + " " + table2["POSNAME"].ToString() + " " + table2["unitname"].ToString(), mobile = !string.IsNullOrEmpty(table2["mobile"].ToString()) ? table2["mobile"].ToString() : table1["mobile"].ToString(), MOBILE_FM = !string.IsNullOrEmpty(table2["mobile"].ToString())?1:0, STATUS = table1["STATUS"].ToString(), }; foreach (var item in results) { dtppl.Rows.Add(item.POSCODE, item.FULLNAMETH, item.POSNAME, item.unitname, item.mobile, item.updateby, item.lastupdate, item.unitcode, item.code, item.keyword, 200, item.MOBILE_FM, item.STATUS); } } // dtppl = findPTTPerson(dtppl, group_id); ViewState["CurrentPTTBEditPPL"] = dtppl; ViewState["ALLPPL"] = dtppl; if (dtppl.Rows.Count > 0) { Grid_ppl.DataSource = dtppl; Grid_ppl.DataBind(); PPL_PANEL.Visible = true; } else { Grid_ppl.DataSource = null; Grid_ppl.DataBind(); PPL_PANEL.Visible = false; } }
public void BindPPLDetail(string group_id, int level) { groupLabel.Text = group_id; LevelLabel.Text = level.ToString(); OracleQuery2 cc2 = new OracleQuery2(); SQLServerQuery ss = new SQLServerQuery(); DataTable dt = cc2.LoadPTTBPPL(group_id); string result = ""; foreach (DataRow r in dt.Rows) { result = result + r["CODE"].ToString() + ","; } result = result.TrimEnd(','); result = result.TrimStart(','); DataTable dt_pis = ss.LoadPosecodeINPIS(result); DataTable dtppl = new DataTable(); dtppl.Columns.Add("POSCODE"); dtppl.Columns.Add("NAME"); dtppl.Columns.Add("POSITION"); dtppl.Columns.Add("COMPANY"); dtppl.Columns.Add("MOBILE"); dtppl.Columns.Add("UNITCODE"); dtppl.Columns.Add("CODE"); dtppl.Columns.Add("GROUP_KEY"); if (dt != null && dt_pis != null && dt.Rows.Count > 0 && dt_pis.Rows.Count > 0) { var results = from table1 in dt.AsEnumerable() join table2 in dt_pis.AsEnumerable() on table1["CODE"].ToString() equals table2["P_ID"].ToString() select new { POSCODE = table1["POSCODE"].ToString(), FULLNAMETH = table2["FULLNAMETH"].ToString(), POSNAME = table2["POSNAME"].ToString(), unitname = table2["unitname"].ToString(), unitcode = table1["UNITCODE"].ToString(), code = table1["CODE"].ToString(), mobile = !string.IsNullOrEmpty(table2["mobile"].ToString()) ? table2["mobile"].ToString() : table1["mobile"].ToString() }; foreach (var item in results) { dtppl.Rows.Add(item.POSCODE, item.FULLNAMETH, item.POSNAME, item.unitname, item.mobile, item.unitcode, item.code, 100); } } ViewState["CurrentPTTBPPL"] = dtppl; if (dtppl.Rows.Count > 0) { Grid_ppl.DataSource = dtppl; Grid_ppl.DataBind(); PPL_PANEL.Visible = true; } else { Grid_ppl.DataSource = null; Grid_ppl.DataBind(); PPL_PANEL.Visible = false; } }
protected void SchBox_Changed(object sender, EventArgs e) { string sch = SchBox.Text; try { SQLServerQuery ss = new SQLServerQuery(); string result = ""; DataTable dt = ss.LoadPosecodeINPIS(sch, result); if (dt.Rows.Count > 0) { string POSCODE = dt.Rows[0]["POSCODE"].ToString(); string CODE = dt.Rows[0]["P_ID"].ToString(); string Name = dt.Rows[0]["FULLNAMETH"].ToString(); string posname = dt.Rows[0]["POSNAME"].ToString(); string unitname = dt.Rows[0]["unitname"].ToString(); string unitcode = dt.Rows[0]["unitcode"].ToString(); string MOBILE = dt.Rows[0]["mobile"].ToString(); SetGroup(CODE, unitcode); poscodeLabel.Text = POSCODE; NameLabel.Text = Name; posnameLabel.Text = posname; unitnameLabel.Text = unitname; TelLabel.Text = MOBILE; unitcodeLabel.Text = unitcode; codeLabel.Text = CODE; resultppl.Visible = true; SavePPL.Enabled = true; NoResult.Visible = false; } else { string POSCODE = ""; string Name = ""; string posname = ""; string unitname = ""; string MOBILE = ""; string CODE = ""; string unitcode = ""; poscodeLabel.Text = POSCODE; NameLabel.Text = Name; posnameLabel.Text = posname; unitnameLabel.Text = unitname; TelLabel.Text = MOBILE; unitcodeLabel.Text = unitcode; codeLabel.Text = CODE; SavePPL.Enabled = false; NoResult.Visible = true; errorlabel.Text = "ไม่พบข้อมูล"; resultppl.Visible = false; } } catch { string POSCODE = ""; string Name = ""; string posname = ""; string unitname = ""; string MOBILE = ""; string CODE = ""; string unitcode = ""; TelLabel.Text = MOBILE; poscodeLabel.Text = POSCODE; NameLabel.Text = Name; posnameLabel.Text = posname; unitnameLabel.Text = unitname; unitcodeLabel.Text = unitcode; codeLabel.Text = CODE; SavePPL.Enabled = false; NoResult.Visible = true; errorlabel.Text = "ไม่พบข้อมูล"; resultppl.Visible = false; } }