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