protected void btCopy_Click(object sender, EventArgs e)
{
BTC btc = new BTC();
if (btc.CkDataDuplicate(ddlSearchYear.SelectedValue, "CostsCenter"))
{
btc.Msg_Head(Img1, MsgHead, true, "7", 0);
return;
}
Connection Conn = new Connection();
string strSql = " Select CostsCode, StudyYear, CostsName, CostsDetail, Sort From CostsCenter Where DelFlag = 0 And StudyYear = '" + ddlOldYear.SelectedValue + "' Order By Sort ";
DataView dvCostsCenter = Conn.Select(strSql);
if (dvCostsCenter.Count != 0)
{
for (int i = 0; i < dvCostsCenter.Count; i++)
{
string NewID = Guid.NewGuid().ToString();
Int32 x = Conn.AddNew("CostsCenter", "CostsCode, StudyYear, CostsName, CostsDetail, Sort, DelFlag, CreateUser, CreateDate, UpdateUser, UpdateDate", NewID, ddlSearchYear.SelectedValue, dvCostsCenter[i]["CostsName"].ToString(), dvCostsCenter[i]["CostsDetail"].ToString(), dvCostsCenter[i]["Sort"].ToString(), 0, CurrentUser.ID, DateTime.Now, CurrentUser.ID, DateTime.Now);
}
btc.Msg_Head(Img1, MsgHead, true, "1", 1);
btc.CopyEnable(lblCopy, ddlOldYear, btCopy, "CostsCenter", ddlSearchYear.SelectedValue);
DataBind();
}
else
{
btc.Msg_Head(Img1, MsgHead, true, "6", 0);
}
}
protected void Page_Load(object sender, EventArgs e)
{
BTC btc = new BTC();
if (!IsPostBack)
{
getddlYear();
getddlStrategies(ddlSearchYear.SelectedValue);
getddlProjects(ddlSearchYear.SelectedValue, ddlSearch2.SelectedValue);
ClearAll();
string mode = Request.QueryString["mode"];
Int32 ckrec = Convert.ToInt32(Request.QueryString["ckrec"]);
if (!String.IsNullOrEmpty(mode))
{
switch (mode.ToLower())
{
case "1":
btc.Msg_Head(Img1, MsgHead, true, mode, ckrec);
break;
case "2":
btc.Msg_Head(Img1, MsgHead, true, mode, ckrec);
break;
case "3":
//btc.txtEnable(table1, TableSearch, GridView1, false);
Delete(Request["id"]);
break;
}
}
DataBind();
}
}
private void bt_Save(string CkAgain)
{
Connection Conn = new Connection();
BTC btc = new BTC();
if (String.IsNullOrEmpty(Request["mode"]) || Request["mode"] == "1")
{
string NewID = Guid.NewGuid().ToString();
Int32 i = Conn.AddNew("CostsCenter", "CostsCode, StudyYear, CostsName, CostsDetail, Sort, DelFlag, CreateUser, CreateDate, UpdateUser, UpdateDate", NewID, ddlYearB.SelectedValue, txtCostsName.Text, txtCostsDetail.Text, txtSort.Text, 0, CurrentUser.ID, DateTime.Now, CurrentUser.ID, DateTime.Now);
if (CkAgain == "N")
{
btc.Msg_Head(Img1, MsgHead, true, "1", i);
btc.txtEnable(table1, TableSearch, GridView1, false);
}
if (CkAgain == "Y")
{
btc.Msg_Head(Img1, MsgHead, true, "1", i);
btc.GenSort(txtSort, "CostsCenter", " And StudyYear = '" + ddlYearB.SelectedValue + "' ");
GridView2.Visible = true;
}
}
if (Request["mode"] == "2")
{
Int32 i = Conn.Update("CostsCenter", "Where CostsCode = '" + Request["id"] + "' ", "StudyYear, CostsName, CostsDetail, Sort, UpdateUser, UpdateDate", ddlYearB.SelectedValue, txtCostsName.Text, txtCostsDetail.Text, txtSort.Text, CurrentUser.ID, DateTime.Now);
btc.Msg_Head(Img1, MsgHead, true, "2", i);
btc.txtEnable(table1, TableSearch, GridView1, false);
}
ClearAll();
DataBind();
}
protected void btnDelete_Click(object sender, EventArgs e)
{
if (GridView1.SelectedItems.Length == 0)
{
return;
}
string query = "DELETE MenuRole WHERE MySubMenuID IN('";
query += String.Join("', '", GridView1.SelectedItems);
query += "')";
Connection Conn = new Connection();
BTC btc = new BTC();
try
{
Conn.Execute(query);
//Response.Redirect(Request.RawUrl);
btc.Msg_Head(Img1, MsgHead, true, "3", 1);
DataBind();
}
catch (Exception ex)
{
btc.Msg_Head(Img1, MsgHead, true, "3", 0);
DataBind();
//lblMessage.Text = "<img src=\"../Shared/images/no.png\" alt=\"à¡Ô´¢éͼԴ¾ÅÒ´\" />à¡Ô´¢éͼԴ¾ÅÒ´ÃÐËÇèÒ§´Óà¹Ô¹¡Òà " + ex.Message;
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
MultiView1.ActiveViewIndex = 0;
if (!string.IsNullOrEmpty(Request["Cr"]))
{
btc.Msg_Head(Img1, MsgHead, true, Request["ckmode"], Convert.ToInt32(Request["Cr"]));
}
//àªç¤»Õ§º»ÃÐÁÒ³
btc.ckBudgetYear(lblSearchYear, lblYear);
//btc.LinkReport(linkReport);
getddlYear(0);
getddlSufficeSide(0, ddlSearchYear.SelectedValue);
getddlSufficeStandard(0, ddlSearchStandard.SelectedValue);
btc.CkAdmission(GridView1, btAdd, null);
string mode = Request["mode"];
if (!string.IsNullOrEmpty(mode))
{
switch (mode.ToLower())
{
case "1":
MultiView1.ActiveViewIndex = 1;
ClearAll();
getddlYear(1);
getddlSufficeSide(1, ddlYearB.SelectedValue);
getddlSufficeStandard(1, ddlSufficeStandard.SelectedValue);
btc.GenSort(txtSort, "SufficeIndicator", " And SufficeStandardID = '" + ddlSufficeStandard.SelectedValue + "' ");
Page.ClientScript.RegisterStartupScript(Page.GetType(), Guid.NewGuid().ToString(), "Cktxt(0);", true);
break;
case "2":
MultiView1.ActiveViewIndex = 1;
ClearAll();
getddlYear(1);
btc.btEnable(btSaveAgain, false);
GetData(Request["id"]);
break;
case "3":
MultiView1.ActiveViewIndex = 0;
Delete(Request["id"]);
break;
}
}
else
{
DataBind();
}
}
txtSufficeIndicator.Attributes.Add("onkeyup", "Cktxt(0);");
ddlSufficeSide.Attributes.Add("onchange", "Cktxt(0);");
ddlSufficeStandard.Attributes.Add("onchange", "Cktxt(0);");
txtSort.Attributes.Add("onkeyup", "Cktxt(0);");
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
MultiView1.ActiveViewIndex = 0;
if (!string.IsNullOrEmpty(Request["Cr"]))
{
btc.Msg_Head(Img1, MsgHead, true, Request["ckmode"], Convert.ToInt32(Request["Cr"]));
}
//àªç¤»Õ§º»ÃÐÁÒ³
btc.ckBudgetYear(lblSearchYear, lblYear);
string mode = Request.QueryString["mode"];
if (!string.IsNullOrEmpty(mode))
{
switch (mode.ToLower())
{
case "1":
MultiView1.ActiveViewIndex = 1;
getddlYear(1);
btc.getddlMainDepartment(1, ddlMainDept, null);
btc.getddlMainSubDepartment(1, ddlMainSubDept, ddlMainDept.SelectedValue, null);
btc.getddlDepartment(1, ddlDepartment, ddlMainSubDept.SelectedValue, null, null);
btc.GenSort(txtSort, "StrategicPlan", " And StudyYear = '" + ddlYearB.SelectedValue + "' And DeptCode = '" + ddlDepartment.SelectedValue + "' ");
Page.ClientScript.RegisterStartupScript(Page.GetType(), Guid.NewGuid().ToString(), "Cktxt(0);", true);
break;
case "2":
MultiView1.ActiveViewIndex = 1;
getddlYear(1);
btc.btEnable(btSaveAgain, false);
GetData(Request.QueryString["id"]);
break;
case "3":
MultiView1.ActiveViewIndex = 0;
Delete(Request.QueryString["id"]);
btc.CopyEnable(lblCopy, ddlOldYear, btCopy, "StrategicPlan", ddlSearchYear.SelectedValue);
break;
}
}
else
{
getddlYear(0);
btc.CopyEnable(lblCopy, ddlOldYear, btCopy, "StrategicPlan", ddlSearchYear.SelectedValue);
btc.getddlMainDepartment(0, ddlSearchMainDept, Cookie.GetValue2("ckMainDeptID"));
btc.getddlMainSubDepartment(0, ddlSearchMainSubDept, ddlSearchMainDept.SelectedValue, Cookie.GetValue2("ckMainSubDeptID"));
btc.getddlDepartment(0, ddlSearchDept, ddlSearchMainSubDept.SelectedValue, Cookie.GetValue2("ckDeptID"), null);
btc.CkAdmissionForAdmin(GridView1, btAdd, null);
DataBind();
}
}
txtStrategicPlan.Attributes.Add("onkeyup", "Cktxt(0);");
txtSort.Attributes.Add("onkeyup", "Cktxt(0);");
ddlDepartment.Attributes.Add("onchange", "Cktxt(0);");
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
MultiView1.ActiveViewIndex = 0;
if (!string.IsNullOrEmpty(Request["Cr"]))
{
btc.Msg_Head(Img1, MsgHead, true, Request["ckmode"], Convert.ToInt32(Request["Cr"]));
}
btc.getddlMainSubDepartment(0, ddlSearch, CurrentUser.MainDeptID, Cookie.GetValue2("MainSubDept").ToString());
btc.CkAdmission(GridView1, btAdd, null);
string mode = Request["mode"];
if (!string.IsNullOrEmpty(mode))
{
switch (mode.ToLower())
{
case "1":
MultiView1.ActiveViewIndex = 1;
hdfApproveFlowDetailID.Value = Guid.NewGuid().ToString();
btc.getddlMainSubDepartment(1, ddlApproveFlow, CurrentUser.MainDeptID, null);
getddlApproveStep();
btc.getddlUserRole(1, ddlUserRole, null);
btc.getddlPosition(1, ddlPosition, ddlUserRole.SelectedValue, null);
getddlckStatus();
btc.GenSort(txtSort, "ApproveFlowDetail", " And ApproveFlowID = '" + ddlApproveFlow.SelectedValue + "' ");
imgPicture.ImageUrl = "../Image/Menu9.png";
Page.ClientScript.RegisterStartupScript(Page.GetType(), Guid.NewGuid().ToString(), "Cktxt(0);", true);
break;
case "2":
MultiView1.ActiveViewIndex = 1;
getddlApproveStep();
btc.getddlUserRole(1, ddlUserRole, null);
getddlckStatus();
btc.btEnable(btSaveAgain, false);
GetData(Request["id"]);
break;
case "3":
MultiView1.ActiveViewIndex = 0;
Delete(Request["id"]);
break;
}
}
else
{
DataBind();
}
}
ddlUserRole.Attributes.Add("onchange", "Cktxt(0);");
ddlApproveStep.Attributes.Add("onchange", "Cktxt(0);");
ddlPosition.Attributes.Add("onchange", "Cktxt(0);");
ddlApproveFlow.Attributes.Add("onchange", "Cktxt(0);");
txtSort.Attributes.Add("onkeyup", "Cktxt(0);");
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
MultiView1.ActiveViewIndex = 0;
if (!string.IsNullOrEmpty(Request["Cr"]))
{
btc.Msg_Head(Img1, MsgHead, true, Request["ckmode"], Convert.ToInt32(Request["Cr"]));
}
//àªç¤»Õ§º»ÃÐÁÒ³
btc.ckBudgetYear(lblSearchYear, lblYear);
getddlYear(0);
btc.CopyEnable(lblCopy, ddlOldYear, btCopy, "FactorRate", ddlSearchYear.SelectedValue);
btc.CkAdmission(GridView1, btAdd, null);
string mode = Request["mode"];
if (!String.IsNullOrEmpty(mode))
{
switch (mode.ToLower())
{
case "1":
MultiView1.ActiveViewIndex = 1;
getddlYear(1);
Page.ClientScript.RegisterStartupScript(Page.GetType(), Guid.NewGuid().ToString(), "Cktxt(0);", true);
break;
case "2":
MultiView1.ActiveViewIndex = 1;
getddlYear(1);
btc.btEnable(btSaveAgain, false);
GetData(Request["id"]);
break;
case "3":
MultiView1.ActiveViewIndex = 0;
Delete(Request["id"]);
break;
}
}
else
{
DataBind();
}
}
txtDetail.Attributes.Add("onkeyup", "Cktxt(0);");
txtCriterion.Attributes.Add("onkeyup", "Cktxt(0);");
txtTranslation.Attributes.Add("onkeyup", "Cktxt(0);");
txtMin.Attributes.Add("onkeyup", "Cktxt(0);");
txtMax.Attributes.Add("onkeyup", "Cktxt(0);");
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
MultiView1.ActiveViewIndex = 0;
if (!string.IsNullOrEmpty(Request["Cr"]))
{
btc.Msg_Head(Img1, MsgHead, true, Request["ckmode"], Convert.ToInt32(Request["Cr"]));
}
//àªç¤»Õ§º»ÃÐÁÒ³
btc.ckBudgetYear(lblSearchYear, lblYear);
LinkReport();
getddlYear(0);
btc.CopyEnable(lblCopy, ddlOldYear, btCopy, "ResponseProblems", ddlSearchYear.SelectedValue);
btc.CkAdmission(GridView1, btAdd, null);
string mode = Request["mode"];
if (!string.IsNullOrEmpty(mode))
{
switch (mode.ToLower())
{
case "1":
MultiView1.ActiveViewIndex = 1;
getddlYear(1);
btc.GenSort(txtSort, "ResponseProblems", " And StudyYear = '" + ddlYearB.SelectedValue + "' ");
Page.ClientScript.RegisterStartupScript(Page.GetType(), Guid.NewGuid().ToString(), "Cktxt(0);", true);
break;
case "2":
MultiView1.ActiveViewIndex = 1;
getddlYear(1);
GetData(Request["id"]);
break;
case "3":
MultiView1.ActiveViewIndex = 0;
Delete(Request["id"]);
btc.CopyEnable(lblCopy, ddlOldYear, btCopy, "ResponseProblems", ddlSearchYear.SelectedValue);
break;
}
}
else
{
DataBind();
}
}
txtResponseProblems.Attributes.Add("onkeyup", "Cktxt(0);");
txtSort.Attributes.Add("onkeyup", "Cktxt(0);");
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
MultiView1.ActiveViewIndex = 0;
if (!string.IsNullOrEmpty(Request.QueryString["Cr"]))
{
btc.Msg_Head(Img1, MsgHead, true, Request.QueryString["ckmode"], Convert.ToInt32(Request.QueryString["Cr"]));
}
btc.CkAdmission(GridView1, btAdd, null);
string mode = Request.QueryString["mode"];
if (!string.IsNullOrEmpty(mode))
{
switch (mode.ToLower())
{
case "1":
MultiView1.ActiveViewIndex = 1;
btc.getddlMainDepartment(1, ddlMainDept, null);
btc.getddlMainSubDepartment(1, ddlMainSubDept, ddlMainDept.SelectedValue, null);
btc.GenSort(txtSort, "Department", " And MainSubDeptCode = '" + ddlMainSubDept.SelectedValue + "' ");
Page.ClientScript.RegisterStartupScript(Page.GetType(), Guid.NewGuid().ToString(), "Cktxt(0);", true);
break;
case "2":
MultiView1.ActiveViewIndex = 1;
btc.btEnable(btSaveAgain, false);
btc.getddlMainDepartment(1, ddlMainDept, null);
GetData(Request.QueryString["id"]);
break;
case "3":
MultiView1.ActiveViewIndex = 0;
Delete(Request.QueryString["id"]);
break;
}
}
else
{
btc.getddlMainDepartment(0, ddlSearchMainDept, Cookie.GetValue2("MainDept"));
btc.getddlMainSubDepartment(0, ddlSearchMainSubDept, ddlSearchMainDept.SelectedValue, Cookie.GetValue2("MainSubDept"));
DataBind();
}
}
ddlMainDept.Attributes.Add("onchange", "Cktxt(0);");
ddlMainSubDept.Attributes.Add("onchange", "Cktxt(0);");
txtDepartment.Attributes.Add("onkeyup", "Cktxt(0);");
txtDeptShortName.Attributes.Add("onkeyup", "Cktxt(0);");
txtSort.Attributes.Add("onkeyup", "Cktxt(0);");
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
MultiView1.ActiveViewIndex = 0;
if (!string.IsNullOrEmpty(Request["Cr"]))
{
btc.Msg_Head(Img1, MsgHead, true, Request["ckmode"], Convert.ToInt32(Request["Cr"]));
}
//àªç¤»Õ§º»ÃÐÁÒ³
btc.ckBudgetYear(lblSearchYear, lblYear);
string mode = Request["mode"];
if (!string.IsNullOrEmpty(mode))
{
switch (mode.ToLower())
{
case "1":
MultiView1.ActiveViewIndex = 1;
txtStudyYear.Text = (DateTime.Now.Year + 543).ToString();
Page.ClientScript.RegisterStartupScript(Page.GetType(), Guid.NewGuid().ToString(), "Cktxt(0);", true);
break;
case "2":
MultiView1.ActiveViewIndex = 1;
GetData(Request["id"]);
break;
case "3":
MultiView1.ActiveViewIndex = 0;
Delete(Request["id"]);
break;
case "7":
MultiView1.ActiveViewIndex = 0;
IsFinality(Request["sYear"], Convert.ToBoolean(Convert.ToInt32(Request["sts"])));
DataBind();
break;
}
}
else
{
btc.CkAdmissionForAdmin(GridView1, btAdd, null);
DataBind();
}
}
txtStudyYear.Attributes.Add("onkeyup", "Cktxt(0);");
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
MultiView1.ActiveViewIndex = 0;
if (!string.IsNullOrEmpty(Request["Cr"]))
{
btc.Msg_Head(Img1, MsgHead, true, Request["ckmode"], Convert.ToInt32(Request["Cr"]));
}
string mode = Request["mode"];
if (!String.IsNullOrEmpty(mode))
{
switch (mode.ToLower())
{
case "1":
MultiView1.ActiveViewIndex = 1;
getddlScoreGroup(1);
Page.ClientScript.RegisterStartupScript(Page.GetType(), Guid.NewGuid().ToString(), "Cktxt(0);", true);
break;
case "2":
MultiView1.ActiveViewIndex = 1;
getddlScoreGroup(1);
btc.btEnable(btSaveAgain, false);
GetData(Request["id"]);
break;
case "3":
MultiView1.ActiveViewIndex = 0;
Delete(Request["id"]);
break;
}
}
else
{
btc.CkAdmissionForAdmin(GridView1, btAdd, null);
getddlScoreGroup(0);
DataBind();
}
}
ddlScoreGroup.Attributes.Add("onchange", "Cktxt(0);");
txtDetail.Attributes.Add("onkeyup", "Cktxt(0);");
txtCriterion.Attributes.Add("onkeyup", "Cktxt(0);");
txtTranslation.Attributes.Add("onkeyup", "Cktxt(0);");
txtMin.Attributes.Add("onkeyup", "Cktxt(0);");
txtMax.Attributes.Add("onkeyup", "Cktxt(0);");
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
MultiView1.ActiveViewIndex = 0;
if (!string.IsNullOrEmpty(Request["Cr"]))
{
btc.Msg_Head(Img1, MsgHead, true, Request["ckmode"], Convert.ToInt32(Request["Cr"]));
}
string mode = Request["mode"];
if (!string.IsNullOrEmpty(mode))
{
switch (mode.ToLower())
{
case "1":
break;
case "2":
break;
case "3":
MultiView1.ActiveViewIndex = 0;
Delete(Request["id"]);
break;
case "7":
break;
}
}
else
{
DataBind();
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
MultiView1.ActiveViewIndex = 0;
if (!string.IsNullOrEmpty(Request["Cr"]))
{
btc.Msg_Head(Img1, MsgHead, true, Request["ckmode"], Convert.ToInt32(Request["Cr"]));
}
//àªç¤»Õ§º»ÃÐÁÒ³
btc.ckBudgetYear(lblSearchYear, lblYear);
getddlYear();
string mode = Request["mode"];
if (!string.IsNullOrEmpty(mode))
{
switch (mode.ToLower())
{
case "1":
break;
case "2":
break;
case "3":
break;
}
}
else
{
DataBind();
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
MultiView1.ActiveViewIndex = 0;
if (!string.IsNullOrEmpty(Request["Cr"]))
{
btc.Msg_Head(Img1, MsgHead, true, Request["ckmode"], Convert.ToInt32(Request["Cr"]));
}
string mode = Request["mode"];
if (!string.IsNullOrEmpty(mode))
{
switch (mode.ToLower())
{
case "1":
MultiView1.ActiveViewIndex = 1;
getddlYear(1);
Page.ClientScript.RegisterStartupScript(Page.GetType(), Guid.NewGuid().ToString(), "SumTotal();", true);
break;
case "2":
MultiView1.ActiveViewIndex = 1;
LinkReport(linkReport1, 20);
LinkReport(linkReport2, 18);
LinkReport(linkReport3, 19);
getddlYear(1);
GetData(Request["id"]);
break;
case "3":
MultiView1.ActiveViewIndex = 0;
Delete(Request["id"]);
break;
}
}
else
{
getddlYear(0);
btc.CkAdmission(GridView1, btAdd, null);
btc.getddlMainDepartment(0, ddlSearchMainDept, Cookie.GetValue2("ckMainDeptID"));
btc.getddlMainSubDepartment(0, ddlSearchMainSubDept, ddlSearchMainDept.SelectedValue, Cookie.GetValue2("ckMainSubDeptID"));
btc.getddlDepartment(0, ddlSearchDept, ddlSearchMainSubDept.SelectedValue, Cookie.GetValue2("ckDeptID"), null);
DataBind();
}
}
}
protected void btSave_Click(object sender, EventArgs e)
{
if (!CkUserRole())
{
return;
}
Connection Conn = new Connection();
BTC btc = new BTC();
if (String.IsNullOrEmpty(Request["mode"]) || Request["mode"] == "1")
{
Int32 i = 0;
for (int j = 0; j <= cblUserRole.Items.Count - 1; j++)
{
if (cblUserRole.Items[j].Selected)
{
i = Conn.AddNew("MenuRole", "MySubMenuID, UserRoleID", ddlMySubMenu.SelectedValue, cblUserRole.Items[j].Value);
}
}
btc.Msg_Head(Img1, MsgHead, true, "1", i);
}
if (Request["mode"] == "2")
{
Int32 i = 0;
DataView dv1 = Conn.Select(string.Format("Select MySubMenuID From MenuRole Where MySubMenuID = '" + Request["id"] + "' "));
if (dv1.Count > 0)
{
Conn.Delete("MenuRole", "Where MySubMenuID = '" + Request["id"] + "' ");
}
for (int j = 0; j <= cblUserRole.Items.Count - 1; j++)
{
if (cblUserRole.Items[j].Selected)
{
i = Conn.AddNew("MenuRole", "MySubMenuID, UserRoleID", Request["id"], cblUserRole.Items[j].Value);
}
}
btc.Msg_Head(Img1, MsgHead, true, "2", i);
}
ClearAll();
DataBind();
if (GridView1.Rows.Count != 0)
{
btnDelete.Visible = true;
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
MultiView1.ActiveViewIndex = 0;
if (!string.IsNullOrEmpty(Request["Cr"]))
{
btc.Msg_Head(Img1, MsgHead, true, Request["ckmode"], Convert.ToInt32(Request["Cr"]));
}
getddlProjectType(0);
btc.CkAdmission(GridView1, btAdd, null);
string mode = Request["mode"];
if (!string.IsNullOrEmpty(mode))
{
switch (mode.ToLower())
{
case "1":
MultiView1.ActiveViewIndex = 1;
getddlProjectType(1);
btc.GenSort(txtSort, "SubProjectType", " And ProjectTypeID = '" + ddlProjectType.SelectedValue + "' ");
Page.ClientScript.RegisterStartupScript(Page.GetType(), Guid.NewGuid().ToString(), "Cktxt(0);", true);
break;
case "2":
MultiView1.ActiveViewIndex = 1;
btc.btEnable(btSaveAgain, false);
GetData(Request["id"]);
break;
case "3":
MultiView1.ActiveViewIndex = 0;
Delete(Request["id"]);
break;
}
}
else
{
DataBind();
}
}
txtSubProjectType.Attributes.Add("onkeyup", "Cktxt(0);");
ddlProjectType.Attributes.Add("onchange", "Cktxt(0);");
txtSort.Attributes.Add("onkeyup", "Cktxt(0);");
}
protected void btSave_Click(object sender, EventArgs e)
{
BTC btc = new BTC();
Connection Conn = new Connection();
if (String.IsNullOrEmpty(Request["mode"]) || Request["mode"] == "1")
{
string NewID = Guid.NewGuid().ToString();
Int32 i = Conn.AddNew("Amphur", "AmphurID, AmphurName, ProvinceID, Sort, DelFlag, CreateUser, CreateDate, UpdateUser, UpdateDate", NewID, txtAmphur.Text, ddlProvince.SelectedValue, txtSort.Text, 0, CurrentUser.ID, DateTime.Now, CurrentUser.ID, DateTime.Now);
btc.Msg_Head(Img1, MsgHead, true, "1", i);
}
if (Request["mode"] == "2")
{
Int32 i = Conn.Update("Amphur", "Where AmphurID = '" + Request["id"] + "' ", "AmphurName, ProvinceID, Sort, UpdateUser, UpdateDate", txtAmphur.Text, ddlProvince.SelectedValue, txtSort.Text, CurrentUser.ID, DateTime.Now);
btc.Msg_Head(Img1, MsgHead, true, "2", i);
}
ClearAll();
DataBind();
}
protected void btSave_Click(object sender, EventArgs e)
{
BTC btc = new BTC();
Connection Conn = new Connection();
if (String.IsNullOrEmpty(Request["mode"]) || Request["mode"] == "1")
{
string NewID = Guid.NewGuid().ToString();
Int32 i = Conn.AddNew("UserRole", "UserRoleID, UserRoleName, IsAdmin, IsAllDept, IsDept, IsManager, IsHeadDept, Sort, DelFlag, CreateUser, CreateDate, UpdateUser, UpdateDate", NewID, txtUserRole.Text, cbAdmin.Checked, cbAllDept.Checked, cbDept.Checked, cbManager.Checked, cbHeadDept.Checked, txtSort.Text, 0, CurrentUser.ID, DateTime.Now, CurrentUser.ID, DateTime.Now);
btc.Msg_Head(Img1, MsgHead, true, "1", i);
}
if (Request["mode"] == "2")
{
Int32 i = Conn.Update("UserRole", "Where UserRoleID = '" + Request["id"] + "' ", "UserRoleName, IsAdmin, IsAllDept, IsDept, IsManager, IsHeadDept, Sort, UpdateUser, UpdateDate", txtUserRole.Text, cbAdmin.Checked, cbAllDept.Checked, cbDept.Checked, cbManager.Checked, cbHeadDept.Checked, txtSort.Text, CurrentUser.ID, DateTime.Now);
btc.Msg_Head(Img1, MsgHead, true, "2", i);
}
ClearAll();
DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (!string.IsNullOrEmpty(Request["Cr"]))
{
btc.Msg_Head(Img1, MsgHead, true, Request["ckmode"], Convert.ToInt32(Request["Cr"]));
}
}
}
protected void btSave_Click(object sender, EventArgs e)
{
Connection Conn = new Connection();
BTC btc = new BTC();
if (String.IsNullOrEmpty(Request["mode"]) || Request["mode"] == "1")
{
string NewID = Guid.NewGuid().ToString();
Int32 i = Conn.AddNew("MyProject", "MyProjectID, MyProjectName, StartPage, Sort, DelFlag, CreateUser, CreateDate, UpdateUser, UpdateDate", NewID, txtMyProjectName.Text, txtStartPage.Text, txtSort.Text, 0, CurrentUser.ID, DateTime.Now, CurrentUser.ID, DateTime.Now);
btc.Msg_Head(Img1, MsgHead, true, "1", i);
}
if (Request["mode"] == "2")
{
Int32 i = Conn.Update("MyProject", "Where MyProjectID = '" + Request["id"] + "' ", "MyProjectName, StartPage, Sort, UpdateUser, UpdateDate", txtMyProjectName.Text, txtStartPage.Text, txtSort.Text, CurrentUser.ID, DateTime.Now);
btc.Msg_Head(Img1, MsgHead, true, "2", i);
}
ClearAll();
DataBind();
}
protected void btSave_Click(object sender, EventArgs e)
{
Connection Conn = new Connection();
BTC btc = new BTC();
if (String.IsNullOrEmpty(Request["mode"]) || Request["mode"] == "1")
{
string NewID = Guid.NewGuid().ToString();
Int32 i = Conn.AddNew("Criterion", "CriterionCode, IndicatorsCode, LevelScore, LevelDetail, CriterionName, Sort, DelFlag, CreateUser, CreateDate, UpdateUser, UpdateDate", NewID, ddlIndicators.SelectedValue, txtLevelScore.Text, txtLevelDetail.Text, txtCriterion.Text, txtSort.Text, 0, CurrentUser.ID, DateTime.Now, CurrentUser.ID, DateTime.Now);
btc.Msg_Head(Img1, MsgHead, true, "1", i);
}
if (Request["mode"] == "2")
{
Int32 i = Conn.Update("Criterion", "Where CriterionCode = '" + Request["id"] + "' ", "IndicatorsCode, LevelScore, LevelDetail, CriterionName, Sort, UpdateUser, UpdateDate", ddlIndicators.SelectedValue, txtLevelScore.Text, txtLevelDetail.Text, txtCriterion.Text, txtSort.Text, CurrentUser.ID, DateTime.Now);
btc.Msg_Head(Img1, MsgHead, true, "2", i);
}
ClearAll();
DataBind();
}
protected void btSave_Click(object sender, EventArgs e)
{
Connection Conn = new Connection();
BTC btc = new BTC();
if (String.IsNullOrEmpty(Request["mode"]) || Request["mode"] == "1")
{
string NewID = Guid.NewGuid().ToString();
Int32 i = Conn.AddNew("EntryCosts", "EntryCostsCode, EntryCostsName, OperationsCode, BudgetType, Sort, DelFlag, CreateUser, CreateDate, UpdateUser, UpdateDate", NewID, txtEntryCosts.Text, ddlOperations.SelectedValue, CkRbt(), txtSort.Text, 0, CurrentUser.ID, DateTime.Now, CurrentUser.ID, DateTime.Now);
btc.Msg_Head(Img1, MsgHead, true, "1", i);
}
if (Request["mode"] == "2")
{
Int32 i = Conn.Update("EntryCosts", "Where EntryCostsCode = '" + Request["id"] + "' ", "EntryCostsName, OperationsCode, BudgetType, Sort, UpdateUser, UpdateDate", txtEntryCosts.Text, ddlOperations.SelectedValue, CkRbt(), txtSort.Text, CurrentUser.ID, DateTime.Now);
btc.Msg_Head(Img1, MsgHead, true, "2", i);
}
ClearAll();
DataBind();
}
private void Delete(string id)
{
if (String.IsNullOrEmpty(id))
{
return;
}
Connection Conn = new Connection();
BTC btc = new BTC();
DataView dv = Conn.Select(string.Format("Select UserRoleID From Employee Where UserRoleID = '" + id + "' And DelFlag = '0' "));
if (dv.Table.Rows.Count > 0)
{
btc.Msg_Head(Img1, MsgHead, true, "3", 0);
}
else
{
Int32 i = Conn.Update("UserRole", "Where UserRoleID = '" + id + "' ", "DelFlag, UpdateUser, UpdateDate", 1, CurrentUser.ID, DateTime.Now);
btc.Msg_Head(Img1, MsgHead, true, "3", i);
}
ClearAll();
}
private void Delete(string id)
{
if (String.IsNullOrEmpty(id))
{
return;
}
Connection Conn = new Connection();
BTC btc = new BTC();
DataView dv = Conn.Select(string.Format("Select CostsCode From dtCostsAct Where CostsCode = '" + id + "' "));
if (dv.Count > 0)
{
btc.Msg_Head(Img1, MsgHead, true, "3", 0);
}
else
{
Int32 i = Conn.Update("CostsCenter", "Where CostsCode = '" + id + "' ", "DelFlag, UpdateUser, UpdateDate", 1, CurrentUser.ID, DateTime.Now);
btc.Msg_Head(Img1, MsgHead, true, "3", i);
}
ClearAll();
}
protected void btSave_Click(object sender, EventArgs e)
{
if (!CkOldPassword())
{
return;
}
Int32 i = Conn.Update("Employee", "WHERE EmpID = '" + CurrentUser.ID + "' ", "Pwd", Text.Encrypt(txtNewPassword.Text));
ClearAll();
btc.Msg_Head(Img1, MsgHead, true, "2", i);
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
MultiView1.ActiveViewIndex = 0;
if (!string.IsNullOrEmpty(Request["Cr"]))
{
btc.Msg_Head(Img1, MsgHead, true, Request["ckmode"], Convert.ToInt32(Request["Cr"]));
}
getddlYear(0);
btc.CkAdmission(GridView1, btAdd, null);
string mode = Request["mode"];
if (!string.IsNullOrEmpty(mode))
{
switch (mode.ToLower())
{
case "1":
MultiView1.ActiveViewIndex = 1;
getddlYear(1);
Page.ClientScript.RegisterStartupScript(Page.GetType(), Guid.NewGuid().ToString(), "SumTotal();", true);
break;
case "2":
MultiView1.ActiveViewIndex = 1;
getddlYear(1);
GetData(Request["id"]);
break;
case "3":
MultiView1.ActiveViewIndex = 0;
Delete(Request["id"]);
break;
}
}
else
{
DataBind();
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (!string.IsNullOrEmpty(Request.QueryString["Cr"]))
{
btc.Msg_Head(Img1, MsgHead, true, Request.QueryString["ckmode"], Convert.ToInt32(Request.QueryString["Cr"]));
}
getrbtlRenew();
getExpDate();
}
}
private void Delete(string id)
{
BTC btc = new BTC();
if (String.IsNullOrEmpty(id))
{
return;
}
Connection Conn = new Connection();
DataView dv = Conn.Select(string.Format("Select ProvinceID From Amphur Where ProvinceID = '" + id + "' And DelFlag = 0 "));
if (dv.Count != 0)
{
btc.Msg_Head(Img1, MsgHead, true, "3", 0);
}
else
{
Int32 i = Conn.Update("Province", "Where ProvinceID = '" + id + "' ", "DelFlag, UpdateUser, UpdateDate", 1, CurrentUser.ID, DateTime.Now);
btc.Msg_Head(Img1, MsgHead, true, "3", i);
}
ClearAll();
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
MultiView1.ActiveViewIndex = 0;
TotalAmount = 0;
if (!string.IsNullOrEmpty(Request.QueryString["Cr"]))
{
btc.Msg_Head(Img1, MsgHead, true, Request.QueryString["ckmode"], Convert.ToInt32(Request.QueryString["Cr"]));
}
//àªç¤»Õ§º»ÃÐÁÒ³
btc.ckBudgetYear(lblSearchYear, null);
string mode = Request.QueryString["mode"];
if (!string.IsNullOrEmpty(mode))
{
switch (mode.ToLower())
{
case "1":
MultiView1.ActiveViewIndex = 1;
break;
case "2":
MultiView1.ActiveViewIndex = 1;
getddlYear(1);
//SetItem();
GetData(Request.QueryString["id"]);
break;
case "3":
MultiView1.ActiveViewIndex = 0;
break;
}
}
else
{
getddlYear(0);
//getddlStrategies(0, ddlSearchYear.SelectedValue);
btc.getddlMainDepartment(0, ddlSearchMainDept, Cookie.GetValue2("ckMainDeptID"));
btc.getddlMainSubDepartment(0, ddlSearchMainSubDept, ddlSearchMainDept.SelectedValue, Cookie.GetValue2("ckMainSubDeptID"));
btc.getddlDepartment(0, ddlSearchDept, ddlSearchMainSubDept.SelectedValue, Cookie.GetValue2("ckDeptID"), null);
btc.getddlEmpByDept(0, ddlSearchEmp, ddlSearchDept.SelectedValue, Cookie.GetValue2("ckEmpID"));
DataBind();
}
}
txtConclusion.Attributes.Add("onkeyup", "Cktxt(0);");
txtPerformance.Attributes.Add("onkeyup", "Cktxt(0);");
txtProblem.Attributes.Add("onkeyup", "Cktxt(0);");
txtSolutions.Attributes.Add("onkeyup", "Cktxt(0);");
}
