protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { if (LoginSession.IsLogin()) { if (!LoginSession.IsAdmin()) { if (!LoginSession.IsView("MN-00002")) { Response.Redirect("NoPermitsion.aspx"); } } } else { Response.Redirect("/Account/Login.aspx?Url=" + Request.Url.PathAndQuery); } hidUserName.Value = LoginSession.UserName(); #region CategorysMN aCategorysMN = new CategorysMN(); ListItem aListItem = new ListItem(); string CatTypeCode = string.Empty; CatTypeCode = "CT-00003"; //Application Site ddlApplicationSite.Items.Clear(); ddlApplicationSite.DataSource = aCategorysMN.ListCategorys(string.Empty, string.Empty, CatTypeCode); ddlApplicationSite.DataValueField = "CatCode"; ddlApplicationSite.DataTextField = "CatName"; ddlApplicationSite.DataBind(); //CatTypeCode = "CT-00004"; //Doc Type //ddlDocType.Items.Clear(); //ddlDocType.DataSource = aCategorysMN.ListCategorys(string.Empty, string.Empty, CatTypeCode); //ddlDocType.DataValueField = "CatCode"; //ddlDocType.DataTextField = "CatName"; //ddlDocType.DataBind(); CatTypeCode = "CT-00002"; ddlPreservingDepartment.Items.Clear(); ddlPreservingDepartment.DataSource = aCategorysMN.ListCategorys(string.Empty, string.Empty, CatTypeCode); ddlPreservingDepartment.DataValueField = "CatCode"; ddlPreservingDepartment.DataTextField = "CatName"; ddlPreservingDepartment.DataBind(); ddlPreservingDepartment.Items.Insert(0, new ListItem("---ALL---", "ALL")); CatTypeCode = "CT-00009"; ddlStorageTime.Items.Clear(); ddlStorageTime.DataSource = aCategorysMN.ListCategorys(string.Empty, string.Empty, CatTypeCode); ddlStorageTime.DataValueField = "CatCode"; ddlStorageTime.DataTextField = "CatName"; ddlStorageTime.DataBind(); UserInDepartmentMN aUserInDepartmentMN = new UserInDepartmentMN(); #endregion #region string DocNo = Convert.ToString(Request.QueryString["DocNo"]); string CodeDocument = Convert.ToString(Request.QueryString["CodeDocument"]); string PublishDocument = Convert.ToString(Request.QueryString["PublishDocument"]); if (!String.IsNullOrEmpty(CodeDocument) && !String.IsNullOrEmpty(DocNo)) { #region ddlDepartment.Items.Clear(); ddlDepartment.DataSource = aUserInDepartmentMN.ListDepartmentByUserName(LoginSession.UserName()); ddlDepartment.DataValueField = "Department"; ddlDepartment.DataTextField = "NameDepartment"; ddlDepartment.DataBind(); hidCodeDocument.Value = CodeDocument; RegisterCodeSecurityMN aRegisterCodeDocumentMN = new RegisterCodeSecurityMN(); txtApplicationName.Text = LoginSession.FullName(); txtApplicationNO.Text = string.Empty; txtApplicationDate.Text = DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss"); DataTable aData = aRegisterCodeDocumentMN.ListRegisterCodeDocumentByDCC(CodeDocument, string.Empty, DocNo, string.Empty, Convert.ToDateTime("1900-01-01"), Convert.ToDateTime("1900-01-01")); if (aData.Rows.Count > 0) { txtDocNO.Text = Convert.ToString(aData.Rows[0]["DocNo"]); txtDocName.Text = Convert.ToString(aData.Rows[0]["DocName"]); ddlApplicationSite.Text = Convert.ToString(aData.Rows[0]["ApplicationSite"]); //hidFileName.Value = Convert.ToString(aData.Rows[0]["FileName"]); //ddlDocType.Text = Convert.ToString(aData.Rows[0]["DocumentType"]); hidApplicableSite.Value = Convert.ToString(aData.Rows[0]["ApplicableSite"]); //hidApplicableBU.Value = Convert.ToString(aData.Rows[0]["ApplicableBU"]); } #endregion } else { if (!String.IsNullOrEmpty(PublishDocument)) { #region RegisterPublishSecurityMN aRegisterPublishDocumentMN = new RegisterPublishSecurityMN(); DataTable aData = aRegisterPublishDocumentMN.ListRegisterPublishDocument(PublishDocument, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, Convert.ToDateTime("1900-01-01"), Convert.ToDateTime("1900-01-01")); if (aData.Rows.Count > 0) { ddlDepartment.Items.Clear(); ddlDepartment.DataSource = aUserInDepartmentMN.ListDepartmentByUserName(Convert.ToString(aData.Rows[0]["CreatedBy"])); ddlDepartment.DataValueField = "Department"; ddlDepartment.DataTextField = "NameDepartment"; ddlDepartment.DataBind(); txtApplicationName.Text = Convert.ToString(aData.Rows[0]["HoTen"]); hidID.Value = Convert.ToString(aData.Rows[0]["ID"]); hidPublishDocument.Value = PublishDocument; hidStates.Value = Convert.ToString(aData.Rows[0]["States"]); txtApplicationNO.Text = Convert.ToString(aData.Rows[0]["PublishDocument"]); ddlApplicationSite.Text = Convert.ToString(aData.Rows[0]["ApplicationSite"]); txtEffectiveDate.Text = Convert.ToDateTime(aData.Rows[0]["EffectiveDate"]).Year > 1900 ? Convert.ToDateTime(aData.Rows[0]["EffectiveDate"]).ToString("yyyy/MM/dd") : string.Empty; txtDocNO.Text = Convert.ToString(aData.Rows[0]["DocumentNo"]); txtREV.Text = Convert.ToString(aData.Rows[0]["Rev"]); txtDocName.Text = Convert.ToString(aData.Rows[0]["DocumentName"]); //ddlDocType.Text = Convert.ToString(aData.Rows[0]["DocumentType"]); //txtRevisionApplication.Text = Convert.ToString(aData.Rows[0]["RevisionApplication"]); //txtCheckingNotice.Text = Convert.ToString(aData.Rows[0]["CheckingNotice"]); txtDocumentObsolete.Text = Convert.ToString(aData.Rows[0]["DeletedDocumentOld"]); txtDocumentReference.Text = Convert.ToString(aData.Rows[0]["ReferenceDocument"]); //txtWordKey.Text = Convert.ToString(aData.Rows[0]["IndexWord"]); txtApplicationDate.Text = Convert.ToDateTime(aData.Rows[0]["ApplicationDate"]).ToString("yyyy/MM/dd HH:mm:ss"); hidApplicableSite.Value = Convert.ToString(aData.Rows[0]["ApplicableSite"]); //hidApplicableBU.Value = Convert.ToString(aData.Rows[0]["ApplicableBU"]); //hidDepartmentCheck.Value = Convert.ToString(aData.Rows[0]["DepartmentCheck"]); hidFileName.Value = Convert.ToString(aData.Rows[0]["ContentFile"]); hidNeedRelease.Value = Convert.ToString(aData.Rows[0]["NeedReleaseFile"]); aListItem = ddlDepartment.Items.FindByValue(Convert.ToString(aData.Rows[0]["Department"])); if (aListItem != null) { ddlDepartment.SelectedValue = Convert.ToString(aData.Rows[0]["Department"]); } } #endregion } } #endregion } }
protected void Page_Load(object sender, EventArgs e) { try { if (!IsPostBack) { if (LoginSession.IsLogin()) { if (!LoginSession.IsAdmin()) { if (!LoginSession.IsView("MN-00001")) { Response.Redirect("NoPermitsion.aspx"); } } } else { Response.Redirect("/Account/Login.aspx?Url=" + Request.Url.PathAndQuery); } hidUserName.Value = LoginSession.UserName(); #region string CodeDocument = Convert.ToString(Request.QueryString["CodeDocument"]); CategorysMN aCategorysMN = new CategorysMN(); ListItem aListItem = new ListItem(); string CatTypeCode = string.Empty; CatTypeCode = "CT-00003"; //Application Site ddlApplicationSite.DataSource = aCategorysMN.ListCategorys(string.Empty, string.Empty, CatTypeCode); ddlApplicationSite.DataValueField = "CatCode"; ddlApplicationSite.DataTextField = "CatName"; ddlApplicationSite.DataBind(); aListItem = ddlApplicationSite.Items.FindByValue("C-00005"); if (aListItem != null) { ddlApplicationSite.SelectedValue = "C-00005"; } //CatTypeCode = "CT-00004"; //Doc Type //ddlDocType.DataSource = aCategorysMN.ListCategorys(string.Empty, string.Empty, CatTypeCode); //ddlDocType.DataValueField = "CatCode"; //ddlDocType.DataTextField = "CatName"; //ddlDocType.DataBind(); //aListItem = ddlDocType.Items.FindByValue("C-00006"); //if (aListItem != null) //{ // ddlDocType.SelectedValue = "C-00006"; //} UserInDepartmentMN aUserInDepartmentMN = new UserInDepartmentMN(); #endregion #region if (String.IsNullOrEmpty(CodeDocument)) { #region ddlDepartment.DataSource = aUserInDepartmentMN.ListDepartmentByUserName(LoginSession.UserName()); ddlDepartment.DataValueField = "Department"; ddlDepartment.DataTextField = "NameDepartment"; ddlDepartment.DataBind(); txtApplicationName.Text = LoginSession.FullName(); txtApplicationNO.Text = string.Empty; txtApplicationDate.Text = DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss"); #endregion } else { #region RegisterCodeSecurityMN aRegisterCodeDocumentMN = new RegisterCodeSecurityMN(); DataTable aData = aRegisterCodeDocumentMN.ListRegisterCodeDocument(CodeDocument, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, Convert.ToDateTime("1900-01-01"), Convert.ToDateTime("1900-01-01")); if (aData.Rows.Count > 0) { ddlDepartment.DataSource = aUserInDepartmentMN.ListDepartmentByUserName(Convert.ToString(aData.Rows[0]["CreatedBy"])); ddlDepartment.DataValueField = "Department"; ddlDepartment.DataTextField = "NameDepartment"; ddlDepartment.DataBind(); hidID.Value = Convert.ToString(aData.Rows[0]["ID"]); hidCodeDocument.Value = Convert.ToString(aData.Rows[0]["CodeDocument"]); hidStates.Value = Convert.ToString(aData.Rows[0]["States"]); hidApplicableSite.Value = Convert.ToString(aData.Rows[0]["ApplicableSite"]); //hidApplicableBU.Value = Convert.ToString(aData.Rows[0]["ApplicableBU"]); txtApplicationName.Text = Convert.ToString(aData.Rows[0]["HoTen"]); txtApplicationNO.Text = Convert.ToString(aData.Rows[0]["CodeDocument"]); txtApplicationDate.Text = Convert.ToDateTime(aData.Rows[0]["ApplicationDate"]).ToString("yyyy/MM/dd HH:mm:ss"); ddlApplicationSite.SelectedValue = Convert.ToString(aData.Rows[0]["ApplicationSite"]); txtEffectiveDate.Text = Convert.ToDateTime(aData.Rows[0]["EffectiveDate"]).Year > 1900 ? Convert.ToDateTime(aData.Rows[0]["EffectiveDate"]).ToString("yyyy/MM/dd") : string.Empty; //ddlDocType.SelectedValue = Convert.ToString(aData.Rows[0]["DocumentType"]); txtReasonApplication.Text = Convert.ToString(aData.Rows[0]["ReasonApplication"]); aListItem = ddlDepartment.Items.FindByValue(Convert.ToString(aData.Rows[0]["Department"])); if (aListItem != null) { ddlDepartment.SelectedValue = Convert.ToString(aData.Rows[0]["Department"]); } } #endregion } #endregion } } catch (Exception ex) { ex.ToString(); } }