/// <summary> /// 修改菜单信息 /// </summary> /// <param name="menuInfo"></param> /// <returns></returns> public bool UpdateMenuInfo(MenuInfoModel menuInfo, bool blUpdate) { List <CommandInfo> comList = new List <CommandInfo>(); string cols = "MId,MName,ParentId,ParentName,MKey,MUrl,IsTop,MOrder,MDesp"; SqlModel upModel = CreateSql.GetUpdateSqlAndParas(menuInfo, cols, ""); //修改指定的菜单信息 comList.Add(new CommandInfo() { CommandText = upModel.Sql, IsProc = false, Paras = upModel.SqlParaArray }); if (blUpdate) { string sqlUpdateParentName = "update MenuInfos set ParentName=@parentName where ParentId=@menuId"; SqlParameter[] paras = { new SqlParameter("@parentName", menuInfo.MName), new SqlParameter("@menuId", menuInfo.MId) }; comList.Add(new CommandInfo() { CommandText = sqlUpdateParentName, IsProc = false, Paras = paras }); } return(SqlHelper.ExecuteTrans(comList)); }
/// <summary> /// 更新商品类别信息 /// </summary> /// <param name="gtInfo"></param> /// <param name="blUpdate"></param> /// <returns></returns> public bool UpdateGoodsType(GoodsTypeInfoModel gtInfo, bool blUpdate) { List <CommandInfo> list = new List <CommandInfo>(); string cols = "GTypeId,GTypeName,ParentId,ParentName,GTypeNo,GTPYNo,GTOrder"; SqlModel upModel = CreateSql.GetUpdateSqlAndParas(gtInfo, cols, ""); list.Add(new CommandInfo() { CommandText = upModel.Sql, IsProc = false, Paras = upModel.SqlParaArray }); if (blUpdate) { SqlParameter[] paras = { new SqlParameter("@ParentName", gtInfo.GTypeName), new SqlParameter("@ParentId", gtInfo.GTypeId) }; list.Add(new CommandInfo() { CommandText = "update GoodsTypeInfos set ParentName=@ParentName where ParentId=@ParentId", IsProc = false, Paras = paras }); } return(SqlHelper.ExecuteTrans(list)); }
/// <summary> /// 修改单位信息 isUpdateName:单位名称是否修改 /// </summary> /// <param name="guInfo"></param> /// <returns></returns> public bool UpdatGoodsUnit(GoodsUnitInfoModel guInfo, bool isUpdateName, string oldName) { string cols = "GUnitId,GUnitName,GUnitPYNo,GUnitOrder"; if (!isUpdateName) { return(Update(guInfo, cols, "")); } else { List <CommandInfo> list = new List <CommandInfo>(); SqlModel upModel = CreateSql.GetUpdateSqlAndParas(guInfo, cols, ""); SqlParameter[] paras = { new SqlParameter("@GUnit", guInfo.GUnitName), new SqlParameter("@OldGUnit", oldName), }; list.Add(new CommandInfo() { CommandText = upModel.Sql, IsProc = false, Paras = upModel.SqlParaArray }); list.Add(new CommandInfo() { CommandText = "update GoodsInfos set GUnit=@GUnit where GUnit=@OldGUnit", IsProc = false, Paras = paras }); return(SqlHelper.ExecuteTrans(list)); } }
/// <summary> /// 批量修改 /// </summary> /// <param name="list"></param> /// <param name="strCols"></param> /// <returns></returns> public bool UpdateList(List <T> list, string strCols) { if (list == null || list.Count == 0) { return(false); } List <CommandInfo> comList = new List <CommandInfo>(); foreach (T t in list) { SqlModel update = CreateSql.GetUpdateSqlAndParas <T>(t, strCols, ""); CommandInfo com = new CommandInfo(update.Sql, false, update.SqlParaArray); comList.Add(com); } return(SqlHelper.ExecuteTrans(comList)); }
/// <summary> /// 修改用户信息 /// </summary> /// <param name="userInfo"></param> /// <param name="urList"></param> /// <param name="urListNew"></param> /// <returns></returns> public bool UpdateUserInfo(UserInfoModel userInfo, List <UserRoleInfoModel> urList, List <UserRoleInfoModel> urListNew) { List <CommandInfo> comList = new List <CommandInfo>(); string colsUser = "******"; if (!string.IsNullOrEmpty(userInfo.UserPwd)) { colsUser += ",UserPwd"; } colsUser += ",UserState"; SqlModel upUser = CreateSql.GetUpdateSqlAndParas(userInfo, colsUser, ""); //修改用户信息 comList.Add(new CommandInfo() { CommandText = upUser.Sql, IsProc = false, Paras = upUser.SqlParaArray }); if (urList.Count > 0) { //删除取消的角色关系数据 string roleIds = string.Join(",", urList.Select(ur => ur.RoleId)); comList.Add(new CommandInfo() { CommandText = $"delete from UserRoleInfos where RoleId not in ({roleIds}) and UserId={userInfo.UserId}", IsProc = false }); } if (urListNew.Count > 0) { //新增新设置的角色关系 string colsUserRole = "UserId,RoleId,Creator"; foreach (var ur in urListNew) { SqlModel inUserRole = CreateSql.GetInsertSqlAndParas <UserRoleInfoModel>(ur, colsUserRole, 0); comList.Add(new CommandInfo() { CommandText = inUserRole.Sql, IsProc = false, Paras = inUserRole.SqlParaArray }); } } return(SqlHelper.ExecuteTrans(comList)); }
/// <summary> /// 修改信息实体 /// </summary> /// <param name="t"></param> /// <param name="strCols">要修改的列</param> /// <param name="strWhere">条件 </param> /// <returns></returns> public bool Update(T t, string strCols, string strWhere, params SqlParameter[] paras) { if (t == null) { return(false); } //获取生成的sql和参数列表 SqlModel update = CreateSql.GetUpdateSqlAndParas <T>(t, strCols, strWhere); List <SqlParameter> listParas = update.SqlParaArray.ToList(); if (paras != null && paras.Length > 0) { listParas.AddRange(paras); } //执行sql命令 return(SqlHelper.ExecuteNonQuery(update.Sql, 1, listParas.ToArray()) > 0); }
/// <summary> /// 保存上下限设置 /// </summary> /// <param name="goodsStockList"></param> /// <returns></returns> public bool SetGoodsStockUpDown(List <StoreGoodsStockInfoModel> goodsStockList) { string upCols = "StoreGoodsId,StockUp,StockDown"; List <CommandInfo> list = new List <CommandInfo>(); foreach (var gupdown in goodsStockList) { SqlModel sqlModel = CreateSql.GetUpdateSqlAndParas(gupdown, upCols, ""); list.Add(new CommandInfo() { CommandText = sqlModel.Sql, IsProc = false, Paras = sqlModel.SqlParaArray }); } return(SqlHelper.ExecuteTrans(list)); }
/// <summary> /// 更新入库单信息 /// </summary> /// <param name="stockInfo"></param> /// <param name="stockGoodsList"></param> /// <returns></returns> public bool UpdateStockInfo(StockStoreInfoModel stockInfo, List <StStockGoodsInfoModel> stockGoodsList) { string cols = "StockId,StoreId,DealPerson,Remark"; string sgCols = "StockId,GoodsId,StCount,StPrice,StAmount,Remark"; List <CommandInfo> comList = new List <CommandInfo>(); SqlModel upStock = CreateSql.GetUpdateSqlAndParas <StockStoreInfoModel>(stockInfo, cols, ""); //修改入库单信息 comList.Add(new CommandInfo() { CommandText = upStock.Sql, IsProc = false, Paras = upStock.SqlParaArray }); //删除已移除的商品明细数据 //商品明细编号集合字符串 string goodsIds = string.Join(",", stockGoodsList.Select(g => g.GoodsId)); comList.Add(new CommandInfo() { CommandText = $"delete from StStockGoodsInfos where StockId ={stockInfo.StockId} and GoodsId not in ({goodsIds})", IsProc = false }); //明细商品列表保存:修改、添加 两种 foreach (StStockGoodsInfoModel sg in stockGoodsList) { if (sgDAL.ExistsGoods(stockInfo.StockId, sg.GoodsId)) { string upSql = "update StStockGoodsInfos set StCount=@count,StPrice=@stPrice,StAmount=@stAmount,Remark=@remark where StockId=@stockId and GoodsId=@goodsId"; SqlParameter[] paras = { new SqlParameter("@stockId", stockInfo.StockId), new SqlParameter("@goodsId", sg.GoodsId), new SqlParameter("@count", sg.StCount), new SqlParameter("@stPrice", sg.StPrice), new SqlParameter("@remark", sg.Remark), new SqlParameter("@stAmount", sg.StAmount) }; comList.Add(new CommandInfo() { CommandText = upSql, IsProc = false, Paras = paras }); } else//新增处理 { sg.StockId = stockInfo.StockId; SqlModel inStStockGoods = CreateSql.GetInsertSqlAndParas <StStockGoodsInfoModel>(sg, sgCols, 0); comList.Add(new CommandInfo() { CommandText = inStStockGoods.Sql, IsProc = false, Paras = inStStockGoods.SqlParaArray }); } } return(SqlHelper.ExecuteTrans(comList)); }
/// <summary> /// 更新采购单信息 /// </summary> /// <param name="perchaseInfo"></param> /// <param name="perGoodsList"></param> /// <returns></returns> public bool UpdatePerchaseInfo(PerchaseInStoreInfoModel perchaseInfo, List <PerchaseGoodsInfoModel> perGoodsList) { string cols = "UnitId,StoreId,DealPerson,PayDesp,ThisAmount,Remark,TotalAmount,YHAmount,PerId"; if (perchaseInfo.PayTime != null) { cols += ",PayTime,IsPayed"; } if (perchaseInfo.IsPayFull == 1) { cols += ",IsPayFull"; } //插入采购商品列表的列名 string pgCols = "PerId,GoodsId,GUnit,Count,PerPrice,Amount,Remark"; List <CommandInfo> comList = new List <CommandInfo>(); SqlModel upStock = CreateSql.GetUpdateSqlAndParas(perchaseInfo, cols, ""); //修改采购单信息 comList.Add(new CommandInfo() { CommandText = upStock.Sql, IsProc = false, Paras = upStock.SqlParaArray }); //删除已移除的商品明细数据 //商品明细编号集合字符串 string goodsIds = string.Join(",", perGoodsList.Select(g => g.GoodsId)); comList.Add(new CommandInfo() { CommandText = $"delete from PerchaseGoodsInfos where PerId ={perchaseInfo.PerId} and GoodsId not in ({goodsIds})", IsProc = false }); //明细商品列表保存:修改、添加 两种 foreach (PerchaseGoodsInfoModel sg in perGoodsList) { if (pgDAL.ExistsGoods(perchaseInfo.PerId, sg.GoodsId)) { string upSql = "update PerchaseGoodsInfos set Count=@count,PerPrice=@perPrice,Amount=@Amount,Remark=@remark where PerId=@perId and GoodsId=@goodsId"; SqlParameter[] paras = { new SqlParameter("@perId", perchaseInfo.PerId), new SqlParameter("@goodsId", sg.GoodsId), new SqlParameter("@count", sg.Count), new SqlParameter("@perPrice", sg.PerPrice), new SqlParameter("@remark", sg.Remark), new SqlParameter("@Amount", sg.Amount) }; comList.Add(new CommandInfo() { CommandText = upSql, IsProc = false, Paras = paras }); } else//新增处理 { sg.PerId = perchaseInfo.PerId; SqlModel inStStockGoods = CreateSql.GetInsertSqlAndParas(sg, pgCols, 0); comList.Add(new CommandInfo() { CommandText = inStStockGoods.Sql, IsProc = false, Paras = inStStockGoods.SqlParaArray }); } } return(SqlHelper.ExecuteTrans(comList)); }