public static void SetFromDatabaseToVarible()
{
try
{
SqlConnection cn = ConnectToDatabase.NewConnectToDatabase();
SqlCommand cmd = ConnectToDatabase.NewSqlCommand(System.Data.CommandType.StoredProcedure, "Select_All_Varible", cn);
cn.Open();
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
try
{
switch (dr["name"].ToString())
{
case "Autoclav_temp_max":
Varibale.Autoclav_Temp_High = Convert.ToDouble(dr["value"].ToString());
break;
case "Autoclav_temp_min":
Varibale.Autoclav_Temp_Low = Convert.ToDouble(dr["value"].ToString());
break;
case "Autoclav_pres_max":
Varibale.Autoclav_Pres_high = Convert.ToDouble(dr["value"].ToString());
break;
case "Autoclav_pres_min":
Varibale.Autoclav_Pres_Low = Convert.ToDouble(dr["value"].ToString());// 0.2 => error
break;
case "Autoclav_timer_max":
Varibale.Autoclav_Timer_max = Convert.ToInt32(dr["value"].ToString());
break;
case "Baking_temp_max":
Varibale.Baking_Temp_High = Convert.ToDouble(dr["value"].ToString());
break;
case "Baking_temp_min":
Varibale.Baking_Temp_Low = Convert.ToDouble(dr["value"].ToString());
break;
case "Baking_pres_max":
Varibale.Baking_Pres_high = Convert.ToDouble(dr["value"].ToString());
break;
case "Baking_pres_min":
Varibale.Baking_Pres_Low = Convert.ToDouble(dr["value"].ToString());
break;
case "Baking_timer_max":
Varibale.Baking_Timer_max = Convert.ToInt32(dr["value"].ToString());
break;
case "totalAutoclav":
Varibale.totalAutoclav = Convert.ToInt32(dr["value"].ToString()) + 1;
break;
case "totalBaking":
Varibale.totalBaking = Convert.ToInt32(dr["value"].ToString()) + 1;
break;
case "Frig_1_Temp_High":
Varibale.Frig_Temp_High[1] = Convert.ToDouble(dr["value"].ToString());
break;
case "Frig_1_Temp_Low":
Varibale.Frig_Temp_Low[1] = Convert.ToDouble(dr["value"].ToString());
break;
case "Frig_2_Temp_High":
Varibale.Frig_Temp_High[2] = Convert.ToDouble(dr["value"].ToString());
break;
case "Frig_2_Temp_Low":
Varibale.Frig_Temp_Low[2] = Convert.ToDouble(dr["value"].ToString());
break;
case "Frig_3_Temp_High":
Varibale.Frig_Temp_High[3] = Convert.ToDouble(dr["value"].ToString());
break;
case "Frig_3_Temp_Low":
Varibale.Frig_Temp_Low[3] = Convert.ToDouble(dr["value"].ToString());
break;
case "Frig_4_Temp_High":
Varibale.Frig_Temp_High[4] = Convert.ToDouble(dr["value"].ToString());
break;
case "Frig_4_Temp_Low":
Varibale.Frig_Temp_Low[4] = Convert.ToDouble(dr["value"].ToString());
break;
case "Frig_5_Temp_High":
Varibale.Frig_Temp_High[5] = Convert.ToDouble(dr["value"].ToString());
break;
case "Frig_5_Temp_Low":
Varibale.Frig_Temp_Low[5] = Convert.ToDouble(dr["value"].ToString());
break;
case "Oil_Temp_High":
Varibale.Oil_Temp_High = Convert.ToDouble(dr["value"].ToString());
break;
case "Oil_Temp_Low":
Varibale.Oil_Temp_Low = Convert.ToDouble(dr["value"].ToString());
break;
case "portname1":
Varibale.portname1 = dr["value"].ToString();
break;
case "buadrate1":
Varibale.buadrate1 = Convert.ToInt32(dr["value"].ToString());
break;
case "parity1":
Varibale.parity1 = PublicMehotd.ConvertStringToParity(dr["value"].ToString());
break;
case "Frig_1_number":
Varibale.frig_number[1] = Convert.ToInt32(dr["value"].ToString());
break;
case "Frig_2_number":
Varibale.frig_number[2] = Convert.ToInt32(dr["value"].ToString());
break;
case "Frig_3_number":
Varibale.frig_number[3] = Convert.ToInt32(dr["value"].ToString());
break;
case "Frig_4_number":
Varibale.frig_number[4] = Convert.ToInt32(dr["value"].ToString());
break;
case "Frig_5_number":
Varibale.frig_number[5] = Convert.ToInt32(dr["value"].ToString());
break;
case "Oil_number":
Varibale.oil_number = Convert.ToInt32(dr["value"].ToString());
break;
case "save_count":
Varibale.Save_count = Convert.ToInt32(dr["value"].ToString());
break;
case "save_count_frig":
Varibale.Save_count_frig = Convert.ToInt32(dr["value"].ToString());
break;
case "save_count_baking_server":
Varibale.save_count_baking_server = Convert.ToInt32(dr["value"].ToString());
break;
case "save_count_autoclav_server":
Varibale.save_count_autoclav_server = Convert.ToInt32(dr["value"].ToString());
break;
case "port_counter":
Varibale.port_counter = dr["value"].ToString();
break;
case "zarin_product_ghabl":
Varibale.zarin.Add("zarin_product_ghabl", dr["value"].ToString());
break;
case "zarin_product_bad":
Varibale.zarin.Add("zarin_product_bad", dr["value"].ToString());
break;
case "brand_ghabl":
Varibale.zarin.Add("brand_ghabl", dr["value"].ToString());
break;
case "brand_bad":
Varibale.zarin.Add("brand_bad", dr["value"].ToString());
break;
case "vazn_ghabl":
Varibale.zarin.Add("vazn_ghabl", dr["value"].ToString());
break;
case "vazn_bad":
Varibale.zarin.Add("vazn_bad", dr["value"].ToString());
break;
case "baste_bandi_ghabl":
Varibale.zarin.Add("baste_bandi_ghabl", dr["value"].ToString());
break;
case "baste_bandi_bad":
Varibale.zarin.Add("baste_bandi_bad", dr["value"].ToString());
break;
case "darb_ghabl":
Varibale.zarin.Add("darb_ghabl", dr["value"].ToString());
break;
case "darb_bad":
Varibale.zarin.Add("darb_bad", dr["value"].ToString());
break;
}
}
catch (Exception ex)
{
log_system.saveLogSystem(ex, "error read value =" + dr["value"].ToString());
}
}
cn.Close();
}
catch (Exception ex)
{
//MessageBox.Show(ex.StackTrace);
log_system.saveLogSystem(ex, "Variable Error ");
}
}
