public async static void LoadUserPermission(string function_id, TextEdit txtID, SimpleButton btnSaveClose, SimpleButton btnSaveInsert, bool isDuplicate = false) { iPOS.DRO.Systems.SYS_tblPermissionDRO permission = new iPOS.DRO.Systems.SYS_tblPermissionDRO(); permission = await iPOS.BUS.Systems.SYS_tblPermissionBUS.GetPermissionItem(CommonEngine.userInfo.UserID, ConfigEngine.Language, function_id); if (permission.ResponseItem.IsError) { CommonEngine.ShowHTTPErrorMessage(permission.ResponseItem); btnSaveClose.Enabled = btnSaveInsert.Enabled = false; return; } if (permission.PermissionItem != null) { if (string.IsNullOrEmpty(txtID.Text) || isDuplicate) { btnSaveClose.Enabled = btnSaveInsert.Enabled = permission.PermissionItem.AllowInsert; } else { btnSaveClose.Enabled = permission.PermissionItem.AllowUpdate; btnSaveInsert.Enabled = permission.PermissionItem.AllowInsert & permission.PermissionItem.AllowUpdate; } } else { btnSaveClose.Enabled = btnSaveInsert.Enabled = false; } }
public static string SaveExportCustom(Excel.Workbook Book, string report_name, bool isXlsFormat = false) { object Missing = System.Reflection.Missing.Value; string str = ""; try { report_name = report_name.Remove(report_name.LastIndexOf('.')); SaveFileDialog sDialog = new SaveFileDialog(); str = string.Format(@"{0}_{1}_{2}", report_name, DateTime.Now.ToString("yyyy_MM_dd_HH_mm_ss"), DateTime.Now.Ticks); sDialog.Filter = isXlsFormat ? "Microsoft Excel (*.xls)|*.xls" : "Microsoft Excel 2007 (*.xlsx)|*.xlsx"; sDialog.Title = LanguageEngine.GetMessageCaption("000007", ConfigEngine.Language); sDialog.InitialDirectory = Temp; sDialog.FileName = str; if (sDialog.ShowDialog() == DialogResult.OK) { str = sDialog.FileName; Book.SaveAs(str, Microsoft.Office.Interop.Excel.XlFileFormat.xlWorkbookDefault, Missing, Missing, Missing, Missing, Microsoft.Office.Interop.Excel.XlSaveAsAccessMode.xlExclusive, Missing, Missing, Missing, Missing, Missing); CommonEngine.ShowMessage(ConfigEngine.Language.Equals("vi") ? "Tải tập tin mẫu thành công!" : "Download template success!", MessageType.Success); } } catch (Exception ex) { logger.Error(ex); } return(str); }
private async Task <bool> CheckLogin() { if (string.IsNullOrEmpty(txtUsername.Text)) { CommonEngine.ShowMessage(LanguageEngine.GetMessageCaption("000011", ConfigEngine.Language), MessageType.Error); txtUsername.Focus(); return(false); } if (string.IsNullOrEmpty(txtPassword.Text)) { CommonEngine.ShowMessage(LanguageEngine.GetMessageCaption("000011", ConfigEngine.Language), MessageType.Error); txtPassword.Focus(); return(false); } try { SYS_tblUserDRO user = await UserBUS.CheckLogin(txtUsername.Text.Trim(), EncryptEngine.Encrypt(txtPassword.Text.Trim()), ConfigEngine.Language); if (CommonEngine.CheckValidResponseItem(user.ResponseItem)) { if (user.UserItem != null) { CommonEngine.userInfo = user.UserItem; string temp = user.UserItem.Username.Substring(user.UserItem.Username.IndexOf("|") + 1); user.UserItem.Username = user.UserItem.Username.Replace("|" + temp, ""); CommonEngine.SystemDateTime = Convert.ToDateTime(temp); if (user.UserItem.Locked) { CommonEngine.ShowMessage(LanguageEngine.GetMessageCaption("000010", ConfigEngine.Language).Replace("$UserName$", user.UserItem.Username), MessageType.Error); txtUsername.Focus(); return(false); } } else { CommonEngine.ShowMessage(LanguageEngine.GetMessageCaption("000009", ConfigEngine.Language), MessageType.Error); txtUsername.Focus(); return(false); } } else { return(false); } } catch (Exception ex) { CommonEngine.ShowExceptionMessage(ex); txtUsername.Focus(); return(false); } return(true); }
private async void btnLogin_Click(object sender, EventArgs e) { if (await CheckLogin()) { string username = (chkRemember.Checked) ? EncryptEngine.Encrypt(txtUsername.Text.Trim()) : ""; string password = (chkRemember.Checked) ? EncryptEngine.Encrypt(txtPassword.Text.Trim()) : ""; IOEngine.Write("Initialize", "Username", username); IOEngine.Write("Initialize", "Password", password); ResponseItem result = await SYS_tblActionLogBUS.InsertUpdateLog(new SYS_tblActionLogDTO { ID = string.Empty, ActionVN = "Đăng Nhập", ActionEN = "Login", ActionTime = DateTime.Now, FunctionID = string.Empty, FunctionNameVN = "Đăng Nhập", FunctionNameEN = "Login", DescriptionEN = string.Format("Account '{0}' has logined to system at {1}.", txtUsername.Text, DateTime.Now), DescriptionVN = string.Format("Tài khoản '{0}' vừa đăng nhập vào hệ thống vào lúc {1}.", txtUsername.Text, DateTime.Now), FullName = CommonEngine.userInfo.FullName, Activity = "Insert", UserID = CommonEngine.userInfo.UserID, LanguageID = ConfigEngine.Language }); if (result.IsError) { CommonEngine.ShowHTTPErrorMessage(result); } else { if (!string.IsNullOrEmpty(result.Message)) { CommonEngine.ShowMessage(result.Message, 0); return; } this.DialogResult = DialogResult.OK; } } }
public async static void LoadUserPermission(string function_id, BarLargeButtonItem btnDelete, BarLargeButtonItem btnPrint, BarLargeButtonItem btnImport, BarLargeButtonItem btnExport) { iPOS.DRO.Systems.SYS_tblPermissionDRO permission = new iPOS.DRO.Systems.SYS_tblPermissionDRO(); permission = await iPOS.BUS.Systems.SYS_tblPermissionBUS.GetPermissionItem(CommonEngine.userInfo.UserID, ConfigEngine.Language, function_id); if (permission.ResponseItem.IsError) { CommonEngine.ShowHTTPErrorMessage(permission.ResponseItem); btnDelete.Enabled = btnPrint.Enabled = btnImport.Enabled = btnExport.Enabled = false; return; } if (permission.PermissionItem != null) { btnDelete.Enabled = permission.PermissionItem.AllowDelete; btnPrint.Enabled = permission.PermissionItem.AllowPrint; btnImport.Enabled = permission.PermissionItem.AllowImport; btnExport.Enabled = permission.PermissionItem.AllowExport; } else { btnDelete.Enabled = btnPrint.Enabled = btnImport.Enabled = btnExport.Enabled = false; } }
public async static void GetFileWithReportCaption(string username, string language_id, string template, string function_id, string module_id) { Excel.Application App = null; Excel.Workbook Book = null; Excel.Worksheet Sheet = null; Excel.Range Range = null; object Missing = System.Reflection.Missing.Value; string strFilePath = ""; try { App = new Excel.Application(); Book = App.Workbooks.Open(string.Format(@"{0}\{1}\{2}", Temp, module_id, template)); Sheet = (Excel.Worksheet)Book.Worksheets[1]; Range = Sheet.UsedRange; int rowCount = Range.Rows.Count; int colCount = Range.Columns.Count; SYS_tblReportCaptionDRO captionList = new SYS_tblReportCaptionDRO(); captionList = await iPOS.BUS.Systems.SYS_tblReportCaptionBUS.GetReportCaption(username, language_id, function_id, true); if (!CommonEngine.CheckValidResponseItem(captionList.ResponseItem)) { return; } int index = 1; if (captionList != null && captionList.ReportCaptionList.Count > 0) { Excel.Range cellRange; SYS_tblReportCaptionDRO comboItems; for (int i = 0; i < captionList.ReportCaptionList.Count; i++) { cellRange = Sheet.Cells.Find("$" + captionList.ReportCaptionList[i].ControlID + "$", Missing, Excel.XlFindLookIn.xlValues, Excel.XlLookAt.xlPart, Excel.XlSearchOrder.xlByRows, Excel.XlSearchDirection.xlNext, false, Missing, false); if (cellRange != null && cellRange.Cells.Count > 0) { cellRange.Replace("$" + captionList.ReportCaptionList[i].ControlID + "$", captionList.ReportCaptionList[i].Caption, Excel.XlLookAt.xlWhole, Excel.XlSearchOrder.xlByColumns, true, Missing, Missing, Missing); int colIndex = cellRange.Cells.Column; int rowIndex = cellRange.Cells.Row; if (captionList.ReportCaptionList[i].IsComment) { cellRange.AddComment(captionList.ReportCaptionList[i].Comment); } if (captionList.ReportCaptionList[i].IsRequire) { cellRange.Font.Bold = true; cellRange.Font.Color = Color.Red; } if (captionList.ReportCaptionList[i].IsList) { comboItems = new SYS_tblReportCaptionDRO(); comboItems = await iPOS.BUS.Systems.SYS_tblReportCaptionBUS.GetComboDynamicList(username, language_id, "", captionList.ReportCaptionList[i].TableName, "Code"); index++; if (comboItems != null && comboItems.ComboDynamicList.Count > 0) { Excel.Worksheet SheetData = null; if (index > Book.Worksheets.Count) { SheetData = (Excel.Worksheet)Book.Worksheets.Add(Missing, index, Missing, Missing); } else { SheetData = (Excel.Worksheet)Book.Worksheets[index]; } SheetData.Name = captionList.ReportCaptionList[i].TableName; Excel.Range RangeData = SheetData.Range[SheetData.Cells[1, 1], SheetData.Cells[1, 2]]; RangeData.Interior.Color = System.Drawing.Color.Yellow; RangeData.Font.Bold = true; RangeData.Font.Color = System.Drawing.Color.Red; SheetData.Cells[1, 1] = "Code"; SheetData.Cells[1, 2] = "Name"; for (int k = 0; k < comboItems.ComboDynamicList.Count; k++) { SheetData.Cells[k + 2, 1] = comboItems.ComboDynamicList[k].Code; SheetData.Cells[k + 2, 2] = comboItems.ComboDynamicList[k].Name; } RangeData = SheetData.Range[SheetData.Cells[1, 1], SheetData.Cells[comboItems.ComboDynamicList.Count + 1, 2]]; RangeData.Cells.HorizontalAlignment = Excel.XlHAlign.xlHAlignLeft; Excel.Borders BorderData = RangeData.Borders; BorderData.LineStyle = Excel.XlLineStyle.xlContinuous; BorderData.Weight = 2d; RangeData.Columns.AutoFit(); RangeData = Sheet.Range[Sheet.Cells[3, colIndex], Sheet.Cells[rowCount, colIndex]]; RangeData.Validation.Add(Excel.XlDVType.xlValidateList, Excel.XlDVAlertStyle.xlValidAlertStop, Excel.XlFormatConditionOperator.xlBetween, string.Format("={0}!$A$2:$A${1}", captionList.ReportCaptionList[i].TableName, comboItems.ComboDynamicList.Count + 1), Missing); Range.Cells.HorizontalAlignment = Excel.XlHAlign.xlHAlignLeft; RangeData.Validation.InCellDropdown = true; } } } } } Range.Columns.AutoFit(); strFilePath = SaveExportCustom(Book, template, false); Book.Close(false, Missing, Missing); } catch (Exception ex) { logger.Error(ex); return; } finally { App.Quit(); Marshal.FinalReleaseComObject(Range); Marshal.FinalReleaseComObject(Sheet); Marshal.FinalReleaseComObject(Book); Marshal.FinalReleaseComObject(App); App = null; GC.Collect(); GC.WaitForPendingFinalizers(); System.Diagnostics.Process[] processes = System.Diagnostics.Process.GetProcessesByName("excel"); foreach (System.Diagnostics.Process process in processes) { if (process.MainWindowTitle.Length == 0) { process.Kill(); } } } System.Diagnostics.Process.Start(strFilePath); }