private void btn_confirm_Click(object sender, System.Windows.RoutedEventArgs e)
{
try
{
ObjectModule.Local.Configure sc = new ObjectModule.Local.Configure();
sc.CATEGORY = this.txt_category.Text;
sc.DEFAULT_VALUE = this.txt_defaultValue.Text;
sc.NAME = this.txt_name.Text;
sc.UNIT = this.txt_unit.Text;
sc.UPDATED_TIME = System.DateTime.Now;
sc.USER_GROUP = StaticRes.Global.Current_User.USER_GROUP;
sc.USER_ID = StaticRes.Global.Current_User.USER_ID;
sc.VALUE = this.txt_value.Text;
Logic.Common.Configure_Update(sc);
SystemSet_Match(sc.NAME, sc.VALUE);
Common.Reports.LogFile.Log("Update Configure Name: " + sc.NAME + " ; Value:" + sc.VALUE + " by user:"******"Update Successful !!", "Message", MessageBoxButton.OK, MessageBoxImage.Asterisk);
Configure_Search();
this.MaskActionPage.Visibility = Visibility.Collapsed;
}
catch (Exception ee)
{
Common.Reports.LogFile.Log("Update system setting failed , error:" + ee.Message);
MessageBox.Show(ee.Message, "Error", MessageBoxButton.OK, MessageBoxImage.Error);
}
}
public static bool Update(ObjectModule.Local.Configure sc)
{
try
{
string sql = @"Update Configure set VALUE=@VALUE,UPDATED_TIME=@UPDATED_TIME,
USER_ID=@USER_ID,USER_GROUP=@USER_GROUP where NAME=@NAME ";
SqlCommand cmd = new SqlCommand(sql);
cmd.Parameters.Add("@VALUE", SqlDbType.VarChar).Value = sc.VALUE;
cmd.Parameters.Add("@UPDATED_TIME", SqlDbType.DateTime).Value = sc.UPDATED_TIME;
cmd.Parameters.Add("@USER_ID", SqlDbType.VarChar).Value = sc.USER_ID;
cmd.Parameters.Add("@USER_GROUP", SqlDbType.VarChar).Value = sc.USER_GROUP;
cmd.Parameters.Add("@NAME", SqlDbType.VarChar).Value = sc.NAME;
return(Common.DB.SqlDB.SetData(cmd, StaticRes.Local));
}
catch (SqlException ee)
{
throw ee;
}
}
public static bool Configure_Update(ObjectModule.Local.Configure sc)
{
return(DataProvider.Local.Configure.Update(sc));
}
private static void Read_Parameter()
{
DataTable dt_sys = DataProvider.Local.Configure.Select();
if (dt_sys.Rows.Count == 0)
{
throw new System.Exception("Read system paramater failed , please check with admin !!");
}
List <ObjectModule.Local.Configure> configure_list = new List <ObjectModule.Local.Configure>();
foreach (DataRow a in dt_sys.Rows)
{
ObjectModule.Local.Configure sc = new ObjectModule.Local.Configure(a);
configure_list.Add(sc);
}
StaticRes.Global.System_Setting.SlotScanner_Index1Port = (from m in configure_list where m.NAME == "Slot_Index1_Scanner_COM_Port" select m.VALUE).First <string>();
StaticRes.Global.System_Setting.SlotScanner_Index2Port = (from m in configure_list where m.NAME == "Slot_Index2_Scanner_COM_Port" select m.VALUE).First <string>();
StaticRes.Global.System_Setting.SlotScanner_Index3Port = (from m in configure_list where m.NAME == "Slot_Index3_Scanner_COM_Port" select m.VALUE).First <string>();
StaticRes.Global.System_Setting.SlotScanner_Index4Port = (from m in configure_list where m.NAME == "Slot_Index4_Scanner_COM_Port" select m.VALUE).First <string>();
StaticRes.Global.System_Setting.SlotScanner_BaudRate = int.Parse((from m in configure_list where m.NAME == "Slot_Scanner_BaudRate" select m.VALUE).First <string>());
StaticRes.Global.System_Setting.SlotScanner_DataBits = int.Parse((from m in configure_list where m.NAME == "Slot_Scanner_DataBits" select m.VALUE).First <string>());
StaticRes.Global.System_Setting.SlotScanner_ReceivedBytesThreshold = int.Parse((from m in configure_list where m.NAME == "Slot_Scanner_ReceivedBytesThreshold" select m.VALUE).First <string>());
StaticRes.Global.System_Setting.Print_Label_Before_Load = (from m in configure_list where m.NAME == "Print_Label_Before_Load" select m.VALUE).First <string>();
StaticRes.Global.System_Setting.Print_Label_After_Unload = (from m in configure_list where m.NAME == "Print_Label_After_Unload" select m.VALUE).First <string>();
StaticRes.Global.System_Setting.Weighing_Scale_COM_Port = (from m in configure_list where m.NAME == "Weighing_Scale_COM_Port" select m.VALUE).First <string>();
StaticRes.Global.System_Setting.Weighing_Scale_BaudRate = int.Parse((from m in configure_list where m.NAME == "Weighing_Scale_BaudRate" select m.VALUE).First <string>());
StaticRes.Global.System_Setting.Weighing_Scale_DataBits = int.Parse((from m in configure_list where m.NAME == "Weighing_Scale_DataBits" select m.VALUE).First <string>());
StaticRes.Global.System_Setting.Weighing_Scale_ReceivedBytesThreshold = int.Parse((from m in configure_list where m.NAME == "Weighing_Scale_ReceivedBytesThreshold" select m.VALUE).First <string>());
StaticRes.Global.System_Setting.Printer_COM_Port = (from m in configure_list where m.NAME == "Printer_COM_Port" select m.VALUE).First <string>();
StaticRes.Global.System_Setting.Printer_BaudRate = int.Parse((from m in configure_list where m.NAME == "Printer_BaudRate" select m.VALUE).First <string>());
StaticRes.Global.System_Setting.Printer_DataBits = int.Parse((from m in configure_list where m.NAME == "Printer_DataBits" select m.VALUE).First <string>());
StaticRes.Global.System_Setting.Printer_ReceivedBytesThreshold = int.Parse((from m in configure_list where m.NAME == "Printer_ReceivedBytesThreshold" select m.VALUE).First <string>());
StaticRes.Global.System_Setting.Handle_Scanner_COM_Port = (from m in configure_list where m.NAME == "Handle_Scanner_COM_Port" select m.VALUE).First <string>();
StaticRes.Global.System_Setting.Handle_Scanner_BaudRate = int.Parse((from m in configure_list where m.NAME == "Handle_Scanner_BaudRate" select m.VALUE).First <string>());
StaticRes.Global.System_Setting.Handle_Scanner_DataBits = int.Parse((from m in configure_list where m.NAME == "Handle_Scanner_DataBits" select m.VALUE).First <string>());
StaticRes.Global.System_Setting.Handle_Scanner_ReceivedBytesThreshold = int.Parse((from m in configure_list where m.NAME == "Handle_Scanner_ReceivedBytesThreshold" select m.VALUE).First <string>());
StaticRes.Global.System_Setting.Idle_Time_To_Exit = int.Parse((from m in configure_list where m.NAME == "Idle_Time_To_Exit" select m.VALUE).First <string>());
StaticRes.Global.System_Setting.Online_Mode = (from m in configure_list where m.NAME == "Online_Mode" select m.VALUE).First <string>();
StaticRes.Global.System_Setting.Allow_Manual_KeyIn = (from m in configure_list where m.NAME == "Allow_Manual_KeyIn" select m.VALUE).First <string>();
StaticRes.Global.System_Setting.Storage_Pre_Set_Qty = int.Parse((from m in configure_list where m.NAME == "Storage_Pre_Set_Qty" select m.VALUE).First <string>());
StaticRes.Global.System_Setting.One_Cycle_Pulse = int.Parse((from m in configure_list where m.NAME == "One_Cycle_Pulse" select m.VALUE).First <string>());
StaticRes.Global.System_Setting.Rotary_Home_Low_Velocity = int.Parse((from m in configure_list where m.NAME == "Rotary_Home_Low_Velocity" select m.VALUE).First <string>());
StaticRes.Global.System_Setting.Rotary_Home_High_Velocity = int.Parse((from m in configure_list where m.NAME == "Rotary_Home_High_Velocity" select m.VALUE).First <string>());
StaticRes.Global.System_Setting.Rotary_Home_Acc = int.Parse((from m in configure_list where m.NAME == "Rotary_Home_Acc" select m.VALUE).First <string>());
StaticRes.Global.System_Setting.Rotary_Home_Dcc = int.Parse((from m in configure_list where m.NAME == "Rotary_Home_Dcc" select m.VALUE).First <string>());
StaticRes.Global.System_Setting.Rotary_Home_Jerk = int.Parse((from m in configure_list where m.NAME == "Rotary_Home_Jerk" select m.VALUE).First <string>());
StaticRes.Global.System_Setting.Rotary_Move_Low_Velocity = int.Parse((from m in configure_list where m.NAME == "Rotary_Move_Low_Velocity" select m.VALUE).First <string>());
StaticRes.Global.System_Setting.Rotary_Move_High_Velocity = int.Parse((from m in configure_list where m.NAME == "Rotary_Move_High_Velocity" select m.VALUE).First <string>());
StaticRes.Global.System_Setting.Rotary_Move_Acc = int.Parse((from m in configure_list where m.NAME == "Rotary_Move_Acc" select m.VALUE).First <string>());
StaticRes.Global.System_Setting.Rotary_Move_Dcc = int.Parse((from m in configure_list where m.NAME == "Rotary_Move_Dcc" select m.VALUE).First <string>());
StaticRes.Global.System_Setting.Rotary_Move_Jerk = int.Parse((from m in configure_list where m.NAME == "Rotary_Move_Jerk" select m.VALUE).First <string>());
StaticRes.Global.System_Setting.Rotary_Homing_Pitch = int.Parse((from m in configure_list where m.NAME == "Rotary_Homing_Pitch" select m.VALUE).First <string>());
StaticRes.Global.System_Setting.Index_1_Capacity = int.Parse((from m in configure_list where m.NAME == "Index_1_Capacity" select m.VALUE).First <string>());
StaticRes.Global.System_Setting.Index_2_Capacity = int.Parse((from m in configure_list where m.NAME == "Index_2_Capacity" select m.VALUE).First <string>());
StaticRes.Global.System_Setting.Index_3_Capacity = int.Parse((from m in configure_list where m.NAME == "Index_3_Capacity" select m.VALUE).First <string>());
StaticRes.Global.System_Setting.Bypass_Syringe_Top_Cover_Sensor = (from m in configure_list where m.NAME == "Bypass_Syringe_Top_Cover_Sensor" select m.VALUE).First <string>();
StaticRes.Global.System_Setting.Bypass_Syringe_30cc_Cap_Present_Sensor = (from m in configure_list where m.NAME == "Bypass_Syringe_30cc_Cap_Present_Sensor" select m.VALUE).First <string>();
StaticRes.Global.System_Setting.Bypass_Syringe_10cc_Cap_Present_Sensor = (from m in configure_list where m.NAME == "Bypass_Syringe_10cc_Cap_Present_Sensor" select m.VALUE).First <string>();
StaticRes.Global.System_Setting.Bypass_Syringe_5cc_Cap_Present_Sensor = (from m in configure_list where m.NAME == "Bypass_Syringe_5cc_Cap_Present_Sensor" select m.VALUE).First <string>();
StaticRes.Global.System_Setting.Time_1 = int.Parse((from m in configure_list where m.NAME == "Time_1" select m.VALUE).First <string>()); //yaskun.zhou 2015.07.01
StaticRes.Global.System_Setting.Reminder_time = (from m in configure_list where m.NAME == "Reminder_time" select m.VALUE).First <string>(); //yaskun.zhou 2015.07.01
DataTable dt = DataProvider.Local.Slot_Position.Select.All();
for (int i = 0; i < 100; i++)
{
StaticRes.Global.Slot_Position[i] = int.Parse(dt.Rows[i]["POSITION"].ToString());
}
Motion_Control.Read_Motion_Config();
}
