/// <summary> /// Search data from GENERAL_AUT_USERROLE table /// </summary> /// <param name="dt"></param> /// <param name="URoleID"></param> /// <returns></returns> /// <remarks> /// Author: PhatLT. FPTSS. /// Created date: 14/02/2011 /// </remarks> public DataTable Search(DataTable dt, string URoleID) { clsCommon common = new clsCommon(); string strSql = "SELECT UROLE_ID, ROLE_NAME FROM GENERAL_AUT_USERROLE "; StringBuilder sb = new StringBuilder(); if(URoleID != null && URoleID.Length > 0) { sb.Append(string.Format(" UROLE_ID LIKE '{0}' ", common.EncodeKeyword(URoleID))); } if(sb.Length > 0) strSql = strSql + " WHERE " + sb.ToString(); return dao.GetDataTable(dt, strSql); }
/// <summary> /// Check whether data of user is valid /// </summary> /// <returns></returns> /// <remarks> /// Author: PhatLT. FPTSS. /// Created date: 14/02/2011 /// </remarks> public bool ValidateData() { DataRowView rview = (DataRowView)_manager.Current; DataRow row = rview.Row; clsCommon common = new clsCommon(); row.ClearErrors(); ep.SetError(txtConfirmPassword, ""); string userName = row["USERNAME"].ToString(); if(userName.Length == 0) { row.SetColumnError("USERNAME", clsResources.GetMessage("errors.required", lblUserName.Text)); txtUserName.Focus(); return false; } else if(!common.IsLetterAndDigit(userName)) { row.SetColumnError("USERNAME", clsResources.GetMessage("errors.string.specialChar", lblUserName.Text)); txtUserName.Focus(); return false; } if(row["PASSWORD"].ToString().Length == 0) { row.SetColumnError("PASSWORD", clsResources.GetMessage("errors.required", lblPassword.Text)); txtPassword.Focus(); return false; } if(txtConfirmPassword.Text != txtPassword.Text) { ep.SetError(txtConfirmPassword, clsResources.GetMessage("errors.compare.equal", lblConfirmPassword.Text, lblPassword.Text)); return false; } if(row["FIRSTNAME"].ToString().Length == 0) { row.SetColumnError("FIRSTNAME", clsResources.GetMessage("errors.required", lblFirstName.Text)); txtFirstName.Focus(); return false; } if(row["LASTNAME"].ToString().Length == 0) { row.SetColumnError("LASTNAME", clsResources.GetMessage("errors.required", lblLastName.Text)); txtFirstName.Focus(); return false; } if(row["EMAIL"] == DBNull.Value) { row.SetColumnError("EMAIL", clsResources.GetMessage("errors.required", lblEmail.Text)); txtEmail.Focus(); return false; } else if(row["EMAIL"].ToString().Length > 0 && !common.IsEmail(row["EMAIL"].ToString())) { row.SetColumnError("EMAIL", clsResources.GetMessage("errors.email", lblAddress.Text)); txtAddress.Focus(); return false; } if(row["ADDRESS"] == DBNull.Value) { row.SetColumnError("ADDRESS", clsResources.GetMessage("errors.required", lblAddress.Text)); txtAddress.Focus(); return false; } if(row["PHONE"] == DBNull.Value) { row.SetColumnError("PHONE", clsResources.GetMessage("errors.required", lblPhone.Text)); txtPhone.Focus(); return false; } if(txtStartDate.Value > txtEndDate.Value) { row.SetColumnError("END_DATE", clsResources.GetMessage("errors.compare.datetime", lblStartDate.Text, lblEndDate.Text)); txtStartDate.Focus(); return false; } if(row["UROLE_ID"] == DBNull.Value) { row.SetColumnError("UROLE_ID", clsResources.GetMessage("errors.required", lblURoleID.Text)); cboURoleID.Focus(); return false; } if(row["STATUS"] == DBNull.Value) { row.SetColumnError("STATUS", clsResources.GetMessage("errors.required", lblStatus.Text)); cboURoleID.Focus(); return false; } if(row["DESCRIPTION"] == DBNull.Value) { row.SetColumnError("DESCRIPTION", clsResources.GetMessage("errors.required", lblDescription.Text)); txtDescription.Focus(); return false; } if(!bln_IsEdit && bo.Exist(row["USERNAME"].ToString())) { row.SetColumnError("USERNAME", clsResources.GetMessage("errors.userName.exist")); txtUserName.Focus(); return false; } return true; }
/// <summary> /// Search data from /// </summary> /// <param name="dt"></param> /// <param name="userName"></param> /// <param name="firstName"></param> /// <param name="lastName"></param> /// <param name="email"></param> /// <param name="roleID"></param> /// <param name="status"></param> /// <returns></returns> /// <remarks> /// Author: PhatLT. FPTSS. /// Created date: 14/02/2011 /// </remarks> public DataTable Search(DataTable dt, string userName, string firstName, string lastName, string email, string roleID, string status) { clsCommon common = new clsCommon(); string strSql = "SELECT USERNAME, PASSWORD, FIRSTNAME, LASTNAME, EMAIL, ADDRESS, PHONE, START_DATE, END_DATE, PWD_CHG_DATE, STATUS, UROLE_ID, DESCRIPTION FROM GENERAL_AUT_USER"; StringBuilder sb = new StringBuilder(); if(userName != null && userName.Length > 0) { sb.Append(string.Format(" AND USERNAME LIKE '{0}' ", common.EncodeKeyword(userName))); } if(roleID != null && roleID.Length > 0) { sb.Append(string.Format(" AND UROLE_ID = '{0}' ", common.EncodeString(roleID))); } if(status != null && status.Length > 0) { sb.Append(string.Format(" AND STATUS = '{0}' ", common.EncodeString(status))); } if(firstName != null && firstName.Length > 0) { sb.Append(string.Format(" AND FIRSTNAME LIKE '{0}' ", common.EncodeKeyword(firstName))); } if(lastName != null && lastName.Length > 0) { sb.Append(string.Format(" AND LASTNAME LIKE '{0}' ", common.EncodeKeyword(lastName))); } if(email != null && email.Length > 0) { sb.Append(string.Format(" AND EMAIL LIKE '{0}' ", common.EncodeKeyword(email))); } if(sb.Length > 0) strSql = strSql + " WHERE " + sb.ToString(4, sb.Length - 4); return dao.GetDataTable(dt, strSql); }
/// <summary> /// tra ve gia tri tuan: tu tuan hien tai cho den tuan 52 /// </summary> /// <remarks> /// Author: Nguyen Minh Khoa G3 /// Modified: 18-Apr-2011 /// </remarks> /// <returns>intWeeks</returns> public int[] InitWeek() { clsCommon common = new clsCommon(); int intCurrentWeek = common.GetInt(GetWeekSingle()); if(intCurrentWeek < 52) intCurrentWeek += 1; int intArraySize = 53-intCurrentWeek; int[] intWeeks = new int[intArraySize]; int i=0; while(intCurrentWeek<=52) { intWeeks[i] = intCurrentWeek; i++; intCurrentWeek++; } return intWeeks; }
/// <summary> /// Get all customers /// </summary> /// <returns></returns> /// <remarks> /// Author: PhatLT. FPTSS. /// Created date: 14/02/2011 /// </remarks> public DataTable GetCustomers() { clsCommon common = new clsCommon(); string strSql = string.Format("SELECT DISTINCT CUST_CODE, CUST_NAME FROM GENERAL_DISTRIBUTOR_HIERARCHY ORDER BY CUST_CODE"); DataTable dt = dao.GetDataTable(strSql); DataRow row = dt.NewRow(); row[0] = string.Empty; row[1] = string.Empty; dt.Rows.InsertAt(row, 0); return dt; }
/// <summary> /// Export data table to Excel /// </summary> /// <remarks> /// Author: PhatLT. FPTSS. /// Created date: 14/02/2011 /// </remarks> public void ExportToExcel(DataView view, DataGridTableStyle grdStyle, int startRow, int startCol, Excel.Worksheet sheet) { clsCommon common = new clsCommon(); string[] headers = null; int[] indexes = null; common.GetExportInfo(view, grdStyle.GridColumnStyles, ref headers, ref indexes); ExportToExcel(view, headers, indexes, startRow, startCol, sheet); }
/// <summary> /// Export data table to Excel like DataGridTableStyle /// </summary> /// <param name="view"></param> /// <param name="grdStyle"></param> /// <param name="startRow"></param> /// <param name="startCol"></param> /// <remarks> /// Author: PhatLT. FPTSS. /// Created date: 14/02/2011 /// </remarks> public void ExportToExcel(DataView view, DataGridTableStyle grdStyle, int startRow, int startCol) { if(view == null || grdStyle == null) return; clsCommon common = new clsCommon(); string[] headers = null; int[] indexes = null; common.GetExportInfo(view, grdStyle.GridColumnStyles, ref headers, ref indexes); ExportToExcel(view, headers, indexes, startRow, startCol); }