public ReturnType AddStockInOut(StockInOut stockinout) { try { using (AladingEntities alading = new AladingEntities(AppSettings.GetConnectionString())) { alading.AddToStockInOut(stockinout); if (alading.SaveChanges() == 1) { return(ReturnType.Success); } else { return(ReturnType.PropertyExisted); } } } catch (SqlException sex) { return(ReturnType.ConnFailed); } catch (Exception ex) { return(ReturnType.OthersError); } }
public ReturnType RemoveStockInOutDetail(string stockInOutCode) { try { using (AladingEntities alading = new AladingEntities(AppSettings.GetConnectionString())) { var resultInOut = alading.StockInOut.Where(i => i.InOutCode == stockInOutCode); var resultDetails = alading.StockDetail.Where(v => v.InOutCode == stockInOutCode); if (resultInOut != null && resultInOut.Count() > 0) { foreach (StockInOut inOut in resultInOut) { alading.DeleteObject(inOut); } } foreach (StockDetail detail in resultDetails) { alading.DeleteObject(detail); } alading.SaveChanges(); return(ReturnType.Success); } } catch (Exception ex) { return(ReturnType.OthersError); } }
public ReturnType RemoveUserSalary(string usersalaryCode) { try { using (AladingEntities alading = new AladingEntities(AppSettings.GetConnectionString())) { /*List<UserSalary> list = alading.UserSalary.Where(p => p.UserSalaryID == usersalaryID).ToList();*/ List <UserSalary> list = alading.UserSalary.Where(p => p.UserSalaryCode == usersalaryCode).ToList(); if (list.Count == 0) { return(ReturnType.NotExisted); } else { UserSalary sy = list.First(); alading.DeleteObject(sy); alading.SaveChanges(); return(ReturnType.Success); } } } catch (SqlException sex) { return(ReturnType.ConnFailed); } catch (System.Exception ex) { return(ReturnType.OthersError); } }
public ReturnType RemoveJournalAccount(List <string> journalaccountCodeList) { try { using (AladingEntities alading = new AladingEntities(AppSettings.GetConnectionString())) { /*var result = alading.JournalAccount.Where(BuildWhereInExpression<JournalAccount, int>(v => v.JournalAccountID, journalaccountIDList));*/ var result = alading.JournalAccount.Where(BuildWhereInExpression <JournalAccount, string>(v => v.JournalAccountCode, journalaccountCodeList)); foreach (JournalAccount s in result) { alading.DeleteObject(s); } alading.SaveChanges(); return(ReturnType.Success); } } catch (SqlException sex) { return(ReturnType.ConnFailed); } catch (System.Exception ex) { return(ReturnType.OthersError); } }
public ReturnType UpdateStockLayout(StockLayout stocklayout) { try { using (AladingEntities alading = new AladingEntities(AppSettings.GetConnectionString())) { /*StockLayout result = alading.StockLayout.Where(p => p.StockLayoutID == stocklayout.StockLayoutID).FirstOrDefault();*/ StockLayout result = alading.StockLayout.FirstOrDefault(p => p.StockLayoutCode == stocklayout.StockLayoutCode); if (result == null) { return(ReturnType.NotExisted); } result.LayoutName = stocklayout.LayoutName; result.LayoutRemark = stocklayout.LayoutRemark; if (alading.SaveChanges() == 1) { return(ReturnType.Success); } return(ReturnType.OthersError); } } catch (SqlException sex) { return(ReturnType.ConnFailed); } catch (Exception ex) { return(ReturnType.OthersError); } }
public ReturnType RemoveUserSalary(List <string> usersalaryCodeList) { try { using (AladingEntities alading = new AladingEntities(AppSettings.GetConnectionString())) { /*var result = alading.UserSalary.Where(BuildWhereInExpression<UserSalary, int>(v => v.UserSalaryID, usersalaryIDList));*/ var result = alading.UserSalary.Where(BuildWhereInExpression <UserSalary, string>(v => v.UserSalaryCode, usersalaryCodeList)); foreach (UserSalary s in result) { alading.DeleteObject(s); } alading.SaveChanges(); return(ReturnType.Success); } } catch (SqlException sex) { return(ReturnType.ConnFailed); } catch (System.Exception ex) { return(ReturnType.OthersError); } }
public ReturnType RemovePicture(string pictureCode) { try { using (AladingEntities alading = new AladingEntities(AppSettings.GetConnectionString())) { /*List<StockItem> list = alading.StockItem.Where(p => p.StockItemID == stockitemID).ToList();*/ List <Picture> list = alading.Picture.Where(p => p.PictureCode == pictureCode).ToList(); if (list.Count == 0) { return(ReturnType.NotExisted); } else { Picture sy = list.First(); alading.DeleteObject(sy); alading.SaveChanges(); return(ReturnType.Success); } } } catch (SqlException sex) { return(ReturnType.ConnFailed); } catch (System.Exception ex) { return(ReturnType.OthersError); } }
public ReturnType RemoveShop(string sid) { try { using (AladingEntities alading = new AladingEntities(AppSettings.GetConnectionString())) { /*List<Shop> list = alading.Shop.Where(p => p.ShopID == shopID).ToList();*/ List <Shop> list = alading.Shop.Where(p => p.sid == sid).ToList(); if (list.Count == 0) { return(ReturnType.NotExisted); } else { Shop sy = list.First(); alading.DeleteObject(sy); alading.SaveChanges(); return(ReturnType.Success); } } } catch (SqlException sex) { return(ReturnType.ConnFailed); } catch (System.Exception ex) { return(ReturnType.OthersError); } }
public ReturnType RemovePurchaseOrder(string purchaseorderCode) { try { using (AladingEntities alading = new AladingEntities(AppSettings.GetConnectionString())) { /*List<PurchaseOrder> list = alading.PurchaseOrder.Where(p => p.PurchaseOrderID == purchaseorderID).ToList();*/ List <PurchaseOrder> list = alading.PurchaseOrder.Where(p => p.PurchaseOrderCode == purchaseorderCode).ToList(); if (list.Count == 0) { return(ReturnType.NotExisted); } else { PurchaseOrder sy = list.First(); alading.DeleteObject(sy); alading.SaveChanges(); return(ReturnType.Success); } } } catch (SqlException sex) { return(ReturnType.ConnFailed); } catch (System.Exception ex) { return(ReturnType.OthersError); } }
public ReturnType RemovePtAndPtM(string postage_id) { try { using (AladingEntities alading = new AladingEntities(AppSettings.GetConnectionString())) { /*List<Postage> list = alading.Postage.Where(p => p.PostageID == postageID).ToList();*/ List <Postage> postageList = alading.Postage.Where(p => p.postage_id == postage_id).ToList(); List <PostageMode> postageModeList = alading.PostageMode.Where(v => v.postage_id == postage_id).ToList(); if (postageList.Count == 0 || postageModeList.Count == 0) { return(ReturnType.NotExisted); } else { Postage sy = postageList.First(); alading.DeleteObject(sy); alading.DeleteObject(postageModeList); alading.SaveChanges(); return(ReturnType.Success); } } } catch (SqlException sex) { return(ReturnType.ConnFailed); } catch (System.Exception ex) { return(ReturnType.OthersError); } }
public ReturnType AddPurchaseOrder(PurchaseOrder purchaseorder) { try { using (AladingEntities alading = new AladingEntities(AppSettings.GetConnectionString())) { alading.AddToPurchaseOrder(purchaseorder); if (alading.SaveChanges() == 1) { return(ReturnType.Success); } else { return(ReturnType.PropertyExisted); } } } catch (SqlException sex) { return(ReturnType.ConnFailed); } catch (Exception ex) { return(ReturnType.OthersError); } }
public ReturnType RemovePurchaseOrder(List <string> purchaseorderCodeList) { try { using (AladingEntities alading = new AladingEntities(AppSettings.GetConnectionString())) { /*var result = alading.PurchaseOrder.Where(BuildWhereInExpression<PurchaseOrder, int>(v => v.PurchaseOrderID, purchaseorderIDList));*/ var result = alading.PurchaseOrder.Where(BuildWhereInExpression <PurchaseOrder, string>(v => v.PurchaseOrderCode, purchaseorderCodeList)); foreach (PurchaseOrder s in result) { alading.DeleteObject(s); } alading.SaveChanges(); return(ReturnType.Success); } } catch (SqlException sex) { return(ReturnType.ConnFailed); } catch (System.Exception ex) { return(ReturnType.OthersError); } }
public ReturnType RemoveTradeRefundMessage(int refundid) { try { using (AladingEntities alading = new AladingEntities(AppSettings.GetConnectionString())) { /*List<TradeRefundMessage> list = alading.TradeRefundMessage.Where(p => p.TradeRefundMessageID == traderefundmessageID).ToList();*/ List <TradeRefundMessage> list = alading.TradeRefundMessage.Where(p => p.refund_id == refundid).ToList(); if (list.Count == 0) { return(ReturnType.NotExisted); } else { TradeRefundMessage sy = list.First(); alading.DeleteObject(sy); alading.SaveChanges(); return(ReturnType.Success); } } } catch (SqlException sex) { return(ReturnType.ConnFailed); } catch (System.Exception ex) { return(ReturnType.OthersError); } }
public ReturnType AddTradeRefundMessage(TradeRefundMessage traderefundmessage) { try { using (AladingEntities alading = new AladingEntities(AppSettings.GetConnectionString())) { alading.AddToTradeRefundMessage(traderefundmessage); if (alading.SaveChanges() == 1) { return(ReturnType.Success); } else { return(ReturnType.PropertyExisted); } } } catch (SqlException sex) { return(ReturnType.ConnFailed); } catch (Exception ex) { return(ReturnType.OthersError); } }
public ReturnType RemovePicture(List <string> pictureCodeList) { try { using (AladingEntities alading = new AladingEntities(AppSettings.GetConnectionString())) { /*var result = alading.StockItem.Where(BuildWhereInExpression<StockItem, int>(v => v.StockItemID, stockitemIDList));*/ var result = alading.Picture.Where(BuildWhereInExpression <Picture, string>(v => v.PictureCode, pictureCodeList)); foreach (Picture s in result) { alading.DeleteObject(s); } alading.SaveChanges(); return(ReturnType.Success); } } catch (SqlException sex) { return(ReturnType.ConnFailed); } catch (System.Exception ex) { return(ReturnType.OthersError); } }
public ReturnType RemoveShop(List <string> sidList) { try { using (AladingEntities alading = new AladingEntities(AppSettings.GetConnectionString())) { /*var result = alading.Shop.Where(BuildWhereInExpression<Shop, int>(v => v.ShopID, shopIDList));*/ var result = alading.Shop.Where(BuildWhereInExpression <Shop, string>(v => v.sid, sidList)); foreach (Shop s in result) { alading.DeleteObject(s); } alading.SaveChanges(); return(ReturnType.Success); } } catch (SqlException sex) { return(ReturnType.ConnFailed); } catch (System.Exception ex) { return(ReturnType.OthersError); } }
public ReturnType UpdatePicture(Picture picture) { try { using (AladingEntities alading = new AladingEntities(AppSettings.GetConnectionString())) { Picture result = alading.Picture.Where(p => p.PictureCode == picture.PictureCode).FirstOrDefault(); if (result == null) { return(ReturnType.NotExisted); } alading.Attach(result); alading.ApplyPropertyChanges("Picture", picture); if (alading.SaveChanges() == 1) { return(ReturnType.Success); } return(ReturnType.OthersError); } } catch (SqlException sex) { return(ReturnType.ConnFailed); } catch (Exception ex) { return(ReturnType.OthersError); } }
public ReturnType UpdateSessionkey(string nick, string sessionkey, DateTime sessiontime) { try { using (AladingEntities alading = new AladingEntities(AppSettings.GetConnectionString())) { var result = alading.Shop.FirstOrDefault(s => s.nick == nick); if (result == null) { return(ReturnType.NotExisted); } else { result.SessionKey = sessionkey; result.SessionTime = sessiontime; } if (alading.SaveChanges() == 1) { return(ReturnType.Success); } else { return(ReturnType.OthersError); } } } catch (SqlException sex) { return(ReturnType.ConnFailed); } catch (System.Exception ex) { return(ReturnType.OthersError); } }
public ReturnType UpdatePicture(string outerID, Picture picture) { try { using (AladingEntities alading = new AladingEntities(AppSettings.GetConnectionString())) { Picture result = alading.Picture.FirstOrDefault(p => p.OuterID == outerID); if (result == null) { return(ReturnType.NotExisted); } result.PictureContent = picture.PictureContent; if (alading.SaveChanges() == 1) { return(ReturnType.Success); } return(ReturnType.OthersError); } } catch (SqlException sex) { return(ReturnType.ConnFailed); } catch (Exception ex) { return(ReturnType.OthersError); } }
public ReturnType AddStockLayout(StockLayout stocklayout) { try { using (AladingEntities alading = new AladingEntities(AppSettings.GetConnectionString())) { StockLayout result = alading.StockLayout.FirstOrDefault(i => i.StockLayoutCode == stocklayout.StockLayoutCode); if (result != null) { return(ReturnType.PropertyExisted); } alading.AddToStockLayout(stocklayout); if (alading.SaveChanges() == 1) { return(ReturnType.Success); } else { return(ReturnType.PropertyExisted); } } } catch (SqlException sex) { return(ReturnType.ConnFailed); } catch (Exception ex) { return(ReturnType.OthersError); } }
public ReturnType RemoveArea(List <string> idList) { throw new NotImplementedException(); try { using (AladingEntities alading = new AladingEntities(AppSettings.GetConnectionString())) { /*var result = alading.Area.Where(BuildWhereInExpression<Area, int>(v => v.AreaID, areaIDList));*/ var result = alading.Area.Where(BuildWhereInExpression <Area, string>(v => v.id, idList)); foreach (Area s in result) { alading.DeleteObject(s); } alading.SaveChanges(); return(ReturnType.Success); } } catch (SqlException sex) { return(ReturnType.ConnFailed); } catch (System.Exception ex) { return(ReturnType.OthersError); } }
public ReturnType AddUserSalary(UserSalary usersalary) { try { using (AladingEntities alading = new AladingEntities(AppSettings.GetConnectionString())) { alading.AddToUserSalary(usersalary); if (alading.SaveChanges() == 1) { return(ReturnType.Success); } else { return(ReturnType.PropertyExisted); } } } catch (SqlException sex) { return(ReturnType.ConnFailed); } catch (Exception ex) { return(ReturnType.OthersError); } }
public ReturnType RemoveArea(string id) { throw new NotImplementedException(); try { using (AladingEntities alading = new AladingEntities(AppSettings.GetConnectionString())) { /*List<Area> list = alading.Area.Where(p => p.AreaID == areaID).ToList();*/ List <Area> list = alading.Area.Where(p => p.id == id).ToList(); if (list.Count == 0) { return(ReturnType.NotExisted); } else { Area sy = list.First(); alading.DeleteObject(sy); alading.SaveChanges(); return(ReturnType.Success); } } } catch (SqlException sex) { return(ReturnType.ConnFailed); } catch (System.Exception ex) { return(ReturnType.OthersError); } }
public ReturnType AddJournalAccount(JournalAccount journalaccount) { try { using (AladingEntities alading = new AladingEntities(AppSettings.GetConnectionString())) { alading.AddToJournalAccount(journalaccount); if (alading.SaveChanges() == 1) { return(ReturnType.Success); } else { return(ReturnType.PropertyExisted); } } } catch (SqlException sex) { return(ReturnType.ConnFailed); } catch (Exception ex) { return(ReturnType.OthersError); } }
public ReturnType RemoveTradeRefundMessage(List <int> refundidList) { try { using (AladingEntities alading = new AladingEntities(AppSettings.GetConnectionString())) { /*var result = alading.TradeRefundMessage.Where(BuildWhereInExpression<TradeRefundMessage, int>(v => v.TradeRefundMessageID, traderefundmessageIDList));*/ var result = alading.TradeRefundMessage.Where(BuildWhereInExpression <TradeRefundMessage, int>(v => (int)v.refund_id, refundidList)); foreach (TradeRefundMessage s in result) { alading.DeleteObject(s); } alading.SaveChanges(); return(ReturnType.Success); } } catch (SqlException sex) { return(ReturnType.ConnFailed); } catch (System.Exception ex) { return(ReturnType.OthersError); } }
public ReturnType UpdateTradeOrder(string TradeOrderCode, TradeOrder tradeorder) { try { using (AladingEntities alading = new AladingEntities(AppSettings.GetConnectionString())) { /*var result = alading.TradeOrder.Where(p => p.TradeOrderID == tradeorderID).ToList();*/ var result = alading.TradeOrder.Where(p => p.TradeOrderCode == TradeOrderCode).ToList(); if (result.Count == 0) { return(ReturnType.NotExisted); } TradeOrder ob = result.First(); ob.CustomTid = tradeorder.CustomTid; ob.iid = tradeorder.iid; ob.sku_id = tradeorder.sku_id; ob.oid = tradeorder.oid; ob.outer_sku_id = tradeorder.outer_sku_id; ob.outer_iid = tradeorder.outer_iid; ob.sku_properties_name = tradeorder.sku_properties_name; ob.price = tradeorder.price; ob.total_fee = tradeorder.total_fee; ob.discount_fee = tradeorder.discount_fee; ob.adjust_fee = tradeorder.adjust_fee; ob.payment = tradeorder.payment; ob.item_meal_name = tradeorder.item_meal_name; ob.num = tradeorder.num; ob.title = tradeorder.title; ob.pic_path = tradeorder.pic_path; ob.seller_nick = tradeorder.seller_nick; ob.buyer_nick = tradeorder.buyer_nick; ob.type = tradeorder.type; ob.created = tradeorder.created; ob.refund_status = tradeorder.refund_status; ob.status = tradeorder.status; ob.snapshot_url = tradeorder.snapshot_url; ob.snapshot = tradeorder.snapshot; ob.timeout_action_time = tradeorder.timeout_action_time; if (alading.SaveChanges() == 1) { return(ReturnType.Success); } else { return(ReturnType.OthersError); } } } catch (SqlException sex) { return(ReturnType.ConnFailed); } catch (System.Exception ex) { return(ReturnType.OthersError); } }
public ReturnType UpdateConsumerVisit(ConsumerVisit consumervisit) { try { using (AladingEntities alading = new AladingEntities(AppSettings.GetConnectionString())) { /*ConsumerVisit result = alading.ConsumerVisit.Where(p => p.ConsumerVisitID == consumervisit.ConsumerVisitID).FirstOrDefault();*/ ConsumerVisit result = alading.ConsumerVisit.Where(p => p.VisitCode == consumervisit.VisitCode).FirstOrDefault(); if (result == null) { return(ReturnType.NotExisted); } #region Using Attach() Function Update,Default USE; alading.Attach(result); alading.ApplyPropertyChanges("ConsumerVisit", consumervisit); #endregion #region Using All Items Replace To Update ,Default UnUse /* * * result.Id = consumervisit.Id; * * result.VisitCode = consumervisit.VisitCode; * * result.ConsumerNick = consumervisit.ConsumerNick; * * result.Type = consumervisit.Type; * * result.Subject = consumervisit.Subject; * * result.Content = consumervisit.Content; * * result.VisitTime = consumervisit.VisitTime; * * result.Receiver = consumervisit.Receiver; * */ #endregion if (alading.SaveChanges() == 1) { return(ReturnType.Success); } else { return(ReturnType.OthersError); } } } catch (SqlException sex) { return(ReturnType.ConnFailed); } catch (Exception ex) { return(ReturnType.OthersError); } }
public ReturnType UpdateTradeInfo(TradeInfo tradeinfo) { try { using (AladingEntities alading = new AladingEntities(AppSettings.GetConnectionString())) { /*TradeInfo result = alading.TradeInfo.Where(p => p.TradeInfoID == tradeinfo.TradeInfoID).FirstOrDefault();*/ TradeInfo result = alading.TradeInfo.Where(p => p.TradeInfoCode == tradeinfo.TradeInfoCode).FirstOrDefault(); if (result == null) { return(ReturnType.NotExisted); } #region Using Attach() Function Update,Default USE; alading.Attach(result); alading.ApplyPropertyChanges("TradeInfo", tradeinfo); #endregion #region Using All Items Replace To Update ,Default UnUse /* * * result.TradeInfoCode = tradeinfo.TradeInfoCode; * * result.CustomTid = tradeinfo.CustomTid; * * result.Title = tradeinfo.Title; * * result.Content = tradeinfo.Content; * * result.AppendUserCode = tradeinfo.AppendUserCode; * * result.AppendUserName = tradeinfo.AppendUserName; * * result.AppendDepartment = tradeinfo.AppendDepartment; * * result.AppendTime = tradeinfo.AppendTime; * */ #endregion if (alading.SaveChanges() == 1) { return(ReturnType.Success); } else { return(ReturnType.OthersError); } } } catch (SqlException sex) { return(ReturnType.ConnFailed); } catch (Exception ex) { return(ReturnType.OthersError); } }
public ReturnType AddInOutAndDetails(StockInOut stockInOut, PayCharge payChage, List <StockDetail> sdList, List <StockHouseProduct> shpList, List <View_StockItemProduct> vsipList) { System.Data.Common.DbTransaction tran = null; using (AladingEntities alading = new AladingEntities(AppSettings.GetConnectionString())) { try { alading.Connection.Open(); tran = alading.Connection.BeginTransaction(); alading.AddToPayCharge(payChage); alading.AddToStockInOut(stockInOut); foreach (StockDetail sd in sdList) { alading.AddToStockDetail(sd); } foreach (StockHouseProduct shp in shpList) { StockHouseProduct tmpshp = alading.StockHouseProduct.FirstOrDefault(c => c.HouseProductCode == shp.HouseProductCode); if (tmpshp != null) { tmpshp.Num = shp.Num; } else { alading.AddToStockHouseProduct(shp); } } foreach (View_StockItemProduct vsip in vsipList) { StockItem stockItem = alading.StockItem.FirstOrDefault(s => s.OuterID == vsip.OuterID); StockProduct stockProduct = alading.StockProduct.FirstOrDefault(s => s.SkuOuterID == vsip.SkuOuterID); stockItem.TotalQuantity = Math.Round(vsip.TotalQuantity, 3); stockProduct.SkuQuantity = vsip.SkuQuantity; stockProduct.LastStockPrice = vsip.LastStockPrice; stockProduct.AvgStockPrice = vsip.AvgStockPrice; } alading.SaveChanges(); tran.Commit(); return(ReturnType.Success); } catch (System.Exception ex) { if (tran != null) { tran.Rollback(); } return(ReturnType.SaveFailed); } finally { if (alading != null && alading.Connection.State != System.Data.ConnectionState.Closed) { alading.Connection.Close(); } } } }
public ReturnType UpdateUserSalary(UserSalary usersalary) { try { using (AladingEntities alading = new AladingEntities(AppSettings.GetConnectionString())) { /*UserSalary result = alading.UserSalary.Where(p => p.UserSalaryID == usersalary.UserSalaryID).FirstOrDefault();*/ UserSalary result = alading.UserSalary.Where(p => p.UserSalaryCode == usersalary.UserSalaryCode).FirstOrDefault(); if (result == null) { return(ReturnType.NotExisted); } #region Using Attach() Function Update,Default USE; alading.Attach(result); alading.ApplyPropertyChanges("UserSalary", usersalary); #endregion #region Using All Items Replace To Update ,Default UnUse /* * result.UserSalaryCode = usersalary.UserSalaryCode; * result.nick = usersalary.nick; * result.UserCode = usersalary.UserCode; * result.Seller_nick = usersalary.Seller_nick; * result.Buyer_nick = usersalary.Buyer_nick; * result.iid = usersalary.iid; * result.Price = usersalary.Price; * result.Num = usersalary.Num; * result.TotlePrice = usersalary.TotlePrice; * result.Discount_fee = usersalary.Discount_fee; * result.Adjust_fee = usersalary.Adjust_fee; * result.Post_fee = usersalary.Post_fee; * result.Payment = usersalary.Payment; * result.Salary = usersalary.Salary; * result.TradeDate = usersalary.TradeDate; * */ #endregion if (alading.SaveChanges() == 1) { return(ReturnType.Success); } else { return(ReturnType.OthersError); } } } catch (SqlException sex) { return(ReturnType.ConnFailed); } catch (Exception ex) { return(ReturnType.OthersError); } }