protected void Page_Load(object sender, EventArgs e) { #region string Url = string.Empty; string ToEmail = string.Empty; string BCC = string.Empty; string Status = string.Empty; string Contents = string.Empty; string Title = string.Empty; string UserName = string.Empty; string FullName = string.Empty; string PublishDocument = string.Empty; HistorySendMailMN aHistorySendMailMN = new HistorySendMailMN(); RegisterPublishDocumentMN aRegisterPublishDocumentMN = new RegisterPublishDocumentMN(); DataTable aData = aRegisterPublishDocumentMN.CheckSendMailAuto(); for (int i = 0; i < aData.Rows.Count; i++) { UserName = Convert.ToString(aData.Rows[i]["UserName"]); FullName = Convert.ToString(aData.Rows[i]["HoTen"]); ToEmail = Convert.ToString(aData.Rows[i]["Email"]); PublishDocument = Convert.ToString(aData.Rows[i]["PublishDocument"]); Url = Request.Url.OriginalString; Url = Url.Replace("AutoSendMail", "TransferEdit.aspx"); Url = Url + "?PublishDocument=" + PublishDocument; Utils.ContentSendMail_AutoSend(PublishDocument, Url, FullName, UserName, ref Title, ref Contents); bool bS = Utils.SendMail(ToEmail, BCC, BCC, Title, Contents); Status = bS ? "SUCCESS" : "ERRER"; ToEmail = ToEmail + "___" + UserName; aHistorySendMailMN.InsertHistorySendMail(PublishDocument, ToEmail, BCC, Status, Contents, Title, "System"); } #endregion }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { if (LoginSession.IsLogin()) { if (!LoginSession.IsAdmin()) { if (!LoginSession.IsView("MN-00023")) { Response.Redirect("NoPermitsion.aspx"); } } } else { Response.Redirect("/Account/Login.aspx?Url=" + Request.Url.PathAndQuery); } hidUserName.Value = LoginSession.UserName(); #region UserInDepartmentMN aUserInDepartmentMN = new UserInDepartmentMN(); 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")); #endregion #region hidStatus.Value = Convert.ToString(Request.QueryString["Type"]); string EditDocument = Convert.ToString(Request.QueryString["EditDocument"]); string PublishDocument = Convert.ToString(Request.QueryString["PublishDocument"]); RegisterPublishDocumentMN aRegisterPublishDocumentMN = new RegisterPublishDocumentMN(); RegisterEditDocumentMN aRegisterEditDocumentMN = new RegisterEditDocumentMN(); if (!String.IsNullOrEmpty(PublishDocument)) { #region ddlDepartment.Items.Clear(); ddlDepartment.DataSource = aUserInDepartmentMN.ListDepartmentByUserName(LoginSession.UserName()); ddlDepartment.DataValueField = "Department"; ddlDepartment.DataTextField = "NameDepartment"; ddlDepartment.DataBind(); 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")); txtEffectiveDate.Text = string.Empty; txtApplicationDate.Text = DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss"); if (aData.Rows.Count > 0) { txtApplicationName.Text = LoginSession.FullName(); hidPublishDocument.Value = PublishDocument; hidCodeDocument.Value = Convert.ToString(aData.Rows[0]["CodeDocument"]); txtApplicationNO.Text = Convert.ToString(aData.Rows[0]["PublishDocument"]); ddlApplicationSite.Text = Convert.ToString(aData.Rows[0]["ApplicationSite"]); txtDocNO.Text = Convert.ToString(aData.Rows[0]["DocumentNo"]); DataTable aTemp = aRegisterEditDocumentMN.GetNextAlphabet(Convert.ToString(aData.Rows[0]["Rev"]).Trim()); txtREV.Text = aTemp.Rows.Count > 0 ? Convert.ToString(aTemp.Rows[0]["Word"]).Trim() : "Hết phiên bản"; 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"]); 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 } else if (!String.IsNullOrEmpty(EditDocument)) { #region DataTable aData = aRegisterEditDocumentMN.ListRegisterEditDocument(EditDocument, 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"]); hidEditDocument.Value = EditDocument; hidPublishDocument.Value = Convert.ToString(aData.Rows[0]["PublishDocument"]); hidStates.Value = Convert.ToString(aData.Rows[0]["States"]); txtApplicationNO.Text = Convert.ToString(aData.Rows[0]["EditDocument"]); hidCodeDocument.Value = Convert.ToString(aData.Rows[0]["CodeDocument"]); 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 } else { Response.Redirect("Default.aspx"); } #endregion } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { if (LoginSession.IsLogin()) { if (!LoginSession.IsAdmin()) { if (!LoginSession.IsView("MN-00016")) { Response.Redirect("NoPermitsion.aspx"); } } } else { Response.Redirect("/Account/Login.aspx?Url=" + Request.Url.PathAndQuery); } hidUserName.Value = LoginSession.UserName(); #region UsersMN aUsersMN = new UsersMN(); 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(); //CatTypeCode = "CT-00004"; //Doc Type //ddlDocType.DataSource = aCategorysMN.ListCategorys(string.Empty, string.Empty, CatTypeCode); //ddlDocType.DataValueField = "CatCode"; //ddlDocType.DataTextField = "CatName"; //ddlDocType.DataBind(); #endregion #region string PublishDocument = Convert.ToString(Request.QueryString["PublishDocument"]); string ObsoletedDocument = Convert.ToString(Request.QueryString["ObsoletedDocument"]); if (!String.IsNullOrEmpty(PublishDocument)) { #region RegisterPublishDocumentMN aRegisterPublishDocumentMN = new RegisterPublishDocumentMN(); txtApplicationName.Text = LoginSession.FullName(); txtApplicationNO.Text = string.Empty; txtApplicationDate.Text = DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss"); hidPublishDocument.Value = PublishDocument; DataTable aData = aRegisterPublishDocumentMN.ListRegisterPublishDocument(PublishDocument, string.Empty, "C26", 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) { ddlApplicationSite.Text = Convert.ToString(aData.Rows[0]["ApplicationSite"]); //hidApplicableSite.Value = Convert.ToString(aData.Rows[0]["ApplicableSite"]); txtDocNO.Text = Convert.ToString(aData.Rows[0]["DocumentNo"]); txtREV.Text = Convert.ToString(aData.Rows[0]["Rev"]); txtDocName.Text = Convert.ToString(aData.Rows[0]["DocumentName"]); txtReleaseDate.Text = Convert.ToString(aData.Rows[0]["EffectiveDate_Text"]); //ddlDocType.Text = Convert.ToString(aData.Rows[0]["DocumentType"]); //hidApplicableBU.Value = Convert.ToString(aData.Rows[0]["ApplicableBU"]); //hidDepartmentCheck.Value = Convert.ToString(aData.Rows[0]["DepartmentCheck"]); DataTable aTemp = new DataTable(); aTemp = aCategorysMN.ListCategorys(Convert.ToString(aData.Rows[0]["Department"]), string.Empty, string.Empty); txtApplicationDep.Text = aTemp.Rows.Count > 0 ? Convert.ToString(aTemp.Rows[0]["CatName"]) : string.Empty; txtDepartment.Text = aTemp.Rows.Count > 0 ? Convert.ToString(aTemp.Rows[0]["CatName"]) : string.Empty; aTemp = aUsersMN.GetManagerCurrent(); txtManager.Text = aTemp.Rows.Count > 0 ? Convert.ToString(aTemp.Rows[0]["HoTen"]) : string.Empty; } #endregion } else { if (!String.IsNullOrEmpty(ObsoletedDocument)) { #region ApplicationObsoletedDocumentMN aApplicationObsoletedDocumentMN = new ApplicationObsoletedDocumentMN(); DataTable aData = aApplicationObsoletedDocumentMN.ListApplicationObsoletedDocument(ObsoletedDocument, 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) { txtApplicationName.Text = Convert.ToString(aData.Rows[0]["HoTen"]); hidID.Value = Convert.ToString(aData.Rows[0]["ID"]); hidObsoletedDocument.Value = ObsoletedDocument; hidStates.Value = Convert.ToString(aData.Rows[0]["States"]); txtApplicationNO.Text = Convert.ToString(aData.Rows[0]["ObsoletedDocument"]); hidPublishDocument.Value = Convert.ToString(aData.Rows[0]["PublishDocument"]); txtEffectiveDate.Text = Convert.ToDateTime(aData.Rows[0]["EffectiveDate"]).Year > 1900 ? Convert.ToDateTime(aData.Rows[0]["EffectiveDate"]).ToString("yyyy/MM/dd") : string.Empty; txtApplicationDate.Text = Convert.ToString(aData.Rows[0]["ApplicationDate_Text"]); ddlApplicationSite.Text = Convert.ToString(aData.Rows[0]["ApplicationSite"]); //hidApplicableSite.Value = Convert.ToString(aData.Rows[0]["ApplicableSite"]); txtDocNO.Text = Convert.ToString(aData.Rows[0]["DocumentNo"]); txtREV.Text = Convert.ToString(aData.Rows[0]["Rev"]); txtDocName.Text = Convert.ToString(aData.Rows[0]["DocumentName"]); txtReleaseDate.Text = Convert.ToString(aData.Rows[0]["EffectiveDate_Text"]); //ddlDocType.Text = Convert.ToString(aData.Rows[0]["DocumentType"]); //hidApplicableBU.Value = Convert.ToString(aData.Rows[0]["ApplicableBU"]); //hidDepartmentCheck.Value = Convert.ToString(aData.Rows[0]["DepartmentCheck"]); DataTable aTemp = new DataTable(); aTemp = aCategorysMN.ListCategorys(Convert.ToString(aData.Rows[0]["Department"]), string.Empty, string.Empty); txtApplicationDep.Text = aTemp.Rows.Count > 0 ? Convert.ToString(aTemp.Rows[0]["CatName"]) : string.Empty; txtDepartment.Text = aTemp.Rows.Count > 0 ? Convert.ToString(aTemp.Rows[0]["CatName"]) : string.Empty; aTemp = aUsersMN.GetManagerCurrent(); txtManager.Text = aTemp.Rows.Count > 0 ? Convert.ToString(aTemp.Rows[0]["HoTen"]) : string.Empty; txtReasonObsoleted.Text = Convert.ToString(aData.Rows[0]["ReasonObsoleted"]); } #endregion } } #endregion } }