Example #1
0
        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();
            }
        }