private void SetddlDept(ref PccCommonForC.PccErrMsg myLabel,ref bs_UserManager mybs)
{
DataTable dt = mybs.DoReturnDataSet("GetDeptAllData","","").Tables["Dept"];
DataRow myRow = dt.NewRow();
myRow["dept_id"] = 0;
myRow["dept_no"] = "aaa";
myRow["dept_nm"] = "bbb";
myRow["dept_desc"] = myLabel.GetErrMsg("SelectPlease") ;
dt.Rows.InsertAt(myRow,0);
// ddldept_id.DataSource = dt.DefaultView;
// ddldept_id.DataTextField = "dept_desc";
// ddldept_id.DataValueField = "dept_id";
// ddldept_id.DataBind();
}
private void BindFactData(ref PccCommonForC.PccErrMsg myLabel,ref PccBsSystemForC.bs_UserManager mybs)
{
DataSet ds;
DataTable dt;
DataRow myRow;
ds = mybs.DoReturnDataSet("GetFactDataBySecurity","","");
dt = ds.Tables["Fact"];
myRow = dt.NewRow();
myRow["fact_id"] = 0;
myRow["fact_nm"] = "bbb";
myRow["fact_desc"] = myLabel.GetErrMsg("SelectPlease") ;
dt.Rows.InsertAt(myRow,0);
ddlfact_id.DataSource = dt.DefaultView;
ddlfact_id.DataTextField = "fact_desc";
ddlfact_id.DataValueField = "fact_id";
ddlfact_id.DataBind();
}
private void SetData(ref PccCommonForC.PccMsg myMsg)
{
PccMsg myMsg1 = new PccMsg();
myMsg1.CreateFirstNode("group_id", myMsg.Query("Key"));
bs_GroupManage mybs = new bs_GroupManage(ConfigurationManager.AppSettings["ConnectionType"], ConfigurationManager.AppSettings["ConnectionServer"], ConfigurationManager.AppSettings["ConnectionDB"], ConfigurationManager.AppSettings["ConnectionUser"], ConfigurationManager.AppSettings["ConnectionPwd"], Session["UserIDAndName"].ToString(), ConfigurationManager.AppSettings["EventLogPath"]);
DataSet dsReturn = mybs.DoReturnDataSet("GetGroupByGroupID", myMsg1.GetXmlStr, "");
if (dsReturn != null)
{
DataTable dt = dsReturn.Tables["Group"];
txtGroupName.Text = dt.Rows[0]["group_nm"].ToString();
ddlGroupType.SelectedIndex = -1;
ddlGroupType.Items.FindByValue(dt.Rows[0]["group_type"].ToString()).Selected = true;
}
else
{
lblMsg.Font.Size = FontUnit.Large;
lblMsg.Text = "載入資料錯誤";
}
}
private void BindFactData(ref PccCommonForC.PccErrMsg myLabel)
{
DataSet ds;
DataTable dt;
DataRow myRow;
bs_UserManager mybs = new bs_UserManager(ConfigurationManager.AppSettings["ConnectionType"], ConfigurationManager.AppSettings["ConnectionServer"], ConfigurationManager.AppSettings["ConnectionDB"], ConfigurationManager.AppSettings["ConnectionUser"], ConfigurationManager.AppSettings["ConnectionPwd"], Session["UserIDAndName"].ToString(), ConfigurationManager.AppSettings["EventLogPath"]);
PccMsg myMsg = new PccMsg();
myMsg.CreateFirstNode("ap_id", Request.QueryString["ApID"]);
ds = mybs.DoReturnDataSet("GetFactsRelUsersByApID", myMsg.GetXmlStr, "");
dt = ds.Tables["FactsRelUsersByAp"];
myRow = dt.NewRow();
myRow["fact_id"] = 0;
myRow["fact_no"] = string.Empty;
myRow["fact_desc"] = myLabel.GetErrMsg("SelectPlease");
dt.Rows.InsertAt(myRow, 0);
ddlFact.DataSource = dt.DefaultView;
ddlFact.DataTextField = "fact_desc";
ddlFact.DataValueField = "fact_no";
ddlFact.DataBind();
}
private void SetddlApplication(ref PccCommonForC.PccErrMsg myLabel, ref PccBsSystemForC.bs_UserManager mybs)
{
PccMsg myMsg = new PccMsg();
myMsg.CreateFirstNode("vpath", ConfigurationManager.AppSettings["vpath"]);
//此為判斷若是這個User是要新增的則user_id輸入0
try
{
if (Request.Params["Type"] != null && Request.Params["Type"].ToString() == "Update")
{
myMsg.CreateFirstNode("user_id", Session["UserID"].ToString());
}
else
{
myMsg.CreateFirstNode("user_id", "0");
}
}
catch
{
myMsg.CreateFirstNode("user_id", "0");
}
DataTable dt = mybs.DoReturnDataSet("GetApplyAp", myMsg.GetXmlStr, "").Tables["ApplyAp"];
DataRow myRow = dt.NewRow();
myRow["ap_id"] = 0;
myRow["ap_name"] = myLabel.GetErrMsg("SelectPlease");
dt.Rows.InsertAt(myRow, 0);
ddlApplcation.DataSource = dt.DefaultView;
ddlApplcation.DataTextField = "ap_name";
ddlApplcation.DataValueField = "ap_id";
ddlApplcation.DataBind();
ddlApplcation.Attributes.Add("onChange", "ApplicationChange()");
}
private void GetUserData(ref PccCommonForC.PccErrMsg myLabel, ref PccBsSystemForC.bs_UserManager mybs)
{
PccCommonForC.PccMsg myMsg = new PccCommonForC.PccMsg();
myMsg.CreateFirstNode("user_id", Session["UserID"].ToString());
myMsg.CreateFirstNode("ap_id", ddlApplcation.SelectedItem.Value);
string strXML = myMsg.GetXmlStr;
try
{
myMsg.LoadXml(mybs.DoReturnStr("GetUserData", strXML, ""));
txtuser_desc.Text = myMsg.Query("user_desc");
txtuser_nm.Text = myMsg.Query("email");
//password always is 'password'
txtusr_pas.Attributes["value"] = myMsg.Query("usr_pas");
txtReusr_pas.Attributes["value"] = myMsg.Query("usr_pas");
//ddldept_id.Items.FindByValue(myMsg.Query("dept_id")).Selected = true;
ddlfact_id.Items.FindByValue(myMsg.Query("fact_id")).Selected = true;
txtemp_no.Text = myMsg.Query("emp_no");
txtext.Text = myMsg.Query("ext");
SetTextColor();
}
catch
{
lblMsg.Text = myLabel.GetErrMsg("msgLoadDataError");
btnApply.Enabled = false;
}
}
