public bool sqlExecuteNonQuery(string sql, bool result_message_show, Model.SettingClass settingClass)
{
try
{
conn = DBUtils.GetLocalPLCConnection(settingClass.OfflineServer, "ERPSOFT", settingClass.userOffline, settingClass.password);
conn.Open();
SqlCommand cmd = new SqlCommand(sql, conn);
int response = cmd.ExecuteNonQuery();
if (response >= 1)
{
if (result_message_show)
{
System.Windows.MessageBox.Show("Successful!", "Database Responce");
}
conn.Close();
return(true);
}
else
{
SystemLog.Output(SystemLog.MSG_TYPE.Err, "Database Responce", "");
// MessageBox.Show("Not successful!", "Database Responce", MessageBoxButtons.OK, MessageBoxIcon.Warning);
conn.Close();
return(false);
}
}
catch (Exception ex)
{
//MessageBox.Show("Not successful!" + System.Environment.NewLine + ex.Message
// , "Database Responce", MessageBoxButtons.OK, MessageBoxIcon.Warning);
SystemLog.Output(SystemLog.MSG_TYPE.Err, "Database Responce", ex.Message);
conn.Close();
return(false);
}
}
public static SqlConnection GetDBConnection(Model.SettingClass settingClass)
{
//string datasource = @"FS-35686\SQLEXPRESS";
//string database = "ERPSOFT";
//string username = "******";
//string password = "******";
string datasource = "";
string database = "";
string username = "";
string password = "";
datasource = settingClass.OfflineServer == null? "172.16.0.12": settingClass.OfflineServer;
database = "ERPSOFT";
username = settingClass.userOffline == null? "ERPUSER" : settingClass.userOffline;
password = settingClass.password == null ?"12345": settingClass.password;
//string datasource = @"172.16.1.222\LOCALSQL";
//string database = "MQCMES";
//string username = "******";
//string password = "******";
return(DBSQLServerUtils.GetDBConnection(datasource, database, username, password));
}
public void sqlDataAdapterFillDatatable(string sql, ref DataTable dt, Model.SettingClass settingClass)
{
try
{
conn = DBUtils.GetLocalPLCConnection(settingClass.OfflineServer, "ERPSOFT", settingClass.userOffline, settingClass.password);
SqlCommand cmd = new SqlCommand();
SqlDataAdapter adapter = new SqlDataAdapter();
{
cmd.CommandText = sql;
cmd.Connection = conn;
adapter.SelectCommand = cmd;
adapter.Fill(dt);
}
}
catch (Exception ex)
{
SystemLog.Output(SystemLog.MSG_TYPE.Err, "Database Responce", ex.Message);
// MessageBox.Show(ex.Message, "Database Responce", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
public SqlConnection conn = new SqlConnection(); //get from user database
public string sqlExecuteScalarString(string sql, Model.SettingClass settingClass)
{
String outstring;
try
{
conn = DBUtils.GetLocalPLCConnection(settingClass.OfflineServer, "ERPSOFT", settingClass.userOffline, settingClass.password);
SqlCommand cmd = new SqlCommand(sql, conn);
conn.Open();
outstring = cmd.ExecuteScalar().ToString();
conn.Close();
return(outstring);
}
catch (Exception ex)
{
// MessageBox.Show(ex.Message, "Database Responce", MessageBoxButtons.OK, MessageBoxIcon.Warning);
SystemLog.Output(SystemLog.MSG_TYPE.Err, "Database Responce", ex.Message);
return(String.Empty);
}
}
