protected void BtnAddNewOK_ServerClick(object sender, System.EventArgs e)
{
PccMsg myMsg = new PccMsg();
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"]);
string strReturn = string.Empty;
string strMsg = string.Empty;
if (ViewState["ActionType"] != null && ViewState["ActionType"].ToString() == "New")
{
strReturn = mybs.DoReturnStr("Insert_DS_FGRP", GenDBXML(), string.Empty);
strMsg = "新增成功";
}
else
{
strReturn = mybs.DoReturnStr("Update_DS_FGRP", GenDBXML(), string.Empty);
strMsg = "修改成功";
}
myMsg.LoadXml(strReturn);
string strUrl = FACTGROUPMAANGE + "?ApID=" + m_ApID + "&SelectedNode=" + TreeView1.SelectedValue;
//string strUrl = FACTGROUPMAANGE + "?ApID=" + m_ApID + "&SelectedNode=" + TreeView1.SelectedNodeIndex;
if (myMsg.Query("returnValue") == "0")
{
ClientScript.RegisterClientScriptBlock(this.GetType(),"New", "<script language=javascript>alert('" + strMsg + "');window.parent.location.href='" + strUrl + "';</script>");
}
else
{
LblErrMsg.Font.Size = FontUnit.Large;
LblErrMsg.Text = myMsg.Query("errmsg");
}
}
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 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 BtnOK_Click(object sender, System.EventArgs e)
{
if (CheckForm("JoinFgrpID") == "")
{
ClientScript.RegisterClientScriptBlock(this.GetType(),"New", "<script language=javascript>alert('You not yet select Fact group!');</script>");
GenMasterTable();
return;
}
string strReturn = "";
PccMsg myMsg = new PccMsg();
myMsg.CreateFirstNode("User_Id", Request.Params["UserID"]);
myMsg.CreateFirstNode("Ap_Id", CheckQueryString("ApID"));
myMsg.CreateFirstNode("Fgrp_Str", CheckForm("JoinFgrpID"));
myMsg.CreateFirstNode("Fgrp_Org", ViewState["Fgrp_Org"].ToString());
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("joinFgrpByUserID", myMsg.GetXmlStr, "");
myMsg.LoadXml(strReturn);
if (myMsg.Query("returnValue") != "0")
{
lblMsg.Visible = true;
lblMsg.Font.Size = FontUnit.Large;
lblMsg.Text = myMsg.Query("errmsg");
GenMasterTable();
}
else
{
Response.Redirect(USERFGRPVIEW + "?ApID=" + m_ApID + "&QueryCondition=" + CheckQueryString("QueryCondition"));
}
}
protected void BtnDelFactOK_Click(object sender, System.EventArgs e)
{
PccMsg myMsg = new PccMsg();
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"]);
string strReturn = string.Empty;
string strMsg = string.Empty;
strReturn = mybs.DoReturnStr("delete_DS_FACTGRP", GenDBXML(), string.Empty);
strMsg = "刪除成功";
myMsg.LoadXml(strReturn);
if (myMsg.Query("returnValue") == "0")
{
ClientScript.RegisterClientScriptBlock(this.GetType(),"New", "<script language=javascript>alert('" + strMsg + "');</script>");
Response.Redirect(MYURL + "?ApID=" + m_ApID + "&SrcUp_Id=" + m_SrcUp_Id + "&Up_Id=" + m_Up_Id + "&QueryCondition=" + GetQueryCondition());
}
else
{
LblErrMsg.Font.Size = FontUnit.Large;
LblErrMsg.Text = myMsg.Query("errmsg");
}
}