/// <summary>
/// 仓库结构修改
/// </summary>
public int StoreStructUpdate(params string[] store)
{
int count = 0;
using (StoreAccess access = new StoreAccess(true))
{
try
{
access.Open();
access.BeginTransaction();
string strSQL = access.CommandFormate("UPDATE [dbo].[Table_Warehouse] SET [StoreStaus] = {0}StoreStaus,[Type]={0}Type WHERE [Row]={0}Row AND [Column]={0}Column AND [Layer]={0}Layer");
count = access.Update(strSQL, (parmarter) =>
{
parmarter.Add(parmarter.CreateParameter("StoreStaus", store[0]));
parmarter.Add(parmarter.CreateParameter("Type", store[1]));
parmarter.Add(parmarter.CreateParameter("Row", store[2]));
parmarter.Add(parmarter.CreateParameter("Column", store[3]));
parmarter.Add(parmarter.CreateParameter("Layer", store[4]));
});
access.Commit();
}
catch (DbException ex)
{
LogBusiness.RecordLog("管理员", ex.Message, "修改仓库结构数据操作异常");
access.RollBack();
access.Close();
}
}
return(count);
}
/// <summary>
/// 修改
/// </summary>
/// <param name="user"></param>
/// <returns></returns>
public int ResizeAcount(User user)
{
int num = 0;
using (StoreAccess access = new StoreAccess(true))
{
try
{
access.Open();
access.BeginTransaction();
num = access.Update <User>(user);
access.Commit();
}
catch (Exception ex)
{
access.RollBack();
access.Close();
}
}
return(num);
}