public ReturnType IsAuthorizeExisted(string nick, string cid) { try { using (AladingEntities alading = new AladingEntities(AppSettings.GetConnectionString())) { ItemSellerAuthorize result = alading.ItemSellerAuthorize.Where(a => a.SellerNick == nick && a.Cid == cid).FirstOrDefault(); if (result == null) { return(ReturnType.NotExisted); } else { return(ReturnType.PropertyExisted); } } } catch (SqlException sex) { return(ReturnType.ConnFailed); } catch (Exception ex) { return(ReturnType.OthersError); } }
public ReturnType UpdateItemSellerAuthorize(ItemSellerAuthorize itemsellerauthorize) { try { using (AladingEntities alading = new AladingEntities(AppSettings.GetConnectionString())) { ItemSellerAuthorize result = alading.ItemSellerAuthorize.Where(p => p.SellerNick == itemsellerauthorize.SellerNick && p.Cid == itemsellerauthorize.Cid).FirstOrDefault(); if (result == null) { return(ReturnType.NotExisted); } result.Name = itemsellerauthorize.Name; alading.SaveChanges(); return(ReturnType.Success); } } catch (SqlException sex) { return(ReturnType.ConnFailed); } catch (Exception ex) { return(ReturnType.OthersError); } }
public ReturnType RemoveItemSellerAuthorize(string itemsellerauthorizeCode) { try { using (AladingEntities alading = new AladingEntities(AppSettings.GetConnectionString())) { /*List<ItemSellerAuthorize> list = alading.ItemSellerAuthorize.Where(p => p.ItemSellerAuthorizeID == itemsellerauthorizeID).ToList();*/ List <ItemSellerAuthorize> list = alading.ItemSellerAuthorize.Where(p => p.ItemSellerAuthorizeCode == itemsellerauthorizeCode).ToList(); if (list.Count == 0) { return(ReturnType.NotExisted); } else { ItemSellerAuthorize 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 UpdateItemSellerAuthorize(string itemsellerauthorizeCode, ItemSellerAuthorize itemsellerauthorize) { try { using (AladingEntities alading = new AladingEntities(AppSettings.GetConnectionString())) { /*var result = alading.ItemSellerAuthorize.Where(p => p.ItemSellerAuthorizeID == itemsellerauthorizeID).ToList();*/ var result = alading.ItemSellerAuthorize.Where(p => p.ItemSellerAuthorizeCode == itemsellerauthorizeCode).ToList(); if (result.Count == 0) { return(ReturnType.NotExisted); } ItemSellerAuthorize ob = result.First(); ob.ItemSellerAuthorizeCode = itemsellerauthorize.ItemSellerAuthorizeCode; ob.Cid = itemsellerauthorize.Cid; ob.Name = itemsellerauthorize.Name; ob.SellerNick = itemsellerauthorize.SellerNick; 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 static ReturnType UpdateItemSellerAuthorize(string itemsellerauthorizeCode, ItemSellerAuthorize itemsellerauthorize) { return(DataProviderClass.Instance().UpdateItemSellerAuthorize(itemsellerauthorizeCode, itemsellerauthorize)); }
/// <summary> /// 存在即更新,不存在则添加 /// </summary> /// <param name="itemsellerauthorize"></param> /// <returns></returns> public static ReturnType AddItemSellerAuthorize(ItemSellerAuthorize itemsellerauthorize) { return(DataProviderClass.Instance().AddItemSellerAuthorize(itemsellerauthorize)); }