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