public static bool Return(ObjectModule.Local.Binning gb, ObjectModule.Local.Tracking gt) { List <SqlCommand> list = new List <SqlCommand>(); try { if (gt.STATUS == "REUSE") { SqlCommand cmd_Binning = Binning.Update(gb); list.Add(cmd_Binning); SqlCommand cmd_Tracking = Tracking.Update(gt); list.Add(cmd_Tracking); } else { SqlCommand cmd_Tracing = Tracking.Delete(gt.PART_ID); list.Add(cmd_Tracing); } SqlCommand cmd_History = History.Insert(gt); list.Add(cmd_History); return(Common.DB.SqlDB.SetData_Rollback(list, StaticRes.Local)); } catch { return(false); } }
public static SqlCommand Update(ObjectModule.Local.Tracking gt) { try { string sql = @"Update Tracking set CURRENT_WEIGHT=@CURRENT_WEIGHT,STATUS=@STATUS,DEVICE=@DEVICE,USER_NAME=@USER_NAME, EQUIP_ID =@EQUIP_ID,LOCID=@LOCID,USER_ID=@USER_ID,LOT_ID=@LOT_ID,ACTION=@ACTION,REMARKS=@REMARKS, UPDATED_TIME=@UPDATED_TIME,WEEK=@WEEK,MONTH=@MONTH,YEAR=@YEAR where PART_ID=@PART_ID "; System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand(sql); cmd.Parameters.Add("@PART_ID", System.Data.SqlDbType.VarChar).Value = gt.PART_ID; cmd.Parameters.Add("@CURRENT_WEIGHT", System.Data.SqlDbType.Float).Value = gt.CURRENT_WEIGHT; cmd.Parameters.Add("@STATUS", System.Data.SqlDbType.VarChar).Value = gt.STATUS; cmd.Parameters.Add("@DEVICE", System.Data.SqlDbType.VarChar).Value = gt.DEVICE; cmd.Parameters.Add("@EQUIP_ID", System.Data.SqlDbType.VarChar).Value = gt.EQUIP_ID; cmd.Parameters.Add("@LOCID", System.Data.SqlDbType.VarChar).Value = gt.LOCID; cmd.Parameters.Add("@USER_ID", System.Data.SqlDbType.VarChar).Value = gt.USER_ID; cmd.Parameters.Add("@USER_NAME", System.Data.SqlDbType.VarChar).Value = gt.USER_NAME; cmd.Parameters.Add("@LOT_ID", System.Data.SqlDbType.VarChar).Value = gt.LOT_ID; cmd.Parameters.Add("@ACTION", System.Data.SqlDbType.VarChar).Value = gt.ACTION; cmd.Parameters.Add("@REMARKS", System.Data.SqlDbType.VarChar).Value = gt.REMARKS; cmd.Parameters.Add("@UPDATED_TIME", System.Data.SqlDbType.DateTime).Value = gt.UPDATED_TIME; cmd.Parameters.Add("@WEEK", System.Data.SqlDbType.Int).Value = gt.WEEK; cmd.Parameters.Add("@MONTH", System.Data.SqlDbType.Int).Value = gt.MONTH; cmd.Parameters.Add("@YEAR", System.Data.SqlDbType.Int).Value = gt.YEAR; return(cmd); } catch (SqlException ee) { throw ee; } }
public static bool Local_Update(string Slot_ID, string Slot_Index, string Batch_No, string Sapcode, string Description, string Part_ID, string Thawing_Time, string Ready_Time, string Expiry_Time, string MF_Expiry_Date, string Weight, string Capacity, string Empty_Syringe_Weight) { #region Update BINNING DB ObjectModule.Local.Binning gb = new ObjectModule.Local.Binning(); gb.BATCH_NO = Batch_No; gb.CAPACITY = int.Parse(Capacity); gb.CURRENT_WEIGHT = float.Parse(Weight); gb.DEPARTMENT = StaticRes.Global.Current_User.DEPARTMENT; gb.DESCRIPTION = Description; gb.EXPIRY_DATETIME = DateTime.Parse(Expiry_Time); gb.MF_EXPIRY_DATE = DateTime.Parse(MF_Expiry_Date); gb.PART_ID = Part_ID; gb.READY_DATETIME = DateTime.Parse(Ready_Time); gb.SAPCODE = Sapcode; gb.SLOT_ID = int.Parse(Slot_ID); gb.SLOT_INDEX = int.Parse(Slot_Index); gb.START_WEIGHT = float.Parse(Weight); gb.STATUS = StaticRes.Global.Binning_Status.New; gb.THAWING_DATETIME = DateTime.Parse(Thawing_Time); gb.UPDATED_TIME = System.DateTime.Now; gb.USER_GROUP = StaticRes.Global.Current_User.USER_GROUP; gb.USER_ID = StaticRes.Global.Current_User.USER_ID; gb.USER_NAME = StaticRes.Global.Current_User.USER_NAME; #endregion #region Insert Trakcing/History ObjectModule.Local.Tracking gt = new ObjectModule.Local.Tracking(); gt.ACTION = StaticRes.Global.Event.Load; gt.BATCH_NO = Batch_No; gt.CAPACITY = int.Parse(Capacity); gt.CURRENT_WEIGHT = float.Parse(Weight); gt.DEPARTMENT = StaticRes.Global.Current_User.DEPARTMENT; gt.DESCRIPTION = Description; gt.DEVICE = ""; gt.EMPTY_SYRINGE_WEIGHT = float.Parse(Empty_Syringe_Weight); gt.EQUIP_ID = ""; gt.EXPIRY_DATETIME = DateTime.Parse(Expiry_Time); gt.LOCID = ""; gt.LOT_ID = ""; gt.MF_EXPIRY_DATE = DateTime.Parse(MF_Expiry_Date); gt.MONTH = System.DateTime.Now.Month; gt.PART_ID = Part_ID; gt.READY_DATETIME = DateTime.Parse(Ready_Time); gt.REMARKS = ""; gt.SAPCODE = Sapcode; gt.START_WEIGHT = float.Parse(Weight); gt.STATUS = StaticRes.Global.Status.Load; gt.THAWING_DATETIME = DateTime.Parse(Thawing_Time); gt.UPDATED_TIME = System.DateTime.Now; gt.USER_ID = StaticRes.Global.Current_User.USER_ID; gt.USER_NAME = StaticRes.Global.Current_User.USER_NAME; gt.WEEK = Logic.Common.weekofyear(System.DateTime.Now); gt.YEAR = System.DateTime.Now.Year; return(DataProvider.Rollback.Load(gb, gt)); #endregion }
public static ObjectModule.Local.Tracking PartID_Validate(string Part_ID) { DataTable dt = DataProvider.Local.Tracking.Select.by_PartID(Part_ID, StaticRes.Global.Status.Unload); if (dt.Rows.Count == 0) { throw new System.Exception("Invalid Part ID !!\n错误的Part ID!!"); } ObjectModule.Local.Tracking gt = new ObjectModule.Local.Tracking(dt.Rows[0]); return(gt); }
private void btn_CapturePartID_Click(object sender, System.Windows.RoutedEventArgs e) { System.Data.DataTable dt = DataProvider.Local.Tracking.Select.by_PartID(txt_part_id.Text, StaticRes.Global.Status.Unload); if (dt.Rows.Count == 0) { MessageBox.Show("These haven't issue record of part ID:" + txt_part_id.Text, "Error", MessageBoxButton.OK, MessageBoxImage.Error); return; } ObjectModule.Local.Tracking st = new ObjectModule.Local.Tracking(dt.Rows[0]); this.txt_mcID.Text = st.EQUIP_ID; this.txt_sapcode.Text = st.SAPCODE; //this.txt_expiryTime.Text = st.EXPIRY_TIME.ToString(); }
void Timer_Expiry(object sender, EventArgs e) { try { DataTable dt = Logic.Transaction.Expiry_List(); if (dt.Rows.Count > 0) { ObjectModule.Local.Tracking track = new ObjectModule.Local.Tracking(dt.Rows[0]); new EMS.ExpiryWindow(track).ShowDialog(); } } catch { } }
public static bool Mix_DataMissing(ObjectModule.Local.Tracking trackingModel) { try { List <SqlCommand> cmdList = new List <SqlCommand>(); cmdList.Add(Tracking.Insert(trackingModel)); cmdList.Add(History.Insert(trackingModel)); return(Common.DB.SqlDB.SetData_Rollback(cmdList, StaticRes.Local)); } catch { return(false); } }
public static SqlCommand Insert(ObjectModule.Local.Tracking gt) { try { string sql = @"insert into History (PART_ID,SAPCODE,BATCH_NO,DESCRIPTION,DEPARTMENT,START_WEIGHT,CURRENT_WEIGHT,STATUS,EQUIP_ID,LOCID,THAWING_DATETIME,READY_DATETIME, CAPACITY,EXPIRY_DATETIME,MF_EXPIRY_DATE,LOT_ID,DEVICE,EMPTY_SYRINGE_WEIGHT,USER_ID,USER_NAME,ACTION,REMARKS,UPDATED_TIME,WEEK,MONTH,YEAR) VALUES (@PART_ID,@SAPCODE,@BATCH_NO,@DESCRIPTION,@DEPARTMENT,@START_WEIGHT,@CURRENT_WEIGHT,@STATUS,@EQUIP_ID,@LOCID,@THAWING_DATETIME,@READY_DATETIME, @CAPACITY,@EXPIRY_DATETIME,@MF_EXPIRY_DATE,@LOT_ID,@DEVICE,@EMPTY_SYRINGE_WEIGHT,@USER_ID,@USER_NAME,@ACTION,@REMARKS,@UPDATED_TIME,@WEEK,@MONTH,@YEAR)"; System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand(sql); cmd.Parameters.Add("@PART_ID", System.Data.SqlDbType.VarChar).Value = gt.PART_ID; cmd.Parameters.Add("@SAPCODE", System.Data.SqlDbType.VarChar).Value = gt.SAPCODE; cmd.Parameters.Add("@BATCH_NO", System.Data.SqlDbType.VarChar).Value = gt.BATCH_NO; cmd.Parameters.Add("@DESCRIPTION", System.Data.SqlDbType.VarChar).Value = gt.DESCRIPTION; cmd.Parameters.Add("@DEPARTMENT", System.Data.SqlDbType.VarChar).Value = gt.DEPARTMENT; cmd.Parameters.Add("@START_WEIGHT", System.Data.SqlDbType.Float).Value = gt.START_WEIGHT; cmd.Parameters.Add("@CURRENT_WEIGHT", System.Data.SqlDbType.Float).Value = gt.CURRENT_WEIGHT; cmd.Parameters.Add("@CAPACITY", System.Data.SqlDbType.Int).Value = gt.CAPACITY; cmd.Parameters.Add("@STATUS", System.Data.SqlDbType.VarChar).Value = gt.STATUS; cmd.Parameters.Add("@EQUIP_ID", System.Data.SqlDbType.VarChar).Value = gt.EQUIP_ID; cmd.Parameters.Add("@LOCID", System.Data.SqlDbType.VarChar).Value = gt.LOCID; cmd.Parameters.Add("@THAWING_DATETIME", System.Data.SqlDbType.DateTime).Value = gt.THAWING_DATETIME; cmd.Parameters.Add("@READY_DATETIME", System.Data.SqlDbType.DateTime).Value = gt.READY_DATETIME; cmd.Parameters.Add("@EXPIRY_DATETIME", System.Data.SqlDbType.DateTime).Value = gt.EXPIRY_DATETIME; cmd.Parameters.Add("@MF_EXPIRY_DATE", System.Data.SqlDbType.Date).Value = gt.MF_EXPIRY_DATE; cmd.Parameters.Add("@LOT_ID", System.Data.SqlDbType.VarChar).Value = gt.LOT_ID; cmd.Parameters.Add("@DEVICE", System.Data.SqlDbType.VarChar).Value = gt.DEVICE; cmd.Parameters.Add("@EMPTY_SYRINGE_WEIGHT", System.Data.SqlDbType.Float).Value = gt.EMPTY_SYRINGE_WEIGHT; cmd.Parameters.Add("@USER_ID", System.Data.SqlDbType.VarChar).Value = gt.USER_ID; cmd.Parameters.Add("@USER_NAME", System.Data.SqlDbType.VarChar).Value = gt.USER_NAME; cmd.Parameters.Add("@ACTION", System.Data.SqlDbType.VarChar).Value = gt.ACTION; cmd.Parameters.Add("@REMARKS", System.Data.SqlDbType.VarChar).Value = gt.REMARKS; cmd.Parameters.Add("@UPDATED_TIME", System.Data.SqlDbType.DateTime).Value = gt.UPDATED_TIME; cmd.Parameters.Add("@WEEK", System.Data.SqlDbType.Int).Value = gt.WEEK; cmd.Parameters.Add("@MONTH", System.Data.SqlDbType.Int).Value = gt.MONTH; cmd.Parameters.Add("@YEAR", System.Data.SqlDbType.Int).Value = gt.YEAR; return(cmd); } catch (SqlException ee) { throw ee; } }
public static bool Spool_Missing(ObjectModule.Local.Tracking gt, ObjectModule.Local.Binning gb) { List <SqlCommand> list = new List <SqlCommand>(); try { SqlCommand cmd_GEMS_Binning = Binning.Update(gb); list.Add(cmd_GEMS_Binning); SqlCommand cmd_GEMS_Tracking = Tracking.Delete(gt.PART_ID); list.Add(cmd_GEMS_Tracking); SqlCommand cmd_GEMS_History = History.Insert(gt); list.Add(cmd_GEMS_History); return(Common.DB.SqlDB.SetData_Rollback(list, StaticRes.Local)); } catch { return(false); } }
public static bool Unload(ObjectModule.Local.Binning gb, ObjectModule.Local.Tracking gt) { List <SqlCommand> list = new List <SqlCommand>(); try { SqlCommand cmd_Binning = Binning.Update(gb); list.Add(cmd_Binning); SqlCommand cmd_Tracking = Tracking.Update(gt); list.Add(cmd_Tracking); SqlCommand cmd_History = History.Insert(gt); list.Add(cmd_History); return(Common.DB.SqlDB.SetData_Rollback(list, StaticRes.Local)); } catch { return(false); } }
public ExpiryWindow(ObjectModule.Local.Tracking tk) { InitializeComponent(); try { tm.Tick += new EventHandler(Timer); tm.Interval = TimeSpan.FromSeconds(0.5); tm.Start(); tracking = tk; this.txt_batchNo.Content = tk.BATCH_NO; this.txt_expiryTime.Content = tk.EXPIRY_DATETIME.ToString(); this.txt_partID.Content = tk.PART_ID.ToString(); this.txt_readyTime.Content = tk.READY_DATETIME.ToString(); this.txt_sapcode.Content = tk.SAPCODE; this.txt_thawingTime.Content = tk.THAWING_DATETIME.ToString(); this.txt_mcID.Content = tk.EQUIP_ID.ToString(); HardwareControl.IO_Control.Alarm_Tower_Light_Setting(); Common.Reports.LogFile.Log("Expiry Alarm : " + this.txt_partID.Content.ToString() + ",Machine ID" + this.txt_mcID.Content.ToString() + ""); } catch (Exception ff) { MessageBox.Show(ff.Message); } }
public static List <ObjectModule.Local.Summary_List> History_Summary_Search(DateTime dateFrom, DateTime dateTo) { //return DataProvider.Local.History.Select_Summary(dateFrom, dateTo); List <ObjectModule.Local.Summary_List> List = new List <ObjectModule.Local.Summary_List>(); DataTable dt = DataProvider.Local.History.Select(dateFrom, dateTo, string.Empty, string.Empty, false); List <ObjectModule.Local.Tracking> list_history = new List <ObjectModule.Local.Tracking>(); foreach (DataRow x in dt.Rows) { ObjectModule.Local.Tracking t = new ObjectModule.Local.Tracking(x); list_history.Add(t); } DataTable dt_partID_List = DataProvider.Local.History.PartID_List(dateFrom, dateTo); foreach (DataRow x in dt_partID_List.Rows) { List <ObjectModule.Local.Tracking> list_load = (from m in list_history where m.PART_ID == x["PART_ID"].ToString() && m.ACTION == StaticRes.Global.Event.Load select m).ToList <ObjectModule.Local.Tracking>(); if (list_load.Count >= 1) { ObjectModule.Local.Tracking load = list_load.First <ObjectModule.Local.Tracking>(); ObjectModule.Local.Summary_List xx = new ObjectModule.Local.Summary_List(); xx.BATCH_NO = load.BATCH_NO; xx.CAPACITY = load.CAPACITY.ToString(); xx.LOAD_WEIGHT = load.CURRENT_WEIGHT.ToString(); xx.DEPARTMENT = load.DEPARTMENT; xx.DESCRIPTION = load.DESCRIPTION; xx.EMPTY_SYRINGE_WEIGHT = load.EMPTY_SYRINGE_WEIGHT.ToString(); xx.EXPIRY_DATETIME = load.EXPIRY_DATETIME.ToString(); xx.LOAD_TIME = load.UPDATED_TIME.ToString(); xx.LOAD_USER = load.USER_ID; xx.LOAD_USER_NAME = load.USER_NAME; xx.LOAD_WEIGHT = load.START_WEIGHT.ToString(); xx.MF_EXPIRY_DATETIME = load.MF_EXPIRY_DATE.ToString(); xx.PART_ID = load.PART_ID; xx.READY_DATETIME = load.READY_DATETIME.ToString(); xx.SAPCODE = load.SAPCODE; xx.THAWING_DATETIME = load.THAWING_DATETIME.ToString(); List <ObjectModule.Local.Tracking> list_unload = (from m in list_history where m.PART_ID == x["PART_ID"].ToString() && m.ACTION == StaticRes.Global.Event.Unload select m).ToList <ObjectModule.Local.Tracking>(); if (list_unload.Count >= 1) { ObjectModule.Local.Tracking unload = list_unload.First <ObjectModule.Local.Tracking>(); xx.UNLOAD_WEIGHT_1 = unload.CURRENT_WEIGHT.ToString(); xx.DEVICE_1 = unload.DEVICE.ToString(); xx.EQUIP_ID_1 = unload.EQUIP_ID.ToString(); xx.LOCID_1 = unload.LOCID.ToString(); xx.LOT_ID_1 = unload.LOT_ID.ToString(); xx.UNLOAD_TIME_1 = unload.UPDATED_TIME.ToString(); xx.UNLOAD_USER_1 = unload.USER_ID; xx.UNLOAD_USER_NAME_1 = unload.USER_NAME; xx.UNLOAD_WEIGHT_1 = unload.CURRENT_WEIGHT.ToString(); } if (list_unload.Count == 2) { ObjectModule.Local.Tracking unload = list_unload.Last <ObjectModule.Local.Tracking>(); xx.UNLOAD_WEIGHT_2 = unload.CURRENT_WEIGHT.ToString(); xx.DEVICE_2 = unload.DEVICE.ToString(); xx.EQUIP_ID_2 = unload.EQUIP_ID.ToString(); xx.LOCID_2 = unload.LOCID.ToString(); xx.LOT_ID_2 = unload.LOT_ID.ToString(); xx.UNLOAD_TIME_2 = unload.UPDATED_TIME.ToString(); xx.UNLOAD_USER_2 = unload.USER_ID; xx.UNLOAD_USER_NAME_2 = unload.USER_NAME; xx.UNLOAD_WEIGHT_2 = unload.CURRENT_WEIGHT.ToString(); } List <ObjectModule.Local.Tracking> list_return = (from m in list_history where m.PART_ID == x["PART_ID"].ToString() && m.ACTION == StaticRes.Global.Event.Reuse select m).ToList <ObjectModule.Local.Tracking>(); if (list_return.Count == 1) { ObjectModule.Local.Tracking Return = list_return.First <ObjectModule.Local.Tracking>(); xx.RETURN_TIME_1 = Return.UPDATED_TIME.ToString(); xx.RETURN_USER_1 = Return.USER_ID; xx.RETURN_USER_NAME_1 = Return.USER_NAME; xx.RETURN_WEIGHT_1 = Return.CURRENT_WEIGHT.ToString(); } if (list_return.Count == 2) { ObjectModule.Local.Tracking Return = list_return.Last <ObjectModule.Local.Tracking>(); xx.RETURN_TIME_2 = Return.UPDATED_TIME.ToString(); xx.RETURN_USER_2 = Return.USER_ID; xx.RETURN_USER_NAME_2 = Return.USER_NAME; xx.RETURN_WEIGHT_2 = Return.CURRENT_WEIGHT.ToString(); } List <ObjectModule.Local.Tracking> list_scrap = (from m in list_history where m.PART_ID == x["PART_ID"].ToString() && m.ACTION == StaticRes.Global.Event.Scrap select m).ToList <ObjectModule.Local.Tracking>(); if (list_scrap.Count == 1) { ObjectModule.Local.Tracking scrap = list_scrap.First <ObjectModule.Local.Tracking>(); xx.SCRAP_TIME = scrap.UPDATED_TIME.ToString(); xx.SCRAP_USER = scrap.USER_ID; xx.SCRAP_USER_NAME = scrap.USER_NAME; xx.SCRAP_WEIGHT = scrap.CURRENT_WEIGHT.ToString(); } List.Add(xx); } } return(List); }
public static bool Local_Update(string Part_ID, string Slot_ID, string Slot_Index, string Equip_ID, string status, string Start_Weight, string Current_Weight, string Sapcode, string Thawing_Time, string Ready_Time, string Expiry_Time, string Description, string Batch_No, string Capacity, string Remark) { #region Update BINNING DB ObjectModule.Local.Binning gb = new ObjectModule.Local.Binning(); gb.BATCH_NO = ""; gb.CAPACITY = int.Parse(Capacity); gb.CURRENT_WEIGHT = 0; gb.DEPARTMENT = StaticRes.Global.Current_User.DEPARTMENT; gb.DESCRIPTION = ""; gb.EXPIRY_DATETIME = System.DateTime.Now; gb.MF_EXPIRY_DATE = System.DateTime.Now; gb.PART_ID = ""; gb.READY_DATETIME = System.DateTime.Now; gb.SAPCODE = ""; gb.SLOT_ID = int.Parse(Slot_ID); gb.SLOT_INDEX = int.Parse(Slot_Index); gb.START_WEIGHT = 0; gb.STATUS = StaticRes.Global.Binning_Status.Empty; gb.THAWING_DATETIME = System.DateTime.Now; gb.UPDATED_TIME = System.DateTime.Now; gb.USER_GROUP = StaticRes.Global.Current_User.USER_GROUP; gb.USER_ID = StaticRes.Global.Current_User.USER_ID; gb.USER_NAME = StaticRes.Global.Current_User.USER_NAME; #endregion #region Insert TRACKING/History DataTable dt = new DataTable(); if (status == StaticRes.Global.Status.Load) //New Material { dt = DataProvider.Local.Tracking.Select.by_PartID(Part_ID, StaticRes.Global.Status.Load); } else { dt = DataProvider.Local.Tracking.Select.by_PartID(Part_ID, StaticRes.Global.Status.Reuse); } if (dt.Rows.Count == 0) { #region If data missing ObjectModule.Local.Tracking gt = new ObjectModule.Local.Tracking(); gt.ACTION = StaticRes.Global.Event.Remove; gt.BATCH_NO = Batch_No; gt.CAPACITY = int.Parse(Capacity); gt.CURRENT_WEIGHT = float.Parse(Current_Weight); gt.DEPARTMENT = StaticRes.Global.Current_User.DEPARTMENT; gt.DESCRIPTION = Description; gt.DEVICE = ""; gt.EMPTY_SYRINGE_WEIGHT = 0; if (Equip_ID.Length > 0) { gt.EQUIP_ID = Equip_ID; } else { gt.EQUIP_ID = ""; } gt.EXPIRY_DATETIME = DateTime.Parse(Expiry_Time); gt.LOCID = ""; gt.LOT_ID = ""; gt.MF_EXPIRY_DATE = System.DateTime.Now.AddYears(1); gt.MONTH = System.DateTime.Now.Month; gt.PART_ID = Part_ID; gt.READY_DATETIME = DateTime.Parse(Ready_Time); gt.REMARKS = "Missing"; gt.SAPCODE = Sapcode; gt.START_WEIGHT = float.Parse(Start_Weight); gt.STATUS = StaticRes.Global.Status.Unload; gt.THAWING_DATETIME = DateTime.Parse(Thawing_Time); gt.UPDATED_TIME = System.DateTime.Now; gt.USER_ID = StaticRes.Global.Current_User.USER_ID; gt.USER_NAME = StaticRes.Global.Current_User.USER_NAME; gt.WEEK = Logic.Common.weekofyear(System.DateTime.Now); gt.YEAR = System.DateTime.Now.Year; return(DataProvider.Rollback.Unload_DataMissing(gb, gt)); #endregion } else { ObjectModule.Local.Tracking gt = new ObjectModule.Local.Tracking(dt.Rows[0]); gt.ACTION = StaticRes.Global.Event.Remove; gt.DEVICE = ""; gt.LOCID = ""; gt.LOT_ID = ""; gt.MONTH = System.DateTime.Now.Month; gt.UPDATED_TIME = System.DateTime.Now; gt.USER_ID = StaticRes.Global.Current_User.USER_ID; gt.USER_NAME = StaticRes.Global.Current_User.USER_NAME; gt.WEEK = Logic.Common.weekofyear(System.DateTime.Now); gt.YEAR = System.DateTime.Now.Year; gt.BATCH_NO = Batch_No; gt.CAPACITY = int.Parse(Capacity); gt.CURRENT_WEIGHT = float.Parse(Current_Weight); gt.DEPARTMENT = StaticRes.Global.Current_User.DEPARTMENT; gt.DESCRIPTION = Description; if (Equip_ID.Length > 0) { gt.EQUIP_ID = Equip_ID; } else { gt.EQUIP_ID = ""; } gt.EXPIRY_DATETIME = DateTime.Parse(Expiry_Time); gt.PART_ID = Part_ID; gt.READY_DATETIME = DateTime.Parse(Ready_Time); gt.REMARKS = Remark; gt.SAPCODE = Sapcode; gt.START_WEIGHT = float.Parse(Start_Weight); gt.STATUS = StaticRes.Global.Status.Remove; gt.THAWING_DATETIME = DateTime.Parse(Thawing_Time); return(DataProvider.Rollback.Unload(gb, gt)); } #endregion }