/// <summary> /// phuc thuc phuc hoi du lieu , voi duong dan mac dinh se duoc tai cho thu muc cua chuong trinh /// </summary> /// <param name="p_FileName"></param> /// <param name="p_confItem"></param> public static void CreateRestore(string p_FileName, COMMAND.Config.ConfigItem p_confItem, object p_objCall) { try { objFormCall = (Form)p_objCall; objFormCall.Enabled = false; objFormCall.Controls["groupControl1"].Controls["lblStatus"].Text = COMMAND.MessageUtils.Message.GetMessageById("BKRS_E_015"); string l_PathApp = Application.StartupPath + "\\App_Data"; if (!System.IO.Directory.Exists(l_PathApp)) { System.IO.Directory.CreateDirectory(l_PathApp); } //khai bao thiet bi du lieu phuc hoi BackupDeviceItem deviceItem = new BackupDeviceItem(p_FileName, DeviceType.File); //khai bao doi tuong server ServerConnection connection = new ServerConnection(p_confItem.StrServerName, p_confItem.StrUserName, p_confItem.StrPassword); Server sqlServer = new Server(connection); //khai bao doi tuong database Database db = sqlServer.Databases[p_confItem.StrDBName]; if (db != null) { sqlServer.KillAllProcesses(p_confItem.StrDBName); } //khai bao doi tuong phuc hoi du lieu Restore sqlRestore = new Restore(); sqlRestore.Devices.Add(deviceItem); sqlRestore.Database = p_confItem.StrDBName; sqlRestore.Action = RestoreActionType.Database; String dataFileLocation = l_PathApp + "\\" + p_confItem.StrDBName + ".mdf"; String logFileLocation = l_PathApp + "\\" + p_confItem.StrDBName + "_Log.ldf"; RelocateFile rf = new RelocateFile(p_confItem.StrDBName, dataFileLocation); sqlRestore.RelocateFiles.Add(new RelocateFile(p_confItem.StrDBName, dataFileLocation)); sqlRestore.RelocateFiles.Add(new RelocateFile(p_confItem.StrDBName + "_log", logFileLocation)); sqlRestore.ReplaceDatabase = true; sqlRestore.Complete += new ServerMessageEventHandler(sqlRestore_Complete); sqlRestore.PercentCompleteNotification = 10; sqlRestore.PercentComplete += new PercentCompleteEventHandler(sqlRestore_PercentComplete); objFormCall.Controls["groupControl1"].Controls["lblStatus"].Text = COMMAND.MessageUtils.Message.GetMessageById("BKRS_E_014"); sqlRestore.SqlRestore(sqlServer); db = sqlServer.Databases[p_confItem.StrDBName]; db.SetOnline(); sqlServer.Refresh(); } catch (Exception ex) { if (objFormCall != null) { objFormCall.Controls["groupControl1"].Controls["lblStatus"].Text = COMMAND.MessageUtils.Message.GetMessageById("BKRS_E_010"); objFormCall.Enabled = true; LogUtils.Logger.AppLog.Debug(objFormCall.Name, p_confItem.Login_UserName, objFormCall.Controls["groupControl1"].Controls["lblStatus"].Text, ex); } } }
public static bool LoginUser(COMMAND.Config.ConfigItem _confItem, string strUserName, string strPassword) { COMMAND.SQL.AccessSQL _sql = new SQL.AccessSQL(_confItem); string[] arrParaName = new string[] { "@Name", "@Password" }; object[] arrParaValue = new string[] { strUserName, strPassword }; DataTable tb = _sql.GetDataByStoredProcedure("Usp_Login", arrParaName, arrParaValue); if (tb.Rows.Count > 0) { return(true); } return(false); }
/// <summary> /// Phuong thuc thuc hien backup du lieu /// </summary> /// <param name="p_FileName"></param> /// <param name="p_confItem"></param> /// <param name="p_objCall"></param> public static void CreateBackUp(string p_FileName, COMMAND.Config.ConfigItem p_confItem, object p_objCall) { try { objFormCall = (Form)p_objCall; objFormCall.Enabled = false; objFormCall.Controls["groupControl1"].Controls["lblStatus"].Text = COMMAND.MessageUtils.Message.GetMessageById("BKRS_E_005");// "Dang khoi dong qua trinh sao luu du lieu"; //WriteToLogAndConsole("Backup the {0} database!", databaseName); //khai bao thong tin device backup BackupDeviceItem deviceItem = new BackupDeviceItem(p_FileName, DeviceType.File); //thiet lap thong tin sql backup Backup sqlBackup = new Backup(); sqlBackup.Action = BackupActionType.Database; sqlBackup.Database = p_confItem.StrDBName; sqlBackup.BackupSetDescription = "ArchiveDataBase:" + DateTime.Now.ToShortDateString(); sqlBackup.BackupSetName = "Archive"; sqlBackup.Initialize = true; sqlBackup.Checksum = true; sqlBackup.ContinueAfterError = true; sqlBackup.Devices.Add(deviceItem); sqlBackup.Incremental = false; sqlBackup.ExpirationDate = DateTime.Now.AddDays(3); sqlBackup.LogTruncation = BackupTruncateLogType.Truncate; sqlBackup.FormatMedia = false; sqlBackup.PercentComplete += new PercentCompleteEventHandler(sqlBackup_PercentComplete); sqlBackup.Complete += new ServerMessageEventHandler(sqlBackup_Complete); //thiet lap thong tin server va connection den server ServerConnection connection = new ServerConnection(p_confItem.StrServerName, p_confItem.StrUserID, p_confItem.StrPassword); Server sqlServer = new Server(connection); //Database db = sqlServer.Databases[p_confItem.StrDBName]; objFormCall.Controls["groupControl1"].Controls["lblStatus"].Text = COMMAND.MessageUtils.Message.GetMessageById("BKRS_E_004"); sqlBackup.SqlBackup(sqlServer); } catch (Exception ex) { if (objFormCall != null) { objFormCall.Controls["groupControl1"].Controls["lblStatus"].Text = COMMAND.MessageUtils.Message.GetMessageById("BKRS_E_000"); objFormCall.Enabled = true; LogUtils.Logger.AppLog.Debug(objFormCall.Name, p_confItem.Login_UserName, objFormCall.Controls["groupControl1"].Controls["lblStatus"].Text, ex); } } }
public static bool ketchuyen(COMMAND.Config.ConfigItem _confItem) { try { string[] arrParaName = new string[] { "@Crt_By" }; object[] arrParaValue = new object[] { _confItem.Login_UserName }; COREBASE.COMMAND.SQL.AccessSQL _sql = new COREBASE.COMMAND.SQL.AccessSQL(_confItem); if (_sql.ExecuteNonQuery("usp_vpp_ketchuyenkho", arrParaName, arrParaValue) > 0) { return(true); } else { return(false); } } catch (Exception ex) { //TODO: Ghi log cho nay. throw ex; } }
public static DataTable ListWareHouse(COMMAND.Config.ConfigItem _confItem) { COMMAND.SQL.AccessSQL _sql = new SQL.AccessSQL(_confItem); return(_sql.GetDataByStoredProcedure("USP_SEL_WARE_HOUSE")); }
public static DataTable ListUser(COMMAND.Config.ConfigItem _confItem) { COMMAND.SQL.AccessSQL _sql = new SQL.AccessSQL(_confItem); return(_sql.GetDataByStoredProcedure("USP_SEL_USER")); }
/// <summary> /// Luu thong tin cau hinh xuong file config /// </summary> /// <param name="configItem"></param> protected void UpdateConfigFileInfo(COMMAND.Config.ConfigItem configItem) { COMMAND.Config.Config _Config = new COMMAND.Config.Config(); _Config.WriteSetting("ActiveKey", configItem.StrActiveKey); _Config.WriteSetting("Serial", configItem.StrSerial); _Config.WriteSetting("AppName", configItem.StrAppName); _Config.WriteSetting("Author", configItem.StrAuthor); _Config.WriteSetting("VersionApp", configItem.StrVersion); //Ngon ngu dang su dung _Config.WriteSetting("CurrLang", configItem.StrCurrLang); //Email _Config.WriteSetting("Email", configItem.StrEmail); //Ten hien thi _Config.WriteSetting("DisplayName", configItem.StrDisplayName); //Server mail dang smtp _Config.WriteSetting("MailServerName", configItem.StrMailServerName); //Port cua server mail _Config.WriteSetting("MailPort", configItem.StrMailPort); //Password cua mail _Config.WriteSetting("MailPass", configItem.StrMailPass); _Config.WriteSetting("UserName", configItem.StrUserName); _Config.WriteSetting("Server", configItem.StrServerName); _Config.WriteSetting("Port", configItem.StrPort); _Config.WriteSetting("DataBase", configItem.StrDBName); _Config.WriteSetting("UserID", configItem.StrUserID); _Config.WriteSetting("Password", configItem.StrPassword); _Config.WriteSetting("Trusted_Connection", configItem.StrTrustedConnection); //Duong dan mac dinh cua log file _Config.WriteSetting("PathLogDefault", configItem.StrPathLog); //Duong dan mac dinh cua file export _Config.WriteSetting("PathExPortDefault", configItem.StrPathExport); //Duong dan mac dinh cua file report bang pdf _Config.WriteSetting("PathReportDefault", configItem.StrReport); //Duong dan mac dinh cua file backup _Config.WriteSetting("PathBackUpDataDefault", configItem.StrPathBackup); _Config.WriteSetting("thousand_separator", configItem.StrThousandSeparator); //D?u th?p phân _Config.WriteSetting("decimal_separator", configItem.StrDecimalSeparator); //dinh dang ngay thang _Config.WriteSetting("DateFormat", configItem.StrDateFormat); //Bat tinh Scroll form cho ung dung hay khong? ==> 1 = Enable; 0 = Disable _Config.WriteSetting("ScrollMDIChild", CnvToString(configItem.BScrollMDIChild)); // Key ma hoa mat khau _Config.WriteSetting("SecurityKey", configItem.StrSecurityKey); ////DefaultPageSettings.Margins.Top //_Config.WriteSetting("DefaultPageSettings.Margins.Top"); ////DefaultPageSettings.Margins.Left //_Config.WriteSetting("DefaultPageSettings.Margins.Left"); ////DefaultPageSettings.Margins.Right //_Config.WriteSetting("DefaultPageSettings.Margins.Right"); ////DefaultPageSettings.Margins.Bottom //_Config.WriteSetting("DefaultPageSettings.Margins.Bottom"); ////add data to center page //_Config.WriteSetting("CenterPartition"); ////fit column to page //_Config.WriteSetting("FitColumnsToPage"); //_Config.WriteSetting("LevelByLevel"); //_Config.WriteSetting("AllowCurrentPage"); //_Config.WriteSetting("AllowPrintToFile"); //_Config.WriteSetting("AllowSelection"); //_Config.WriteSetting("AllowSomePages"); //_Config.WriteSetting("PrintToFile"); //_Config.WriteSetting("ShowHelp"); //_Config.WriteSetting("ShowNetwork"); _Config.WriteSetting("xpdfrc", configItem.Xpdfrc); }