public static T_TMS_External_Atd_ScanTime UpdateItem(T_TMS_External_Atd_ScanTime model) { Guid result = Guid.Empty; using (var reader = SqlHelper.ExecuteReaderService(ModuleConfig.MyConnection, CommandType.StoredProcedure, "T_TMS_External_Atd_ScanTime_Update", CreateSqlParameter(model))) { while (reader.Read()) { result = (Guid)reader[0]; } } return(GetItemByID(result)); }
public static T_TMS_External_Atd_ScanTimeCollection Search(SearchFilter SearchKey) { T_TMS_External_Atd_ScanTimeCollection collection = new T_TMS_External_Atd_ScanTimeCollection(); using (var reader = SqlHelper.ExecuteReaderService(ModuleConfig.MyConnection, "T_TMS_External_Atd_ScanTime_Search", SearchFilterManager.SqlSearchConditionNoCompany(SearchKey))) { while (reader.Read()) { T_TMS_External_Atd_ScanTime obj = new T_TMS_External_Atd_ScanTime(); obj = GetItemFromReader(reader); collection.Add(obj); } } return(collection); }
public static T_TMS_External_Atd_ScanTimeCollection GetAllItem() { T_TMS_External_Atd_ScanTimeCollection collection = new T_TMS_External_Atd_ScanTimeCollection(); using (var reader = SqlHelper.ExecuteReaderService(ModuleConfig.MyConnection, "T_TMS_External_Atd_ScanTime_GetAll", null)) { while (reader.Read()) { T_TMS_External_Atd_ScanTime obj = new T_TMS_External_Atd_ScanTime(); obj = GetItemFromReader(reader); collection.Add(obj); } } return(collection); }
public static T_TMS_External_Atd_ScanTime GetItemByID(Guid ID) { T_TMS_External_Atd_ScanTime item = new T_TMS_External_Atd_ScanTime(); var sqlParams = new SqlParameter[1]; sqlParams[0] = new SqlParameter("@ID", ID); using (var reader = SqlHelper.ExecuteReaderService(ModuleConfig.MyConnection, "T_TMS_External_Atd_ScanTime_GetByID", sqlParams)) { while (reader.Read()) { item = GetItemFromReader(reader); } } return(item); }
private static T_TMS_External_Atd_ScanTime GetItemFromReader(IDataReader dataReader) { T_TMS_External_Atd_ScanTime objItem = new T_TMS_External_Atd_ScanTime(); objItem.Scan_Time = SqlHelper.GetString(dataReader, "Scan_Time"); objItem.Bar_Code = SqlHelper.GetString(dataReader, "Bar_Code"); objItem.Reader_ID = SqlHelper.GetString(dataReader, "Reader_ID"); objItem.Manual_Input = SqlHelper.GetBoolean(dataReader, "Manual_Input"); objItem.In1Out0 = SqlHelper.GetBoolean(dataReader, "In1Out0"); objItem.Work_Date = SqlHelper.GetDateTime(dataReader, "Work_Date"); objItem.Is_Over = SqlHelper.GetBoolean(dataReader, "Is_Over"); objItem.RecordStatus = SqlHelper.GetBoolean(dataReader, "RecordStatus"); objItem.Is_OverF = SqlHelper.GetBoolean(dataReader, "Is_OverF"); objItem.ID = SqlHelper.GetGuid(dataReader, "ID"); objItem.Shift_ID = SqlHelper.GetInt(dataReader, "Shift_ID"); objItem.IsValid = SqlHelper.GetBoolean(dataReader, "IsValid"); objItem.RootScan = SqlHelper.GetString(dataReader, "RootScan"); objItem.ScanTimeIn_Edit = SqlHelper.GetString(dataReader, "ScanTimeIn_Edit"); objItem.CreateDate = SqlHelper.GetDateTime(dataReader, "CreateDate"); objItem.IsCopy = SqlHelper.GetBoolean(dataReader, "IsCopy"); if (SqlHelper.ColumnExists(dataReader, "TotalRecord")) { objItem.TotalRecord = SqlHelper.GetInt(dataReader, "TotalRecord"); } return(objItem); }
private static SqlParameter[] CreateSqlParameter(T_TMS_External_Atd_ScanTime model) { return(new SqlParameter[] { new SqlParameter("@Scan_Time", model.Scan_Time), new SqlParameter("@Bar_Code", model.Bar_Code), new SqlParameter("@Reader_ID", model.Reader_ID), new SqlParameter("@Manual_Input", model.Manual_Input), new SqlParameter("@In1Out0", model.In1Out0), new SqlParameter("@Work_Date", model.Work_Date), new SqlParameter("@Is_Over", model.Is_Over), new SqlParameter("@RecordStatus", model.RecordStatus), new SqlParameter("@Is_OverF", model.Is_OverF), new SqlParameter("@ID", model.ID), new SqlParameter("@Shift_ID", model.Shift_ID), new SqlParameter("@IsValid", model.IsValid), new SqlParameter("@RootScan", model.RootScan), new SqlParameter("@ScanTimeIn_Edit", model.ScanTimeIn_Edit), new SqlParameter("@CreateDate", model.CreateDate), new SqlParameter("@IsCopy", model.IsCopy), }); }