private void runQuery()
{
string sp = payload["sp"].ToString();
bool noresult = Convert.ToBoolean(payload["noresult"]);
string[] param = null;
if (payload["parameters"] != null)
{
param = (payload["parameters"] as ArrayList).ToArray(typeof(string)) as string[];
}
SQLOutput res = null;
if (noresult)
{
res = SQLServerQuery.noResultQuery(sp, param, "FASSQL2", "WebApps");
}
else
{
res = SQLServerQuery.Query(sp, param, "FASSQL2", "WebApps");
}
if (res.Error == "")
{
if (!noresult)
{
resp.payload = res.JSON;
}
}
else
{
resp.SetError(GenericResponse.errorLevels.SQLError);
}
sendResponse();
Response.End();
}
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.LoadPTTPPL(group_id);
string result = "";
foreach (DataRow r in dt.Rows)
{
result = result + r["EMPLOYEE_ID"].ToString() + ",";
}
result = result.TrimEnd(',');
DataTable dt_pis = ss.LoadINPIS("", result);
DataTable dtppl = new DataTable();
dtppl.Columns.Add("EMPLOYEE_ID");
dtppl.Columns.Add("NAME");
dtppl.Columns.Add("POSITION");
dtppl.Columns.Add("COMPANY");
dtppl.Columns.Add("MOBILE");
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["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(),
mobile = !string.IsNullOrEmpty(table2["mobile"].ToString()) ? table2["mobile"].ToString() : table1["mobile"].ToString()
};
foreach (var item in results)
{
dtppl.Rows.Add(item.EMPLOYEE_ID, item.FULLNAMETH, item.POSNAME, item.unitname, item.mobile, 200);
}
}
ViewState["CurrentPTTPPL"] = 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;
}
}
private DataTable findPTTPerson(DataTable dtppl, string group_id)
{
OracleQuery cc = new OracleQuery();
SQLServerQuery ss = new SQLServerQuery();
string group = group_id.Substring(0, 1);
// string pisincs = cc.LoadPISinCS(group_id);
// DataTable dt = ss.LoadINPIS("", pisincs);
// dtppl = pushtodtppl(dtppl, dt);
return(dtppl);
}
private void bindFromPIS(string group_id, string pisincs)
{
SQLServerQuery ss = new SQLServerQuery();
DataTable dt = new DataTable();
string schtext = SchPPLBox.Text.TrimEnd();
dt = ss.LoadPIS(schtext, pisincs);
ResultListBox.DataSource = dt;
ResultListBox.DataTextField = "NAME_fk";
ResultListBox.DataValueField = "P_ID";
ResultListBox.DataBind();
}
public void BindPPLDetail()
{
SchPPL.Text = "";
OracleQuery2 cc2 = new OracleQuery2();
SQLServerQuery ss = new SQLServerQuery();
DataTable dt = cc2.LoadPTTPPL();
string result = "";
foreach (DataRow r in dt.Rows)
{
result = result + r["EMPLOYEE_ID"].ToString() + ",";
}
result = result.TrimEnd(',');
DataTable dt_pis = ss.LoadINPIS("", result);
DataTable dtppl = new DataTable();
dtppl.Columns.Add("EMPLOYEE_ID");
dtppl.Columns.Add("NAME");
dtppl.Columns.Add("POSITION");
dtppl.Columns.Add("COMPANY");
dtppl.Columns.Add("UNITCODE");
dtppl.Columns.Add("MOBILE");
dtppl.Columns.Add("LASTUPDATE", typeof(DateTime));
dtppl.Columns.Add("UPDATE_BY");
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["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(),
unitcode = table2["UNITCODE"].ToString(),
lastupdate = table1["LASTUPDATE"],
updateby = table1["UPDATE_BY"].ToString(),
keyword = table1["EMPLOYEE_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.EMPLOYEE_ID, item.FULLNAMETH, item.POSNAME, item.unitname, item.unitcode, item.mobile, item.lastupdate, item.updateby, item.keyword, 200, item.MOBILE_FM, item.STATUS);
}
}
// dtppl = findPTTPerson(dtppl, group_id);
ViewState["CurrentPTTEditPPL"] = 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;
}
}
protected void SchBox_Changed(object sender, EventArgs e)
{
string sch = SchBox.Text;
try
{
// DataTable dt_temp = ViewState["ALLPPL"] as DataTable;
SQLServerQuery ss = new SQLServerQuery();
string result = "";
//foreach (DataRow r in dt_temp.Rows)
//{
// result = result + r["EMPLOYEE_ID"].ToString() + ",";
//}
//result = result.TrimEnd(',');
DataTable dt = ss.LoadPIS(sch, result);
if (dt.Rows.Count > 0)
{
string EmployeeID = 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 MOBILE = dt.Rows[0]["mobile"].ToString();
string UNITCODE = dt.Rows[0]["UNITCODE"].ToString();
SetGroup(EmployeeID, UNITCODE);
EmployeeIDLabel.Text = EmployeeID;
NameLabel.Text = Name;
posnameLabel.Text = posname;
unitnameLabel.Text = unitname;
TelLabel.Text = MOBILE;
resultppl.Visible = true;
SavePPL.Enabled = true;
NoResult.Visible = false;
}
else
{
string EmployeeID = "";
string Name = "";
string posname = "";
string unitname = "";
string MOBILE = "";
EmployeeIDLabel.Text = EmployeeID;
NameLabel.Text = Name;
posnameLabel.Text = posname;
unitnameLabel.Text = unitname;
TelLabel.Text = MOBILE;
SavePPL.Enabled = false;
NoResult.Visible = true;
errorlabel.Text = "ไม่พบข้อมูล";
resultppl.Visible = false;
}
}
catch {
string EmployeeID = "";
string Name = "";
string posname = "";
string unitname = "";
string MOBILE = "";
EmployeeIDLabel.Text = EmployeeID;
NameLabel.Text = Name;
posnameLabel.Text = posname;
unitnameLabel.Text = unitname;
TelLabel.Text = MOBILE;
SavePPL.Enabled = false;
NoResult.Visible = true;
errorlabel.Text = "ไม่พบข้อมูล";
resultppl.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;
}
}
