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