protected void Button1_Click(object sender, System.EventArgs e)
{
if (ViewState["CurrentValue"] == null && tab_fact.Rows.Count == 0) return;
Temporary();
string strFact = "";
bs_FactGroupManage mybs = new bs_FactGroupManage(ConfigurationManager.AppSettings["ConnectionType"], ConfigurationManager.AppSettings["ConnectionServer"], ConfigurationManager.AppSettings["ConnectionDB"], ConfigurationManager.AppSettings["ConnectionUser"], ConfigurationManager.AppSettings["ConnectionPwd"], Session["UserIDAndName"].ToString(), ConfigurationManager.AppSettings["EventLogPath"]);
strFact = Session["FactFgrpTemporary"].ToString();
if (strFact.Length == 0)
{
ClientScript.RegisterClientScriptBlock(this.GetType(),"New", "<script language=javascript>alert('您還未選擇任何廠別唷！');</script>");
GenMasterTable();
return;
}
PccMsg myMsg = new PccMsg();
myMsg.CreateFirstNode("Ap_Id", m_Ap_Id);
myMsg.CreateFirstNode("Fgrp_Id", m_Fgrp_Id);
myMsg.CreateFirstNode("Fact_Str", strFact);
myMsg.CreateFirstNode("Upd_Id", Session["UserID"].ToString());
string strReturn = mybs.DoReturnStr("PickMultiFactToFgrp", myMsg.GetXmlStr, string.Empty);
myMsg.LoadXml(strReturn);
if (myMsg.Query("returnValue") != "0")
{
lblMsg.Font.Size = 12;
lblMsg.Text = myMsg.Query("errmsg");
return;
}
else
{
Session["FactFgrpTemporary"] = string.Empty;
Response.Redirect(FACTGROUPDETAIL + "?ApID=" + m_Ap_Id + "&SrcUp_Id=" + Request.QueryString["SrcUp_Id"] + "&Up_Id=" + Request.QueryString["Up_Id"] + "&QueryCondition=" + Request.QueryString["QueryCondition"]);
}
}
protected void btnDelOK_Click(object sender, System.EventArgs e)
{
plMain.Visible = true;
plDelete.Visible = false;
PccMsg mySrcMsg = new PccMsg(Request.QueryString["Method"]);
PccMsg myMsg = new PccMsg();
bs_ApManager mybs = new bs_ApManager(ConfigurationManager.AppSettings["ConnectionType"], ConfigurationManager.AppSettings["ConnectionServer"], ConfigurationManager.AppSettings["ConnectionDB"], ConfigurationManager.AppSettings["ConnectionUser"], ConfigurationManager.AppSettings["ConnectionPwd"], Session["UserIDAndName"].ToString(), ConfigurationManager.AppSettings["EventLogPath"]);
string strReturn = "";
switch (mySrcMsg.Query("Method"))
{
case "MasterDelFunc":
myMsg.CreateFirstNode("ap_id", mySrcMsg.Query("Key"));
strReturn = mybs.DoReturnStr("DeleteProAp", myMsg.GetXmlStr, "");
break;
case "DetailDelFunc":
myMsg.CreateFirstNode("menu_id", mySrcMsg.Query("Key"));
strReturn = mybs.DoReturnStr("DeleteProMenu", myMsg.GetXmlStr, "");
break;
}
myMsg.LoadXml(strReturn);
if (myMsg.Query("returnValue") == "0")
{
GenMasterTable();
}
else
{
ClientScript.RegisterClientScriptBlock(this.GetType(),"New", "<script language=javascript>alert('" + myMsg.Query("errmsg") + "');</script>");
}
}
protected void btnDelOK_Click(object sender, System.EventArgs e)
{
plMain.Visible = true;
plDelete.Visible = false;
PccMsg myMsg = new PccMsg(CheckQueryString("Method"));
string strGroupID = myMsg.Query("Key");
myMsg.LoadXml();
myMsg.CreateFirstNode("group_id", strGroupID);
myMsg.CreateFirstNode("ap_id", CheckQueryString("ApID"));
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"]);
string strReturn = mybs.DoReturnStr("DeleteGroupByGroupID", myMsg.GetXmlStr, "");
myMsg.LoadXml(strReturn);
if (myMsg.Query("returnValue") == "0")
{
GenMasterTable();
}
else
{
ClientScript.RegisterClientScriptBlock(this.GetType(),"New", "<script language=javascript>alert('" + myMsg.Query("errmsg") + "');</script>");
}
}
protected void btnDelOK1_Click(object sender, System.EventArgs e)
{
string strReturn = "";
PccMsg myMsg = new PccMsg();
myMsg.CreateFirstNode("User_Id", Request.Params["User_ID"]);
myMsg.CreateFirstNode("Ap_Id", CheckQueryString("ApID"));
myMsg.CreateFirstNode("Fgrp_Id", m_Fgrp_Id);
myMsg.CreateFirstNode("Upd_Id", Session["UserID"].ToString());
bs_FactGroupManage mybs = new bs_FactGroupManage(ConfigurationManager.AppSettings["ConnectionType"], ConfigurationManager.AppSettings["ConnectionServer"], ConfigurationManager.AppSettings["ConnectionDB"], ConfigurationManager.AppSettings["ConnectionUser"], ConfigurationManager.AppSettings["ConnectionPwd"], Session["UserIDAndName"].ToString(), ConfigurationManager.AppSettings["EventLogPath"]);
strReturn = mybs.DoReturnStr("deleteUserGrpByFgrpIDAndUserID", myMsg.GetXmlStr, "");
myMsg.LoadXml(strReturn);
if (myMsg.Query("returnValue") == "0")
{
lblMsg.Text = "";
// ting
Response.Redirect(MYURL + "?ApID=" + m_ap_id + "&QueryCondition=" + GetQueryCondition());
}
else
{
lblMsg.Font.Size = 12;
lblMsg.Text = myMsg.Query("errmsg");
}
}
protected void btnOK_Click(object sender, System.EventArgs e)
{
if (CheckForm("JoinGroupID") == "")
{
ClientScript.RegisterClientScriptBlock(this.GetType(),"New", "<script language=javascript>alert('You not yet select group!');</script>");
GenMasterTable();
return;
}
string strReturn = "";
PccMsg myMsg = new PccMsg();
myMsg.CreateFirstNode("user_id", ViewState["UserID"].ToString());
myMsg.CreateFirstNode("ap_id", CheckQueryString("ApID"));
myMsg.CreateFirstNode("group_str", CheckForm("JoinGroupID"));
myMsg.CreateFirstNode("group_org", ViewState["group_org"].ToString());
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"]);
strReturn = mybs.DoReturnStr("JoinGroupByUserID", myMsg.GetXmlStr, "");
myMsg.LoadXml(strReturn);
if (myMsg.Query("returnValue") != "0")
{
lblMsg.Font.Size = FontUnit.Large;
lblMsg.Text = myMsg.Query("errmsg");
GenMasterTable();
}
else
{
Response.Redirect(USERMANAGE + "?ApID=" + CheckQueryString("ApID") + "&QueryCondition=" + CheckQueryString("QueryCondition"));
}
}
protected void Button1_Click(object sender, System.EventArgs e)
{
if (ViewState["CurrentValue"] == null && tab_fact.Rows.Count == 0) return;
Temporary();
string strFactNo = "";
bs_UserFactManage mybs = new bs_UserFactManage(ConfigurationManager.AppSettings["ConnectionType"], ConfigurationManager.AppSettings["ConnectionServer"], ConfigurationManager.AppSettings["ConnectionDB"], ConfigurationManager.AppSettings["ConnectionUser"], ConfigurationManager.AppSettings["ConnectionPwd"], Session["UserIDAndName"].ToString(), ConfigurationManager.AppSettings["EventLogPath"]);
strFactNo = Session["Facttemporary"].ToString();
if (strFactNo.Length == 0)
{
ClientScript.RegisterClientScriptBlock(this.GetType(),"New", "<script language=javascript>alert('您還未選擇任何廠別唷！');</script>");
GenMasterTable();
return;
}
PccMsg myMsg = new PccMsg();
myMsg.CreateFirstNode("ap_id", m_ap_id);
myMsg.CreateFirstNode("no_str", strFactNo);
myMsg.CreateFirstNode("upd_id", Session["UserID"].ToString());
string strReturn = mybs.DoReturnStr("PickMultiFact", myMsg.GetXmlStr, "");
myMsg.LoadXml(strReturn);
if (myMsg.Query("returnValue") != "0")
{
lblMsg.Font.Size = 12;
lblMsg.Text = myMsg.Query("errmsg");
}
else
{
Response.Redirect(USERFACTMANAGE + "?ApID=" + m_ap_id);
}
}
public string CancelImgConditions(string ID, string user_id)
{
PccMsg myMsg = new PccMsg();
myMsg.CreateFirstNode("ID",ID);
myMsg.CreateFirstNode("add_id", user_id);
return myBs.DoReturnStr("PRO_CANCEL_IMGCONDITIONS", myMsg.GetXmlStr, "");
}
public PccMsg CreateQueryMsg(string queryAction, string queryInput, string procedure)
{
PccMsg retMsg = new PccMsg();
retMsg.CreateFirstNode("QueryAction", queryAction);
retMsg.CreateFirstNode("QueryInput", queryInput);
retMsg.CreateFirstNode("Procedure", procedure);
return retMsg;
}
// 摘要描述
// 函數名稱：
// 函數類別：
// 函數功能：
// 函數說明：UI層經常用的函數
// 輸入資料：
// 輸出資料：
// 注意事項：
// 原設計者：Leo.Tang
// 設立日期：開發中
public PccMsg CreateQueryMsg(string QueryAction, string QueryReturns, string QuerySource, string QueryCondition)
{
PccMsg retMsg = new PccMsg();
retMsg.CreateFirstNode("QueryAction", QueryAction);
retMsg.CreateFirstNode("QueryReturns", QueryReturns);
retMsg.CreateFirstNode("QuerySource", QuerySource);
retMsg.CreateFirstNode("QueryCondition", QueryCondition);
return retMsg;
}
public string DeleteQCFactDept(string user_id, string fact_no, string dept_no, string sec_no)
{
PccMsg myMsg = new PccMsg();
myMsg.CreateFirstNode("user_id", user_id);
myMsg.CreateFirstNode("fact_no", fact_no);
myMsg.CreateFirstNode("dept_no", dept_no);
myMsg.CreateFirstNode("sec_no", sec_no);
return myBs.DoReturnStr("PRO_DELETE_QCFACTDEPT", myMsg.GetXmlStr, "");
}
public static DataSet GetStatistics(string fact_no, string start_date, string end_date)
{
bs_Statistics mybs = new bs_Statistics(ConfigurationSettings.AppSettings["AppConnectionType"], ConfigurationSettings.AppSettings["AppConnectionServer"], ConfigurationSettings.AppSettings["AppConnectionDB"], ConfigurationSettings.AppSettings["AppConnectionUser"], ConfigurationSettings.AppSettings["AppConnectionPwd"]);
PccMsg myMsg = new PccMsg();
myMsg.CreateFirstNode("fact_no", fact_no);
myMsg.CreateFirstNode("start_date", start_date);
myMsg.CreateFirstNode("end_date", end_date);
return mybs.DoReturnDataSet("GETSTATISTICS", myMsg.GetXmlStr, "");
}
private string GenDBXML()
{
PccMsg myMsg = new PccMsg();
if (Request.Params["Type"] == null || Request.Params["Type"].ToString() != "New")
{
myMsg.CreateFirstNode("ap_id", GetApID());
}
myMsg.CreateFirstNode("ap_name", txtApName.Text);
myMsg.CreateFirstNode("ap_link", txtApLink.Text);
myMsg.CreateFirstNode("ap_vpath", txtVpath.Text);
return myMsg.GetXmlStr;
}
public static string GetFactByUser(string user_id)
{
PccMsg myMsg = new PccMsg();
myMsg.CreateFirstNode("UserID", user_id);
bs_UserInfo bs = new bs_UserInfo(ConfigurationSettings.AppSettings["AppConnectionType"], ConfigurationSettings.AppSettings["AppConnectionServer"], ConfigurationSettings.AppSettings["AppConnectionDB"], ConfigurationSettings.AppSettings["AppConnectionUser"], ConfigurationSettings.AppSettings["AppConnectionPwd"]);
return bs.DoReturnStr("GETFACTNOBYUSERID", myMsg.GetXmlStr, "").Trim();
}
public static DataSet GetFact(string fact_no)
{
bs_Statistics mybs = new bs_Statistics(ConfigurationSettings.AppSettings["AppConnectionType"], ConfigurationSettings.AppSettings["AppConnectionServer"], ConfigurationSettings.AppSettings["AppConnectionDB"], ConfigurationSettings.AppSettings["AppConnectionUser"], ConfigurationSettings.AppSettings["AppConnectionPwd"]);
PccMsg myMsg = new PccMsg();
myMsg.CreateFirstNode("fact_no", fact_no);
return mybs.DoReturnDataSet("GETFACT", myMsg.GetXmlStr, "");
}
//,string dept_no
public static DataSet GetDept(string fact_no)
{
bs_UserInfo mybs = new bs_UserInfo(ConfigurationSettings.AppSettings["AppConnectionType"], ConfigurationSettings.AppSettings["AppConnectionServer"], ConfigurationSettings.AppSettings["AppConnectionDB"], ConfigurationSettings.AppSettings["AppConnectionUser"], ConfigurationSettings.AppSettings["AppConnectionPwd"]);
PccMsg myMsg = new PccMsg();
myMsg.CreateFirstNode("fact_no", fact_no);
// myMsg.CreateFirstNode("dept_no", dept_no);
return mybs.DoReturnDataSet("GETDEPTBYFACT", myMsg.GetXmlStr, "");
}
public static string GetFactNoByUserID(string UserID)
{
bs_UserInfo mybs = new bs_UserInfo(ConfigurationSettings.AppSettings["AppConnectionType"], ConfigurationSettings.AppSettings["AppConnectionServer"], ConfigurationSettings.AppSettings["AppConnectionDB"], ConfigurationSettings.AppSettings["AppConnectionUser"], ConfigurationSettings.AppSettings["AppConnectionPwd"]);
PccMsg myMsg = new PccMsg();
myMsg.CreateFirstNode("UserID", UserID);
string sReturn = mybs.DoReturnStr("GetFactNoByUserID", myMsg.GetXmlStr, "");
return sReturn.Trim();
}
protected void btnAddComeOn_Click(object sender, System.EventArgs e)
{
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"]);
PccMsg myMsg = new PccMsg();
string strUserID = "", strReturn = "";
for (int i = 0; i < DataGrid1.Items.Count; i++)
{
if (((CheckBox)DataGrid1.Items[i].Cells[6].Controls[1]).Checked)
{
strUserID += DataGrid1.Items[i].Cells[1].Text + ",";
}
}
if (strUserID != "")
{
strUserID = strUserID.Substring(0, strUserID.Length - 1);
myMsg.LoadXml();
myMsg.CreateFirstNode("group_id", CheckQueryString("GroupID"));
myMsg.CreateFirstNode("user_str", strUserID);
strReturn = mybs.DoReturnStr("InsertUGrp", myMsg.GetXmlStr, "");
myMsg.LoadXml(strReturn);
if (myMsg.Query("returnValue") == "0")
{
Response.Redirect(GROUPMANAGE + "?ApID=" + CheckQueryString("ApID") + "&QueryCondition=" + CheckQueryString("QueryCondition"));
}
else
{
lblMsg.Font.Size = FontUnit.Large;
lblMsg.Text = myMsg.Query("errmsg");
}
}
else
{
PccErrMsg myLabel = new PccErrMsg(Server.MapPath(Session["PageLayer"] + "XmlDoc"), Session["CodePage"].ToString(), "Label");
lblMsg.Font.Size = FontUnit.Large;
lblMsg.Text = myLabel.GetErrMsg("lbl0014", "SysManager/UserManager");
}
}
//Nickel 20130320
public string db_DEL_SHR_AREA(string strXML)
{
PccMsg myMsg = new PccMsg(strXML);
string myStrConFactNo = myMsg.Query("area_id");
SqlParameter[] paraValue= {
new SqlParameter("@area_id", SqlDbType.Decimal,12),
new SqlParameter("@ErrMsg",SqlDbType.Int)
};
int rowsAffected = 0,returnValue;
paraValue[0].Value = myMsg.Query("area_id");
paraValue[1].Direction = ParameterDirection.Output;
returnValue = RunProcedure("pro_Del_shr_area", paraValue, ref rowsAffected);
myMsg = new PccMsg();
myMsg.CreateFirstNode("returnValue",returnValue.ToString());
myMsg.CreateFirstNode("rowsAffected",rowsAffected.ToString());
myMsg.CreateFirstNode("MsgReturn",paraValue[1].Value.ToString());
return myMsg.GetXmlStr;
}
protected void btnDelOK_Click(object sender, System.EventArgs e)
{
plMain.Visible = true;
plDelete.Visible = false;
PccMsg myMsg = new PccMsg(CheckRequestQueryString("Method"));
PccMsg myReturnMsg = new PccMsg();
string strUserID = myMsg.Query("Key");
myMsg.LoadXml();
myMsg.CreateFirstNode("user_id", strUserID);
myMsg.CreateFirstNode("ap_id", CheckRequestQueryString("ApID"));
//增加一個刪除e_userfact的關連 20040924
myMsg.CreateFirstNode("upd_id", Session["UserID"].ToString());
myMsg.CreateFirstNode("fact_id", "0");
myMsg.CreateFirstNode("uf_id", "0");
bs_UserFactManage mybs1 = new bs_UserFactManage(ConfigurationManager.AppSettings["ConnectionType"], ConfigurationManager.AppSettings["ConnectionServer"], ConfigurationManager.AppSettings["ConnectionDB"], ConfigurationManager.AppSettings["ConnectionUser"], ConfigurationManager.AppSettings["ConnectionPwd"], Session["UserIDAndName"].ToString(), ConfigurationManager.AppSettings["EventLogPath"]);
string strReturn = mybs1.DoReturnStr("DeleteUserFactByUser", myMsg.GetXmlStr, "");
myReturnMsg.LoadXml(strReturn);
if (myReturnMsg.Query("returnValue") != "0")
{
ClientScript.RegisterClientScriptBlock(this.GetType(),"New", "<script language=javascript>alert('" + myMsg.Query("errmsg") + "');</script>");
return;
}
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"]);
strReturn = mybs.DoReturnStr("DeleteUserByApID", myMsg.GetXmlStr, "");
myReturnMsg.LoadXml(strReturn);
if (myReturnMsg.Query("returnValue") == "0")
{
GenMasterTable();
}
else
{
ClientScript.RegisterClientScriptBlock(this.GetType(),"New", "<script language=javascript>alert('" + myMsg.Query("errmsg") + "');</script>");
}
}
public string SaveApplyCheckDataQC(string ac_id, string fact_no, string dept_no, string sec_no, string type_check, string vou_no, string total, string floor, string build_no, string myType)
{
bs_ApplyData myBs = new bs_ApplyData(ConfigurationSettings.AppSettings["AppConnectionType"], ConfigurationSettings.AppSettings["AppConnectionServer"], ConfigurationSettings.AppSettings["AppConnectionDB"], ConfigurationSettings.AppSettings["AppConnectionUser"], ConfigurationSettings.AppSettings["AppConnectionPwd"], "", ConfigurationSettings.AppSettings["EventLogPath"]);
PccMsg myMsg = new PccMsg();
myMsg.CreateFirstNode("ac_id", ac_id);
myMsg.CreateFirstNode("fact_no", fact_no);
myMsg.CreateFirstNode("dept_no", dept_no);
myMsg.CreateFirstNode("sec_no", sec_no);
myMsg.CreateFirstNode("type_check", type_check);
myMsg.CreateFirstNode("vou_no", vou_no);
myMsg.CreateFirstNode("total", total);
myMsg.CreateFirstNode("floor", floor);
myMsg.CreateFirstNode("build_no", build_no);
myMsg.CreateFirstNode("Type", myType);
string strXML = myMsg.GetXmlStr;
string strReturn = myBs.DoReturnStr("INSUPDAPPLYCHECKQ", strXML, "");
myMsg.LoadXml(strReturn);
return strReturn;
//return myMsg.Query("Err");
}
public static void _Get_ControlDeptByfact(DropDownList ddl, string fact_no)
{
bs_UserInfo mybs = new bs_UserInfo(ConfigurationSettings.AppSettings["AppConnectionType"], ConfigurationSettings.AppSettings["AppConnectionServer"], ConfigurationSettings.AppSettings["AppConnectionDB"], ConfigurationSettings.AppSettings["AppConnectionUser"], ConfigurationSettings.AppSettings["AppConnectionPwd"]);
PccMsg myMsg = new PccMsg();
myMsg.CreateFirstNode("fact_no", fact_no);
DataSet dsReturn = mybs.DoReturnDataSet("GETDEPTBYFACT", myMsg.GetXmlStr, "");
DataTable dt = dsReturn.Tables[0];
ddl.SelectedIndex = -1;
ddl.DataSource = dt;
ddl.DataTextField = "dept_no";
ddl.DataValueField = "dept_no";
ddl.DataBind();
// ddl.Items.Insert(0, new ListItem("--All--", ""));
}
protected void btnOK_Click(object sender, System.EventArgs e)
{
if (txtGroupName.Text == "")
{
PccErrMsg myLabel = new PccErrMsg(Server.MapPath(Session["PageLayer"] + "XmlDoc"), Session["CodePage"].ToString(), "Label");
lblMsg.Text = myLabel.GetErrMsg("lbl0010", "ADTPurDoc/GroupManage");
return;
}
//先判斷是Insert or Update
bool bUpdate = false;
string group_id = "";
PccMsg myMsg = new PccMsg();
if (Request.Params["Method"] != null)
{
bUpdate = true;
myMsg.LoadXml(Request.Params["Method"].ToString());
group_id = myMsg.Query("Key");
}
myMsg.ClearContext();
myMsg.CreateFirstNode("group_id", group_id);
myMsg.CreateFirstNode("ap_id", CheckQueryString("ApID"));
myMsg.CreateFirstNode("group_nm", txtGroupName.Text);
myMsg.CreateFirstNode("group_type", ddlGroupType.SelectedItem.Value);
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"]);
string strReturn = "";
if (bUpdate)
{
myMsg.CreateFirstNode("upd_id", Session["UserID"].ToString());
strReturn = mybs.DoReturnStr("UpdateGroupByGroupID", myMsg.GetXmlStr, "");
}
else
{
myMsg.CreateFirstNode("add_id", Session["UserID"].ToString());
strReturn = mybs.DoReturnStr("InsertGroupByApID", myMsg.GetXmlStr, "");
}
myMsg.LoadXml(strReturn);
if (myMsg.Query("returnValue") == "0")
{
Response.Redirect(GROUPMANAGE + "?ApID=" + CheckQueryString("ApID"));
}
else
{
lblMsg.Font.Size = FontUnit.Large;
lblMsg.Text = myMsg.Query("errmsg");
}
}
//web.huuminh 20140416
// lây dept dua vào uer_id
public static void _Get_ControlDept(DropDownList ddl, string UserID,string Type)
{
bs_UserInfo mybs = new bs_UserInfo(ConfigurationSettings.AppSettings["AppConnectionType"], ConfigurationSettings.AppSettings["AppConnectionServer"], ConfigurationSettings.AppSettings["AppConnectionDB"], ConfigurationSettings.AppSettings["AppConnectionUser"], ConfigurationSettings.AppSettings["AppConnectionPwd"]);
PccMsg myMsg = new PccMsg();
myMsg.CreateFirstNode("UserID", UserID);
DataSet dsReturn = mybs.DoReturnDataSet("GETDEPTBYUSERID", myMsg.GetXmlStr, "");
DataTable dt = dsReturn.Tables[0];
ddl.SelectedIndex = -1;
ddl.DataSource = dt;
if (Type == "1")
{
ddl.DataTextField = "dept_name";
ddl.DataValueField = "dept_no";
}
ddl.DataBind();
//if (dt.Rows.Count > 1 || dt.Rows.Count == 0)
// ddl.Items.Insert(0, new ListItem("--All--", ""));
}
public void GetImageFile(string IdImage)
{
//if (Session["IdImage"].ToString() != null)
//{
bs_UserInfo bs_Route = new bs_UserInfo(ConfigurationSettings.AppSettings["AppConnectionType"], ConfigurationSettings.AppSettings["AppConnectionServer"], ConfigurationSettings.AppSettings["AppConnectionDB"], ConfigurationSettings.AppSettings["AppConnectionUser"], ConfigurationSettings.AppSettings["AppConnectionPwd"], "", ConfigurationSettings.AppSettings["EventLogPath"]);
PccMsg myMsg = new PccMsg();
myMsg.CreateFirstNode("user_id", IdImage.ToString().Trim());
string strXML = myMsg.GetXmlStr;
DataTable ImageTable = bs_Route.DoReturnDataSet("GETUSERNAMESIGN", strXML, "").Tables[0];
//return dt;
byte[] byteReturn = { };
if (ImageTable.Rows.Count > 0)
{
byteReturn = (byte[])ImageTable.Rows[0]["sign_pic"];
Response.BinaryWrite(byteReturn);
}
// }
}
protected void Button1_Click(object sender, System.EventArgs e)
{
if (ViewState["CurrentValue"] == null && tab_user.Rows.Count == 0) return;
Temporary();
string strUser = "";
bs_UserFactManage mybs = new bs_UserFactManage(ConfigurationManager.AppSettings["ConnectionType"], ConfigurationManager.AppSettings["ConnectionServer"], ConfigurationManager.AppSettings["ConnectionDB"], ConfigurationManager.AppSettings["ConnectionUser"], ConfigurationManager.AppSettings["ConnectionPwd"], Session["UserIDAndName"].ToString(), ConfigurationManager.AppSettings["EventLogPath"]);
strUser = Session["Usertemporary"].ToString();
if (strUser.Length == 0)
{
ClientScript.RegisterClientScriptBlock(this.GetType(),"New", "<script language=javascript>alert('您還未選擇任何使用者唷！');</script>");
GenMasterTable();
return;
}
PccMsg myMsg = new PccMsg();
myMsg.CreateFirstNode("ap_id", m_ap_id);
myMsg.CreateFirstNode("fact_id", m_fact_id);
myMsg.CreateFirstNode("user_str", strUser);
if (ConfigurationManager.AppSettings[m_ap_id + "-FactByGroup"] != null)
//myMsg.CreateFirstNode("FactByGroup",ConfigurationManager.AppSettings[m_ap_id + "-FactByGroup"].ToString());
// ting
myMsg.CreateFirstNode("FactByGroup", ConfigurationManager.AppSettings[m_ap_id + "-FactByGroup"].ToString() + "&QueryCondition=" + Request.QueryString["QueryCondition"]);
else
myMsg.CreateFirstNode("FactByGroup", "N");
myMsg.CreateFirstNode("upd_id", Session["UserID"].ToString());
string strReturn = mybs.DoReturnStr("PickMultiUserFact", myMsg.GetXmlStr, "");
myMsg.LoadXml(strReturn);
if (myMsg.Query("returnValue") != "0")
{
lblMsg.Font.Size = 12;
lblMsg.Text = myMsg.Query("errmsg");
return;
}
else
{
//Response.Redirect(PICKUSER + "?ApID=" + m_ap_id);
// ting
Response.Redirect(PICKUSER + "?ApID=" + m_ap_id + "&QueryCondition=" + Request.QueryString["QueryCondition"]);
}
}
private void BindDdlData(ref PccErrMsg myLabel)
{
bs_ApManager mybs = new bs_ApManager(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("vpath", System.Configuration.ConfigurationManager.AppSettings["vpath"].ToString());
DataTable dt = mybs.DoReturnDataSet("GetAllApByVpath", myMsg.GetXmlStr, "").Tables["AllApByVpath"];
DataRow myRow = dt.NewRow();
myRow["ap_id"] = 0;
myRow["ap_name"] = myLabel.GetErrMsg("SelectPlease");
myRow["ap_link"] = "bbb";
myRow["ap_vpath"] = "All";
dt.Rows.InsertAt(myRow, 0);
ddlApName.DataSource = dt.DefaultView;
ddlApName.DataValueField = "ap_id";
ddlApName.DataTextField = "ap_name";
ddlApName.DataBind();
}
private void GenUpdateData()
{
bs_ApManager mybs = new bs_ApManager(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("menu_id", GetMenuID());
string strReturn = mybs.DoReturnStr("GetMenuByMenuID", myMsg.GetXmlStr, "");
myMsg.LoadXml(strReturn);
if (myMsg.Query("Return") == "OK")
{
txtMenuNo.Text = myMsg.Query("menu_no");
txtMenuName.Text = myMsg.Query("menu_nm");
txtMenuLink.Text = myMsg.Query("menu_link");
ddlApName.Items.FindByValue(myMsg.Query("ap_id")).Selected = true;
if (myMsg.Query("check_mk") == "Y") chkCheckMK.Checked = true; else chkCheckMK.Checked = false;
txtManageMK.Text = myMsg.Query("manage_mk");
}
else
{
btnOK.Visible = false;
lblMsg.Font.Size = FontUnit.Large;
lblMsg.Text = myMsg.Query("Return");
}
}
private string GenDBXML()
{
PccMsg myMsg = new PccMsg();
if (Request.Params["Type"] == null || Request.Params["Type"].ToString() != "New")
{
myMsg.CreateFirstNode("menu_id", GetMenuID());
}
myMsg.CreateFirstNode("ap_id", ddlApName.SelectedItem.Value);
myMsg.CreateFirstNode("menu_no", txtMenuNo.Text);
myMsg.CreateFirstNode("menu_nm", txtMenuName.Text);
myMsg.CreateFirstNode("menu_link", txtMenuLink.Text);
if (chkCheckMK.Checked) myMsg.CreateFirstNode("check_mk", "Y"); else myMsg.CreateFirstNode("check_mk", "N");
myMsg.CreateFirstNode("manage_mk", txtManageMK.Text.ToString().ToUpper());
return myMsg.GetXmlStr;
}
protected void btnAddComeOn_Click(object sender, System.EventArgs e)
{
bs_UserManager mybs = new bs_UserManager(ConfigurationSettings.AppSettings["ConnectionType"] , ConfigurationSettings.AppSettings["ConnectionServer"], ConfigurationSettings.AppSettings["ConnectionDB"], ConfigurationSettings.AppSettings["ConnectionUser"], ConfigurationSettings.AppSettings["ConnectionPwd"],Session["UserIDAndName"].ToString(),ConfigurationSettings.AppSettings["EventLogPath"]);
PccMsg myMsg = new PccMsg();
string strUserID,strReturn,errormsg = "",strXML = "";
bool bSelect = false;
for (int i = 0; i < DataGrid1.Items.Count ; i++)
{
if (((CheckBox)DataGrid1.Items[i].Cells[6].Controls[1]).Checked)
{
strUserID = DataGrid1.Items[i].Cells[1].Text;
myMsg.LoadXml();
myMsg.CreateFirstNode("ap_id",Request.QueryString["ApID"]);
myMsg.CreateFirstNode("user_id",strUserID);
myMsg.CreateFirstNode("mana_mk","N");
myMsg.CreateFirstNode("upd_id",Session["UserID"].ToString());
//strXML = GetUserXML(strUserID);
strReturn = mybs.DoReturnStr("JoinUserToAp",myMsg.GetXmlStr,"");
myMsg.LoadXml(strReturn);
if (myMsg.Query("returnValue") != "0")
{
lblMsg.Font.Size = FontUnit.Large;
lblMsg.Text = myMsg.Query("errmsg");
break;
}
bSelect = true;
}
}
if (bSelect)
{
if (myMsg.Query("returnValue") == "0")
{
Response.Redirect(USERMANAGE + "?ApID=" + Request.QueryString["ApID"] + "&QueryCondition=" + Request.QueryString["QueryCondition"]);
}
else
{
lblMsg.Font.Size = FontUnit.Large;
if (errormsg == "")
lblMsg.Text = myMsg.Query("errmsg");
else
lblMsg.Text = errormsg;
}
}
else
{
PccErrMsg myLabel = new PccErrMsg(Server.MapPath(Session["PageLayer"] + "XmlDoc"),Session["CodePage"].ToString() ,"Label");
lblMsg.Font.Size = FontUnit.Large;
if (errormsg == "")
lblMsg.Text = myLabel.GetErrMsg("lbl0014","SysManager/UserManager");
else
lblMsg.Text = errormsg;
}
}
private string GetUserXML(string user_id)
{
PccBsSystemForC.bs_UserManager mybs = new PccBsSystemForC.bs_UserManager(ConfigurationSettings.AppSettings["ConnectionType"] , ConfigurationSettings.AppSettings["ConnectionServer"], ConfigurationSettings.AppSettings["ConnectionDB"], ConfigurationSettings.AppSettings["ConnectionUser"], ConfigurationSettings.AppSettings["ConnectionPwd"],Session["UserIDAndName"].ToString(),ConfigurationSettings.AppSettings["EventLogPath"]);
PccCommonForC.PccMsg myMsg = new PccCommonForC.PccMsg();
myMsg.CreateFirstNode("user_id",user_id);
PccMsg myReturnMsg = new PccMsg();
myReturnMsg.LoadXml(mybs.DoReturnStr("GetUserData",myMsg.GetXmlStr,""));
//10/6還要繼續做XML的方法 20041006
string fact_id = myReturnMsg.Query("fact_id");
myReturnMsg.CreateFirstNode("fact_no", GetFactNoByFactID(fact_id));
return myReturnMsg.GetXmlStr;
}
