protected void SchBox_Changed(object sender, EventArgs e)
{
string sch = SchBox.Text;
try
{
SQLServerQuery ss = new SQLServerQuery();
DataTable dt_pis = ss.LoadPIS(sch, "");
if (dt_pis.Rows.Count > 0)
{
string EmployeeID = dt_pis.Rows[0]["P_ID"].ToString();
string Name = dt_pis.Rows[0]["name_fk"].ToString();
string posname = dt_pis.Rows[0]["posname"].ToString();
string unitname = dt_pis.Rows[0]["unitname"].ToString();
EmployeeIDLabel.Text = EmployeeID;
NameLabel.Text = Name;
posnameLabel.Text = posname;
unitnameLabel.Text = unitname;
resultppl.Visible = true;
SavePPL.Enabled = true;
}
else
{
string EmployeeID = "";
string Name = "";
string posname = "";
string unitname = "";
EmployeeIDLabel.Text = EmployeeID;
NameLabel.Text = Name;
posnameLabel.Text = posname;
unitnameLabel.Text = unitname;
SavePPL.Enabled = false;
NoResult.Visible = true;
errorlabel.Text = "ไม่พบข้อมูล";
}
}
catch {
string EmployeeID = "";
string Name = "";
string posname = "";
string unitname = "";
EmployeeIDLabel.Text = EmployeeID;
NameLabel.Text = Name;
posnameLabel.Text = posname;
unitnameLabel.Text = unitname;
SavePPL.Enabled = false;
NoResult.Visible = true;
errorlabel.Text = "ไม่พบข้อมูล";
}
}
private DataTable FindPttBInPis(string PTTB_str)
{
OracleQuery2 cc2 = new OracleQuery2();
DataTable dt = cc2.LoadMobileInPTTB(PTTB_str);
SQLServerQuery ss = new SQLServerQuery();
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("MOBILE");
dtppl.Columns.Add("DEPARTMENT_ID");
dtppl.Columns.Add("EMPLOYEE_ID");
dtppl.Columns.Add("NAME");
dtppl.Columns.Add("COMPANY");
dtppl.Columns.Add("GROUP_ID");
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
{
code = table1["CODE"].ToString(),
DEPART = table1["DEPARTMENT_ID"].ToString(),
mobile = !string.IsNullOrEmpty(table1["mobile"].ToString()) ? table1["mobile"].ToString() : table2["mobile"].ToString(),
name = table2["FULLNAMETH"].ToString(),
unit = table2["unitname"].ToString(),
GROUP_ID = table1["GROUP_ID"].ToString(),
};
foreach (var item in results)
{
dtppl.Rows.Add(item.mobile, item.DEPART, item.code, item.name, item.unit, item.GROUP_ID);
}
}
return(dtppl);
}
private void BindGrid()
{
OracleQuery2 cc2 = new OracleQuery2();
DataTable dt = cc2.LoadAdmin();
SQLServerQuery ss = new SQLServerQuery();
string result = "";
foreach (DataRow r in dt.Rows)
{
result = result + r["EMPLOYEE_ID"].ToString() + ",";
}
result = result.TrimEnd(',');
DataTable dt_pis = ss.LoadINPIS("", result);
DataTable Final_result = new DataTable();
Final_result.Columns.Add("EMPLOYEE_ID");
Final_result.Columns.Add("FULLNAMETH");
Final_result.Columns.Add("POSNAME");
Final_result.Columns.Add("UNITNAME");
Final_result.Columns.Add("IS_ADMIN");
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["EMPLOYEE_ID"].ToString() equals table2["P_ID"].ToString()
select new
{
EMPLOYEE_ID = table1["EMPLOYEE_ID"].ToString(),
FULLNAMETH = table2["FULLNAMETH"].ToString(),
POSNAME = table2["POSNAME"].ToString(),
unitname = table2["unitname"].ToString(),
is_admin = table1["IS_ADMIN"].ToString() == "1"?"ADMIN":"USER"
};
foreach (var item in results)
{
Final_result.Rows.Add(item.EMPLOYEE_ID, item.FULLNAMETH, item.POSNAME, item.unitname, item.is_admin);
}
}
AdminGridView.DataSource = Final_result;
AdminGridView.DataBind();
}