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