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