示例#1
0
        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)
                    {
                        SystemLog.Output(SystemLog.MSG_TYPE.Err, "Successful!", "Database Responce");
                    }
                    conn.Close();
                    return(true);
                }
                else
                {
                    SystemLog.Output(SystemLog.MSG_TYPE.Err, "Database Responce", "");

                    conn.Close();
                    return(false);
                }
            }
            catch (Exception ex)
            {
                SystemLog.Output(SystemLog.MSG_TYPE.Err, "Database Responce", ex.Message);
                conn.Close();
                return(false);
            }
        }
示例#2
0
        private void Window_Loaded(object sender, RoutedEventArgs e)
        {
            SettingClass = new Model.SettingClass();
            if (File.Exists(SaveObject.Pathsave))
            {
                SettingClass = (Model.SettingClass)SaveObject.Load_data(SaveObject.Pathsave);
            }

            LoadBackgroundWorker();
            LoadNotification();
        }
示例#3
0
 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);
     }
 }
示例#4
0
        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)
            {
                SystemLog.Output(SystemLog.MSG_TYPE.Err, "Database Responce", ex.Message);
                return(String.Empty);
            }
        }