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);"); }