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