public ReturnType AddUserStockHouse(UserStockHouse userstockhouse)
{
try
{
using (AladingEntities alading = new AladingEntities(AppSettings.GetConnectionString()))
{
alading.AddToUserStockHouse(userstockhouse);
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 RemoveUserStockHouse(long userstockhouseId)
{
try
{
using (AladingEntities alading = new AladingEntities(AppSettings.GetConnectionString()))
{
/*List<UserStockHouse> list = alading.UserStockHouse.Where(p => p.UserStockHouseID == userstockhouseID).ToList();*/
List <UserStockHouse> list = alading.UserStockHouse.Where(p => p.Id == userstockhouseId).ToList();
if (list.Count == 0)
{
return(ReturnType.NotExisted);
}
else
{
UserStockHouse 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 UpdateUserStockHouse(UserStockHouse userstockhouse)
{
try
{
using (AladingEntities alading = new AladingEntities(AppSettings.GetConnectionString()))
{
/*UserStockHouse result = alading.UserStockHouse.Where(p => p.UserStockHouseID == userstockhouse.UserStockHouseID).FirstOrDefault();*/
UserStockHouse result = alading.UserStockHouse.Where(p => p.Id == userstockhouse.Id).FirstOrDefault();
if (result == null)
{
return(ReturnType.NotExisted);
}
#region Using Attach() Function Update,Default USE;
alading.Attach(result);
alading.ApplyPropertyChanges("UserStockHouse", userstockhouse);
#endregion
#region Using All Items Replace To Update ,Default UnUse
/*
*
* result.Id = userstockhouse.Id;
*
* result.UserId = userstockhouse.UserId;
*
* result.StockHouseId = userstockhouse.StockHouseId;
*
* result.Enable = userstockhouse.Enable;
*
*/
#endregion
if (alading.SaveChanges() == 1)
{
return(ReturnType.Success);
}
else
{
return(ReturnType.OthersError);
}
}
}
catch (SqlException sex)
{
return(ReturnType.ConnFailed);
}
catch (Exception ex)
{
return(ReturnType.OthersError);
}
}
/// <summary>
/// 保存仓管
/// </summary>
private void SaveUserStockHouse()
{
TreeListNode node = tLRole.Nodes[5];
if (node.Nodes.Count > 0)
{
foreach (TreeListNode x in node.Nodes)
{
if (x.Checked == true)
{
UserStockHouse ush = new UserStockHouse();
ush.UserCode = selectedUser.UserCode;
ush.StockHouseCode = x.Tag.ToString();
Alading.Business.UserStockHouseService.AddUserStockHouse(ush);
}
}
}
}
public ReturnType UpdateUserStockHouse(long userstockhouseId, UserStockHouse userstockhouse)
{
try
{
using (AladingEntities alading = new AladingEntities(AppSettings.GetConnectionString()))
{
/*var result = alading.UserStockHouse.Where(p => p.UserStockHouseID == userstockhouseID).ToList();*/
var result = alading.UserStockHouse.Where(p => p.Id == userstockhouseId).ToList();
if (result.Count == 0)
{
return(ReturnType.NotExisted);
}
UserStockHouse ob = result.First();
ob.Id = userstockhouse.Id;
ob.UserCode = userstockhouse.UserCode;
ob.StockHouseCode = userstockhouse.StockHouseCode;
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 UpdateUser(User user, List <Role> roles, List <Shop> shops, List <StockHouse> houses)
{
System.Data.Common.DbTransaction tran = null;
using (AladingEntities alading = new AladingEntities(AppSettings.GetConnectionString()))
{
try
{
alading.Connection.Open();
tran = alading.Connection.BeginTransaction();
User u1 = alading.User.FirstOrDefault(c => c.UserCode == user.UserCode);
if (u1 != null)
{
//更新用户
alading.Attach(u1);
alading.ApplyPropertyChanges("User", user);
//更新用户角色
var result1 = alading.UserRole.Where(c => c.UserCode == u1.UserCode);
foreach (UserRole s1 in result1)
{
alading.DeleteObject(s1);
}
alading.SaveChanges();
foreach (var i1 in roles)
{
UserRole e1 = new UserRole
{
UserRoleCode = Guid.NewGuid().ToString(),
UserCode = u1.UserCode,
RoleCode = i1.RoleCode,
RoleType = i1.RoleType,
};
alading.AddToUserRole(e1);
}
alading.SaveChanges();
//更新用户和店铺的关联
var return2 = alading.UserShop.Where(c => c.UserCode == u1.UserCode);
foreach (UserShop s2 in return2)
{
alading.DeleteObject(s2);
}
alading.SaveChanges();
foreach (var i2 in shops)
{
UserShop e2 = new UserShop
{
UserCode = u1.UserCode,
ShopId = i2.sid,
};
alading.AddToUserShop(e2);
}
alading.SaveChanges();
//更新用户和仓库的关联
var return3 = alading.UserStockHouse.Where(c => c.UserCode == u1.UserCode);
foreach (UserStockHouse s3 in return3)
{
alading.DeleteObject(s3);
}
alading.SaveChanges();
foreach (var i3 in houses)
{
UserStockHouse e3 = new UserStockHouse
{
UserCode = u1.UserCode,
StockHouseCode = i3.StockHouseCode,
};
alading.AddToUserStockHouse(e3);
}
alading.SaveChanges();
tran.Commit();
return(ReturnType.Success);
}
else
{
return(ReturnType.NotExisted);
}
}
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 static ReturnType UpdateUserStockHouse(long userstockhouseID, UserStockHouse userstockhouse)
{
return(DataProviderClass.Instance().UpdateUserStockHouse(userstockhouseID, userstockhouse));
}
public static ReturnType AddUserStockHouse(UserStockHouse userstockhouse)
{
return(DataProviderClass.Instance().AddUserStockHouse(userstockhouse));
}
