public bool UpdateByNonQuery(string strNonQuery, bool showMess) { if (!multiStatement) { if (!OpenConnection()) { return(false); } } try { SqlCommand sCmd = new SqlCommand(strNonQuery, connection); sCmd.Transaction = strMain; sCmd.CommandTimeout = _timeOut; sCmd.ExecuteNonQuery(); if (!multiStatement) { strMain.Commit(); } if (strNonQuery.ToLower().Contains("create table")) { DesignLog.SqlError(strNonQuery); } if (strNonQuery.ToLower().Contains("alter table")) { DesignLog.SqlError(strNonQuery); } if (strNonQuery.ToLower().Contains("hdb1")) { DesignLog.SqlError(strNonQuery); } LogFile.LogTruyXuatDL(strNonQuery); return(true); } catch (SqlException se) { if (!multiStatement) { strMain.Rollback(); } hasErrors = true; //if (showMess) LogFile.SqlError(strNonQuery, se, showMess); return(false); } finally { if (!multiStatement) { CloseConnection(); } } }
public Main(DataRow drUser, DataRow drPackage) { InitializeComponent(); sysPackageID = drPackage["sysPackageID"].ToString(); dbName = drPackage["DbName"].ToString(); _sysMenu.SynchronizeMenuWithPlugins(pm); InitializeMenu(); if (sysPackageID == "5") { DesignLog.SqlError(DateTime.Now.ToLongTimeString()); } barManagerMain.Items.Add(barSubItemHelp); barMainMenu.LinksPersistInfo.Add(new DevExpress.XtraBars.LinkPersistInfo(barSubItemHelp)); barManagerMain.ItemClick += new ItemClickEventHandler(barManagerMain_ItemClick); if (Config.GetValue("Language").ToString() == "1") { DevLocalizer.Translate(this); TranslateForMenu(); } this.Disposed += new EventHandler(Main_Disposed); InitializeForm(drUser, drPackage); // bool supported = false; //string RegSupport = Registry.GetValue(H_KEY, "SupportOnline", "false").ToString(); //if (RegSupport != string.Empty) // supported = Boolean.Parse(RegSupport); //if (DateTime.Today.DayOfWeek == DayOfWeek.Monday && !supported) //{ //Startup frm = new Startup(); //frm.MdiParent = this; //frm.Show(); // Registry.SetValue(H_KEY, "SupportOnline", true); //} //else // if (DateTime.Today.DayOfWeek != DayOfWeek.Monday && supported) // Registry.SetValue(H_KEY, "SupportOnline", false); }
public bool UpdateData(string sql, string[] paraNames, object[] paraValues, SqlDbType[] paraTypes) { if (!multiStatement) { if (!OpenConnection()) { return(false); } } try { SqlCommand sqlcm = new SqlCommand(); sqlcm.CommandText = sql; sqlcm.CommandType = CommandType.Text; sqlcm.CommandTimeout = _timeOut; sqlcm.Connection = connection; sqlcm.Transaction = strMain; if (paraNames != null) { for (int i = 0; i < paraNames.Length; i++) { SqlParameter sqlpara; sqlpara = new SqlParameter(paraNames[i], paraValues[i]); sqlpara.SqlDbType = paraTypes[i]; sqlcm.Parameters.Add(sqlpara); } } sqlcm.ExecuteNonQuery(); if (sql.ToLower().Contains("insert into systable")) { DesignLog.SqlError(sql + paraValues[0].ToString()); } if (sql.ToLower().Contains("insert into sysfield")) { DesignLog.SqlError(sql + paraValues[0].ToString()); } if (sql.ToLower().Contains("update systable")) { DesignLog.SqlError(sql + paraValues[0].ToString()); } if (sql.ToLower().Contains("update sysfield")) { DesignLog.SqlError(sql + paraValues[0].ToString()); } if (!multiStatement) { strMain.Commit(); } LogFile.LogTruyXuatDL(sql + "/n" + paraNames.ToString() + "/n" + paraValues.ToString()); return(true); } catch (SqlException se) { if (!multiStatement) { strMain.Rollback(); } hasErrors = true; string sql1 = sql; foreach (object o in paraValues) { sql1 += "-" + o.ToString(); } LogFile.SqlError(sql1, se); return(false); } finally { if (!multiStatement) { CloseConnection(); } } }