protected override void OnPreInit(EventArgs e)
{
if (btc.ckGetAdmission(CurrentUser.UserRoleID) == 2)
{
this.MasterPageFile = "~/Master/MasterManageView.master";
}
}
protected override void OnPreInit(EventArgs e)
{
if (btc.ckGetAdmission(CurrentUser.UserRoleID) == 2)
{
Response.Redirect("ManegerView.aspx");
}
}
protected override void OnInit(EventArgs e)
{
if (!IsPostBack && !Program.Settings.IsValid)
{
BTC.DisplayInValidLicense(Page);
}
//base.OnInit;
BTC btc = new BTC();
DataView dv = btc.getMasterSchool();
if (dv.Count != 0)
{
if (Convert.ToInt32(dv[0]["ckExpDate"]) == 0)
{
if (CurrentUser.ID != "4C3E218F-D513-416E-BD10-B4F161717F70")
{
Response.Redirect("../Setting/UnderConstruction2.aspx");
}
}
if (Convert.ToInt32(dv[0]["IsCon"]) == 1)
{
if (btc.ckGetAdmission(CurrentUser.UserRoleID) != 1)
{
Response.Redirect("../Setting/UnderConstruction.aspx");
}
}
}
}
private void ckImgBtVisible()
{
BTC btc = new BTC();
if (btc.ckGetAdmission(CurrentUser.UserRoleID) != 1)
{
ImgBt1.Visible = false;
ImgBt2.Visible = false;
}
else
{
DataView dv;
dv = new BTC().getMasterSchool();
if (Convert.ToInt32(dv[0]["IsCon"]) == 0)
{
ImgBt1.Visible = true;
ImgBt2.Visible = false;
}
else
{
ImgBt1.Visible = false;
ImgBt2.Visible = true;
}
}
}
protected string checkedit(string id, string strName)
{
if (btc.ckGetAdmission(CurrentUser.UserRoleID) == 1)
{
return(String.Format("<a href=\"javascript:;\" title=\"{1}\" onclick=\"EditItem('{0}');\">{1}</a>", id, strName));
}
else
{
return(strName);
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
//àªç¤»Õ§º»ÃÐÁÒ³
btc.ckBudgetYear(null, lblYear);
if (btc.ckIdentityName("ckBudgetYear"))
{
lblYear2.InnerText = "»Õ¡ÒÃÈÖ¡ÉÒ : ";
}
getddlYear(1);
btc.getddlDay(ddlSDay);
btc.getddlMonth2(ddlSMonth);
btc.getddlYear(ddlSYear, 4);
btc.getddlDay(ddlEDay);
btc.getddlMonth2(ddlEMonth);
btc.getddlYear(ddlEYear, 4);
string mode = Request["mode"];
if (!String.IsNullOrEmpty(mode))
{
switch (mode.ToLower())
{
case "1":
break;
case "2":
MultiView1.ActiveViewIndex = 0;
GetData(Request["id"]);
GetDataAttach(Request["id"]);
if (btc.CkActivitySuccess(Request["id"]))
{
btSave.Visible = false;
if (btc.ckGetAdmission(CurrentUser.UserRoleID) == 1)
{
btUndo.Visible = true;
}
}
break;
case "3":
break;
}
}
}
ddlSDay.Attributes.Add("onchange", "ckddlDate(1);");
ddlSMonth.Attributes.Add("onchange", "ckddlDate(1);");
ddlSYear.Attributes.Add("onchange", "ckddlDate(1);");
ddlEDay.Attributes.Add("onchange", "ckddlDate(2);");
ddlEMonth.Attributes.Add("onchange", "ckddlDate(2);");
ddlEYear.Attributes.Add("onchange", "ckddlDate(2);");
}
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"]));
}
getActivityName(Request.QueryString["acid"]);
btc.getddlDay(ddlSDay);
btc.getddlMonth2(ddlSMonth);
btc.getddlYear(ddlSYear, 5);
btc.getddlDay(ddlSDay2);
btc.getddlMonth2(ddlSMonth2);
btc.getddlYear(ddlSYear2, 5);
txtSDay.Text = DateTime.Now.ToShortDateString();
txtSDay2.Text = DateTime.Now.ToShortDateString();
Cookie.SetValue2("ckActivityStatus", btc.ckIdentityName("ckActivityStatus")); //àªç¤âËÁ´µÔ´µÒÁ§Ò¹
if (btc.CkStatusActivitySuccess(Request["acid"]))
{
btSave.Visible = false;
GridView1.Columns[GridView1.Columns.Count - 1].Visible = false;
}
if (btc.ckGetAdmission(CurrentUser.UserRoleID) != 1)
{
GridView1.Columns[GridView1.Columns.Count - 1].Visible = false;
}
string mode = Request["mode"];
int ij = string.IsNullOrEmpty(Request.QueryString["i"]) ? 0 : Convert.ToInt32(Request.QueryString["i"]);
btc.getddlActivityStatus(ddlActivityStatus);
if (!string.IsNullOrEmpty(mode))
{
switch (mode.ToLower())
{
case "1":
MultiView1.ActiveViewIndex = 1;
getDataActivity(Request.QueryString["acid"]);
getSort(Request.QueryString["acid"]);
hdfID.Value = Guid.NewGuid().ToString();
getlblKeyWord();
getddlDeputyDirectorName();
//txtResponsibleName.Text = lblEmp.Text;
txtPositionResponsible.Text = "¼ÙéÃѺ¼Ô´ªÍº¡Ô¨¡ÃÃÁ";
txtPositionHeadGroup.Text = "ËÑÇ˹éÒ¡ÅØèÁ§Ò¹";
txtPositionHeadGroupSara.Text = "ËÑÇ˹éÒ§Ò¹/¡ÅØèÁÊÒÃÐÏ";
txtPositionUnderManagerName.Text = "Ãͧ¼ÙéÍӹǡÒáÅØèÁ";
if (Convert.ToBoolean(Cookie.GetValue2("ckActivityStatus")))
{
DivActivityStatus.Visible = true;
}
Page.ClientScript.RegisterStartupScript(Page.GetType(), Guid.NewGuid().ToString(), "Cktxt(0);", true);
break;
case "2":
MultiView1.ActiveViewIndex = 1;
getDataActivity(Request.QueryString["acid"]);
hdfID.Value = Request.QueryString["id"];
txtWithdrow.ReadOnly = true;
getlblKeyWord();
getddlDeputyDirectorName();
GetData(hdfID.Value);
GetDataAttach(hdfID.Value);
break;
case "3":
MultiView1.ActiveViewIndex = 0;
Delete(Request["id"]);
break;
case "4":
btc.Msg_Head(Img1, MsgHead, true, "2", ij);
break;
}
}
else
{
DataBind();
}
}
txtActivityDetail.Attributes.Add("onkeyup", "Cktxt(0);");
txtWithdrow.Attributes.Add("onkeyup", "Cktxt(0);");
ddlSDay.Attributes.Add("onchange", "ckddlDate();");
ddlSMonth.Attributes.Add("onchange", "ckddlDate();");
ddlSYear.Attributes.Add("onchange", "ckddlDate();");
ddlSDay2.Attributes.Add("onchange", "ckddlDate2();");
ddlSMonth2.Attributes.Add("onchange", "ckddlDate2();");
ddlSYear2.Attributes.Add("onchange", "ckddlDate2();");
}
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"]));
}
getddlUserRole(0);
getddlDept(0);
btc.CkAdmission(GridView1, btAdd, null);
int i = btc.ckGetAdmission(CurrentUser.UserRoleID);
if (i != 1)
{
spnImportExcel.Visible = false;
spnDownLoadFile.Visible = false;
ddlSearchDept.Enabled = false;
ddlSearch.Enabled = false;
GridView1.Columns[GridView1.Columns.Count - 3].Visible = false;
}
string mode = Request["mode"];
if (!String.IsNullOrEmpty(mode))
{
switch (mode.ToLower())
{
case "1":
MultiView1.ActiveViewIndex = 1;
getddlUserRole(1);
getddlDept(1);
getSchool();
tblEditPwd.Visible = true;
Page.ClientScript.RegisterStartupScript(Page.GetType(), Guid.NewGuid().ToString(), "Cktxt(0);", true);
Page.ClientScript.RegisterClientScriptBlock(this.GetType(), Guid.NewGuid().ToString(), "function CkEmp(){" + Page.ClientScript.GetPostBackEventReference(btCkEmp, null, false) + ";}", true);
break;
case "2":
MultiView1.ActiveViewIndex = 1;
getddlUserRole(1);
getddlDept(1);
getSchool();
tblEditPwd.Visible = false;
GetData(Request["id"]);
break;
case "3":
MultiView1.ActiveViewIndex = 0;
Delete(Request["id"]);
break;
case "4":
MultiView1.ActiveViewIndex = 0;
ResetPwd(Request["id"]);
break;
case "5":
MultiView1.ActiveViewIndex = 0;
Hide(Request["id"]);
break;
}
}
else
{
DataBind();
}
}
txtUserName.Attributes.Add("onkeyup", "Cktxt(0);");
txtUserName.Attributes.Add("onchange", "var fnc=parent.eval('CkEmp'); if(typeof(fnc)=='function' && fnc) fnc();");
txtPwd.Attributes.Add("onkeyup", "Cktxt(0);");
txtConfirmPwd.Attributes.Add("onkeyup", "Cktxt(0);");
txtName.Attributes.Add("onkeyup", "Cktxt(0);");
txtEmail.Attributes.Add("onkeyup", "Cktxt(0);");
txtTel.Attributes.Add("onkeyup", "Cktxt(0);");
ddlSchool.Attributes.Add("onchange", "Cktxt(0);");
ddlDept.Attributes.Add("onchange", "Cktxt(0);");
ddlUserRole.Attributes.Add("onchange", "Cktxt(0);");
}
private void GetData(string id)
{
if (String.IsNullOrEmpty(id))
{
return;
}
DataView dv = Conn.Select(string.Format("Select * From MR_School Where SchoolID = '" + id + "'"));
if (dv.Count != 0)
{
txtSchoolID.Text = dv[0]["SchoolNo"].ToString();
txtSchoolName.Text = dv[0]["SchoolName"].ToString();
txtAddress.Text = dv[0]["Address"].ToString();
ddlProvince.SelectedValue = dv[0]["ProvinceID"].ToString();
txtTel.Text = dv[0]["Tel"].ToString();
txtFax.Text = dv[0]["Fax"].ToString();
txtArea.Text = dv[0]["strTotalArea"].ToString();
cbPrimary.Checked = Convert.ToBoolean(dv[0]["IsPrimaryEdu"]);
cbSecondary.Checked = Convert.ToBoolean(dv[0]["IsSecondary"]);
cbHighSchool.Checked = Convert.ToBoolean(dv[0]["IsHighSc"]);
txtAreaOfStudy.Text = dv[0]["AreaStudyID"].ToString();
txtDateBegin.Text = Convert.ToDateTime(dv[0]["BirthDate"]).ToShortDateString();
ddlSDay.SelectedValue = Convert.ToDateTime(dv[0]["BirthDate"]).Day.ToString("00");
ddlSMonth.SelectedValue = Convert.ToDateTime(dv[0]["BirthDate"]).Month.ToString("00");
ddlSYear.SelectedValue = (Convert.ToDateTime(dv[0]["BirthDate"]).Year + 543).ToString();
txtSchoolColor.Text = dv[0]["SchoolColor"].ToString();
txtPhilosophy.Text = dv[0]["Philosophy"].ToString();
txtSlogan.Text = dv[0]["Slogan"].ToString();
txtPolicy.Text = dv[0]["Policy"].ToString();
txtHistory.Text = dv[0]["History"].ToString();
txtManagerPlanName.Text = dv[0]["ManagerPlanName"].ToString();
txtPositionPlanName.Text = dv[0]["PositionPlanName"].ToString();
txtManagerSuppliesName.Text = dv[0]["ManagerSuppliesName"].ToString();
txtPositionSuppliesName.Text = dv[0]["PositionSuppliesName"].ToString();
txtManagerMoneyName.Text = dv[0]["ManagerMoneyName"].ToString();
txtPositionMoneyName.Text = dv[0]["PositionMoneyName"].ToString();
txtUnderBudgetName.Text = dv[0]["UnderBudgetName"].ToString();
txtPositionManagerBudgetName.Text = dv[0]["PositionManagerBudgetName"].ToString();
txtUnderManagerName.Text = dv[0]["UnderManagerName"].ToString();
txtPositionUnderManagerName.Text = dv[0]["PositionUnderManagerName"].ToString();
//txtDeputyDirectorName.Text = dv[0]["DeputyDirectorName"].ToString();
//txtPositionDeputyDirector.Text = dv[0]["PositionDeputyDirector"].ToString();
txtGroupLeaderPlanName.Text = dv[0]["GroupLeaderPlanName"].ToString();
txtPositionGroupLeaderPlan.Text = dv[0]["PositionGroupLeaderPlan"].ToString();
string strSql = " Select DeputyDirectorID, DeputyDirectorName, DeputyDirectorPosition, Sort As id "
+ " From DeputyDirector "
+ " Where SchoolID = '{0}' ";
dvDeputyDirector = Conn.Select(string.Format(strSql + " Order By Sort ", id));
if (dvDeputyDirector.Count != 0)
{
btDelDeputyDirector.Visible = true;
if (Session["DeputyDirector"] == null)
{
DataTable dt1 = new DataTable();
dt1.Columns.Add("id");
dt1.Columns.Add("DeputyDirectorName");
dt1.Columns.Add("DeputyDirectorPosition");
DataRow dr;
for (int i = 0; i < dvDeputyDirector.Count; i++)
{
dr = dt1.NewRow();
dr["id"] = dvDeputyDirector[i]["id"].ToString();
dr["DeputyDirectorName"] = dvDeputyDirector[i]["DeputyDirectorName"].ToString();
dr["DeputyDirectorPosition"] = dvDeputyDirector[i]["DeputyDirectorPosition"].ToString();
dt1.Rows.Add(dr);
}
dvDeputyDirector = dt1.DefaultView;
Session["DeputyDirector"] = dt1;
}
GridViewDeputyDirector.Visible = true;
GridViewDeputyDirector.DataSource = dvDeputyDirector;
GridViewDeputyDirector.CheckListDataField = "id";
GridViewDeputyDirector.DataBind();
}
else
{
btDelDeputyDirector.Visible = false;
GridViewDeputyDirector.Visible = false;
}
//ddlYearS.SelectedValue = dv[0]["StudyYear"].ToString();
getMission(ddlYearS.SelectedValue);
getGoals(ddlYearS.SelectedValue);
getStrategies(ddlYearS.SelectedValue);
txtIdentity.Text = dv[0]["IdentityName"].ToString();
txtIdentity2.Text = dv[0]["IdentityName2"].ToString();
txtVision.Text = dv[0]["Vision"].ToString();
txtManagerName.Text = dv[0]["ManagerName"].ToString();
txtPositionManagerName.Text = dv[0]["PositionManagerName"].ToString();
if (!string.IsNullOrEmpty(dv[0]["LogoPath"].ToString()))
{
imgPicture.ImageUrl = dv[0]["LogoPath"].ToString();
ImgBt.Visible = true;
}
else
{
imgPicture.ImageUrl = "../Image/Menu9.png";
ImgBt.Visible = false;
}
if (btc.ckGetAdmission(CurrentUser.UserRoleID) != 1)
{
btSave.Visible = false;
fiUpload.Visible = false;
btnUpload.Visible = false;
ImgBt.Visible = false;
}
else
{
btSave.Visible = true;
fiUpload.Visible = true;
btnUpload.Visible = true;
}
}
}
private void GetData(string id)
{
if (String.IsNullOrEmpty(id))
{
return;
}
DataView dv = Conn.Select(string.Format("Select *, IsNull(ckSale, 0) ck_Sale From MR_School Where SchoolID = '" + id + "'"));
if (dv.Count != 0)
{
txtIdentity.Text = dv[0]["IdentityName"].ToString();
txtIdentity2.Text = dv[0]["IdentityName2"].ToString();
txtUpdateLink.Text = dv[0]["UpdateLink"].ToString();
txtLogSarLink.Text = dv[0]["LogSarLink"].ToString();
txtForwardMail.Text = dv[0]["MailTo"].ToString();
txtPositionResponsible.Text = dv[0]["PositionResponsible"].ToString();
txtPositionHeadGroupSara.Text = dv[0]["PositionHeadGroupSara"].ToString();
txtPositionHeadGroup.Text = dv[0]["PositionHeadGroup"].ToString();
rbtlYearType.SelectedValue = Convert.ToInt32(dv[0]["ckBudgetYear"]).ToString();
rbtlIdentity1.SelectedValue = Convert.ToInt32(dv[0]["iNameShow"]).ToString();
rbtlIdentity2.SelectedValue = Convert.ToInt32(dv[0]["iNameShow2"]).ToString();
txtPlanNo.Text = dv[0]["PlanNo"].ToString();
rbtlPlanNo.SelectedValue = Convert.ToInt32(dv[0]["ckPlanNo"]).ToString();
rbtlPolicy.SelectedValue = Convert.ToInt32(dv[0]["ckPolicy"]).ToString();
rbtlNewStandard.SelectedValue = Convert.ToInt32(dv[0]["ckNewStandard"]).ToString();
rbtlStrategicObjectives.SelectedValue = Convert.ToInt32(dv[0]["ckStrategicObjectives"]).ToString();
rbtlStrategySPT.SelectedValue = Convert.ToInt32(dv[0]["ckStrategySPT"]).ToString();
rbtlStrategySPM.SelectedValue = Convert.ToInt32(dv[0]["ckStrategySPM"]).ToString();
rbtlStandardSPM.SelectedValue = Convert.ToInt32(dv[0]["ckStandardSPM"]).ToString();
rbtlJulaporn.SelectedValue = Convert.ToInt32(dv[0]["ckJuraporn"]).ToString();
rbtlStrategic.SelectedValue = Convert.ToInt32(dv[0]["ckStrategic"]).ToString();
rbtlResource.SelectedValue = Convert.ToInt32(dv[0]["ckResource"]).ToString();
rbtlQA.SelectedValue = Convert.ToInt32(dv[0]["ckQA"]).ToString();
rbtlWorldClass.SelectedValue = Convert.ToInt32(dv[0]["ckWorldClass"]).ToString();
rbtlRoyalAward.SelectedValue = Convert.ToInt32(dv[0]["ckRoyalAward"]).ToString();
rbtlPopularity.SelectedValue = Convert.ToInt32(dv[0]["ckPopularity"]).ToString();
rbtlPrimePolicy.SelectedValue = Convert.ToInt32(dv[0]["ckPrimePolicy"]).ToString();
rbtlPoliciesMinister.SelectedValue = Convert.ToInt32(dv[0]["ckPoliciesMinister"]).ToString();
rbtlPolicyKSN.SelectedValue = Convert.ToInt32(dv[0]["ckPolicyKSN"]).ToString();
rbtlCorporateStrategy.SelectedValue = Convert.ToInt32(dv[0]["ckCorporateStrategy"]).ToString();
rbtlStrategicPlan.SelectedValue = Convert.ToInt32(dv[0]["ckStrategicPlan"]).ToString();
rbtlMainActivity.SelectedValue = Convert.ToInt32(dv[0]["ckMainActivity"]).ToString();
rbtlTargetMode.SelectedValue = Convert.ToInt32(dv[0]["ckTargetMode"]).ToString();
rbtlPlan.SelectedValue = Convert.ToInt32(dv[0]["ckPlan"]).ToString();
rbtlProjectDes.SelectedValue = Convert.ToInt32(dv[0]["ckProjectDes"]).ToString();
rbtlStrategies.SelectedValue = Convert.ToInt32(dv[0]["ckStrategies"]).ToString();
rbtlRisk.SelectedValue = Convert.ToInt32(dv[0]["ckRisk"]).ToString();
rbtlDeptProjects.SelectedValue = Convert.ToInt32(dv[0]["ckDeptProjects"]).ToString();
rbtlEducation21.SelectedValue = Convert.ToInt32(dv[0]["ckEducation21"]).ToString();
rbtlSuffice.SelectedValue = Convert.ToInt32(dv[0]["ckSuffice"]).ToString();
rbtlFourthAssessment.SelectedValue = Convert.ToInt32(dv[0]["ckFourthAssessment"]).ToString();
rbtlActivityStatus.SelectedValue = Convert.ToInt32(dv[0]["ckActivityStatus"]).ToString();
rbtlAcAssessment.SelectedValue = Convert.ToInt32(dv[0]["ckAcAssessment"]).ToString();
rbtBudgetTerm.SelectedValue = Convert.ToInt32(dv[0]["ckBudgetTerm"]).ToString();
rbtlSuan.SelectedValue = Convert.ToInt32(dv[0]["ckSuan"]).ToString();
rbtlResponseProblems.SelectedValue = Convert.ToInt32(dv[0]["ckResponseProblems"]).ToString();
rbtlStatute.SelectedValue = Convert.ToInt32(dv[0]["ckStatute"]).ToString();
rbtlFullText.SelectedValue = Convert.ToInt32(dv[0]["ckFullText"]).ToString();
rbtlAnuban.SelectedValue = Convert.ToInt32(dv[0]["ckAnuban"]).ToString();
rbtlIndicatorSMS.SelectedValue = Convert.ToInt32(dv[0]["ckIndicatorSMS"]).ToString();
rbtlStandardNew.SelectedValue = Convert.ToInt32(dv[0]["ckStandardNew"]).ToString();
rbtlMgSignature.SelectedValue = Convert.ToInt32(dv[0]["ckMgSignature"]).ToString();
rbtlStandardNation.SelectedValue = Convert.ToInt32(dv[0]["ckStandardNation"]).ToString();
rbtlStandardMinistry.SelectedValue = Convert.ToInt32(dv[0]["ckStandardMinistry"]).ToString();
rbtlRate.SelectedValue = Convert.ToInt32(dv[0]["ckRate"]).ToString();
rbtlEstimate.SelectedValue = Convert.ToInt32(dv[0]["ckEstimate"]).ToString();
rbtlCostsCenter.SelectedValue = Convert.ToInt32(dv[0]["ckCostsCenter"]).ToString();
rbtlSale.SelectedValue = Convert.ToInt32(dv[0]["ck_Sale"]).ToString();
cbReportW.Checked = Convert.ToBoolean(dv[0]["ckWord"]);
cbReportE.Checked = Convert.ToBoolean(dv[0]["ckExcel"]);
cbReportP.Checked = Convert.ToBoolean(dv[0]["ckPDF"]);
getReport(dv[0]["ckReportProject"].ToString(), cblReportProject);
getReport(dv[0]["ckReportActivity"].ToString(), cblReportActivity);
if (btc.ckGetAdmission(CurrentUser.UserRoleID) != 1)
{
btSave.Visible = false;
}
else
{
btSave.Visible = true;
}
}
}
