public static List <RoomStandardItem> GetAll(string constructionCode, string planNo) { var items = new List <RoomStandardItem>(); bool isUsingNew; if (string.IsNullOrEmpty(constructionCode) || string.IsNullOrEmpty(planNo)) { isUsingNew = false; } else { var siyoCode = tbl_siyo_boss.GetSiyoCode(constructionCode, planNo); isUsingNew = IsUsingNew(constructionCode, siyoCode); } if (isUsingNew) { var newItems = RoomStandardNewItem.GetAll(); newItems.ForEach(p => items.Add(Convert(p))); } else { var oldItems = RoomStandardOldItem.GetAll(); oldItems.ForEach(p => items.Add(Convert(p))); } return(items); }
public static void Delete(int roomId, bool isUsingNew) { if (isUsingNew) { var db = RoomStandardNewItem.GetDatabase(); db.ExecuteNonQuery("DELETE FROM RoomStandardNewItems WHERE RoomId = " + roomId); } else { var db = RoomStandardOldItem.GetDatabase(); db.ExecuteNonQuery("DELETE FROM RoomStandardOldItems WHERE RoomId = " + roomId); } }
private static RoomStandardOldItem ConvertToOld(RoomStandardItem souce) { var oldItem = new RoomStandardOldItem(); oldItem.RoomId = souce.RoomId; oldItem.JyouConditionLower = souce.JyouConditionLower; oldItem.JyouConditionUpper = souce.JyouConditionUpper; oldItem.ItemName = souce.ItemName; oldItem.Quantity = souce.Quantity; oldItem.UpdatedDateTime = souce.UpdatedDateTime; return(oldItem); }
public static List <RoomStandardItem> GetAll(bool isUsingNew, int roomId) { var items = new List <RoomStandardItem>(); if (isUsingNew) { var newItems = RoomStandardNewItem.Get(roomId); newItems.ForEach(p => items.Add(Convert(p))); } else { var oldItems = RoomStandardOldItem.Get(roomId); oldItems.ForEach(p => items.Add(Convert(p))); } return(items); }