public bool PeriodAutoclavStart() { try { string timeStartAutoclav = PublicMehotd.time_php(); //MessageBox.Show((Convert.ToInt32(timeStartAutoclav) - Varibale.Timer_Autoclav[Dev_no]).ToString() + " X " + timeStartAutoclav); Varibale.Status_Autoclav[Dev_no] = (Convert.ToInt32(timeStartAutoclav) - Varibale.Timer_Autoclav[Dev_no]).ToString(); SqlConnection cn = ConnectToDatabase.NewConnectToDatabase(); SqlCommand cmd = ConnectToDatabase.NewSqlCommand(System.Data.CommandType.StoredProcedure, "Insert_start_New_Period", cn); cmd.Parameters.AddWithValue("dev_no", Dev_no); cmd.Parameters.AddWithValue("status", Enum.EnumStatusPeriod.start.ToString()); cmd.Parameters.AddWithValue("kind", Enum.EnumKindDevice.autoclav.ToString()); cmd.Parameters.AddWithValue("intTimestart", (Convert.ToInt32(timeStartAutoclav) - Varibale.Timer_Autoclav[Dev_no]).ToString()); cmd.Parameters.AddWithValue("intTimeend", 0); cmd.Parameters.AddWithValue("timestart", PublicMehotd.RetStringLocalTime(-1 * Varibale.Timer_Autoclav[Dev_no])); cmd.Parameters.AddWithValue("timeend", "00:00:00"); cmd.Parameters.AddWithValue("date", PublicMehotd.RetStringPersianCalender()); cmd.Parameters.AddWithValue("year", PublicMehotd.retStringYearPersian()); cmd.Parameters.AddWithValue("month", PublicMehotd.retStringMonthPersian()); cmd.Parameters.AddWithValue("day", PublicMehotd.retStringDayPersian()); cmd.Parameters.AddWithValue("intTimezero", "0"); cmd.Parameters.AddWithValue("timezero", "00:00:00"); cmd.Parameters.AddWithValue("time_st", Varibale.Data_Timer_Max[Dev_no].ToString()); cmd.Parameters.AddWithValue("temp_low_st", Varibale.Data_Temp_Min[Dev_no]); cmd.Parameters.AddWithValue("temp_high_st", Varibale.Data_Temp_Max[Dev_no]); cmd.Parameters.AddWithValue("pres_st", Varibale.Data_Pres_Min[Dev_no]); cn.Open(); object obj = cmd.ExecuteScalar(); cn.Close(); return(true); } catch (Exception ex) { log_system.saveLogSystem(ex, "period-start-autoclav"); Enum.ClassEnumError.ShowErrorInMessageBox(Enum.EnumError.insertnewstartautoclavinsertdatabaseerror); return(false); } }
private void NewLogInsertToDatabase() { try { SqlConnection cn = ConnectToDatabase.NewConnectToDatabase(); SqlCommand cmd = ConnectToDatabase.NewSqlCommand(System.Data.CommandType.StoredProcedure, "Insert_Log_New", cn); cmd.Parameters.AddWithValue("dev_no", DeviceNumber); cmd.Parameters.AddWithValue("kind", Kind.ToString()); cmd.Parameters.AddWithValue("comment", classEnumLog.ShowError(Type)); cmd.Parameters.AddWithValue("level", Level.ToString()); cmd.Parameters.AddWithValue("intTime", (Convert.ToInt32(PublicMehotd.time_php()) + Sec)); cmd.Parameters.AddWithValue("datep", PublicMehotd.RetStringPersianCalender()); cmd.Parameters.AddWithValue("timep", PublicMehotd.RetStringLocalTime(Sec)); cmd.Parameters.AddWithValue("datetimep", PublicMehotd.retStringShowDatetime()); cmd.Parameters.AddWithValue("value", Val); cmd.Parameters.AddWithValue("yearp", PublicMehotd.retStringYearPersian()); cmd.Parameters.AddWithValue("monthp", PublicMehotd.retStringMonthPersian()); cmd.Parameters.AddWithValue("dayp", PublicMehotd.retStringDayPersian()); cn.Open(); object obj = cmd.ExecuteScalar(); cn.Close(); } catch (Exception ex) { //Enum.ClassEnumError.ShowErrorInMessageBox(EnumError.insertNewLogProbel); log_system.saveLogSystem(ex, "log_manager insert"); } }
public static bool InsertToDatabase(int devicenumber, Enum.EnumTypeData type, Enum.EnumKindDevice kind, double value) { try { Boolean check = true; if (check) { SqlConnection cn = ConnectToDatabase.NewConnectToDatabase(); SqlCommand cmd = ConnectToDatabase.NewSqlCommand(System.Data.CommandType.StoredProcedure, "Insert_Data_new", cn); cmd.Parameters.AddWithValue("dev_no", devicenumber); cmd.Parameters.AddWithValue("type", type.ToString()); cmd.Parameters.AddWithValue("kind", kind.ToString()); cmd.Parameters.AddWithValue("value", value); cmd.Parameters.AddWithValue("intTime", PublicMehotd.time_php()); cmd.Parameters.AddWithValue("datep", PublicMehotd.RetStringPersianCalender()); cmd.Parameters.AddWithValue("timep", PublicMehotd.RetStringLocalTime()); cmd.Parameters.AddWithValue("yearp", PublicMehotd.retStringYearPersian()); cmd.Parameters.AddWithValue("monthp", PublicMehotd.retStringMonthPersian()); cmd.Parameters.AddWithValue("dayp", PublicMehotd.retStringDayPersian()); cmd.Parameters.AddWithValue("datetimep", Convert.ToDouble(PublicMehotd.retStringShowDatetime())); cn.Open(); object obj = cmd.ExecuteScalar(); cn.Close(); if (Autoclav.sendServer_count == Varibale.save_count_autoclav_server) { Autoclav.sendServer_count = 0; } else { Autoclav.sendServer_count++; } return(true); } else { return(true); } } catch (Exception ex) { log_system.saveLogSystem(ex, "autoclav-insert database"); //Enum.ClassEnumError.ShowErrorInMessageBox(Enum.EnumError.insertnewDatalogforautoclav); return(false); } }
public bool PeriodBakingStart() { try { string timeStartBaking = PublicMehotd.time_php(); Varibale.Status_Baking[Dev_no] = timeStartBaking.ToString(); SqlConnection cn = ConnectToDatabase.NewConnectToDatabase(); SqlCommand cmd = ConnectToDatabase.NewSqlCommand(System.Data.CommandType.StoredProcedure, "Insert_start_New_Period", cn); cmd.Parameters.AddWithValue("dev_no", Dev_no); cmd.Parameters.AddWithValue("status", Enum.EnumStatusPeriod.start.ToString()); cmd.Parameters.AddWithValue("kind", Enum.EnumKindDevice.baking.ToString()); cmd.Parameters.AddWithValue("intTimestart", timeStartBaking); cmd.Parameters.AddWithValue("intTimeend", 0); cmd.Parameters.AddWithValue("timestart", PublicMehotd.RetStringLocalTime()); cmd.Parameters.AddWithValue("timeend", "00:00:00"); cmd.Parameters.AddWithValue("date", PublicMehotd.RetStringPersianCalender()); cmd.Parameters.AddWithValue("year", PublicMehotd.retStringYearPersian()); cmd.Parameters.AddWithValue("month", PublicMehotd.retStringMonthPersian()); cmd.Parameters.AddWithValue("day", PublicMehotd.retStringDayPersian()); cmd.Parameters.AddWithValue("intTimezero", "0"); cmd.Parameters.AddWithValue("timezero", "00:00:00"); cn.Open(); object obj = cmd.ExecuteScalar(); cn.Close(); return(true); } catch (Exception ex) { log_system.saveLogSystem(ex, "period-baking-start"); Enum.ClassEnumError.ShowErrorInMessageBox(Enum.EnumError.insertnewstartautoclavinsertdatabaseerror); return(false); } }
private static void newRecord(int num, Int64 number) { zarinReport.closeAllRcord(num); string type = ""; if (num == 1 || num == 2) { type = "ghabl"; } else { type = "bad"; } string sql = "insert into zarin_report_counter" + " (status , intTimeStart , intTimeEnd, timeStart, timeEnd , datep , yearp , monthp , dayp , number , zarin_product , brand , vazn , baste_bandi , darb , counter_num )" + " values " + " ('counts' , '" + PublicMehotd.time_php() + "' , '0' , '" + PublicMehotd.RetStringLocalTime() + "' , '00:00:00' , '" + PublicMehotd.RetStringPersianCalender() + "' , '" + PublicMehotd.retStringYearPersian() + "' , '" + PublicMehotd.retStringMonthPersian() + "' , '" + PublicMehotd.retStringDayPersian() + "' , '" + number.ToString() + "' , '" + ClassEnumProduct.getProductZarinNumber(Convert.ToInt64(Varibale.zarin["zarin_product_" + type])) + "' , '" + Varibale.zarin["brand_" + type] + "' , '" + Varibale.zarin["vazn_" + type] + "' , '" + Varibale.zarin["baste_bandi_" + type] + "' , '" + Varibale.zarin["darb_" + type] + "' , '" + num.ToString() + "')"; SqlConnection cn = ConnectToDatabase.NewConnectToDatabase(); SqlCommand cmd = ConnectToDatabase.NewSqlCommand(CommandType.Text, sql, cn); cn.Open(); cmd.ExecuteNonQuery(); cn.Close(); }