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();
}
}
}
