/// <summary> /// 获取客户分组信息 /// </summary> /// <param name="UserId"></param> /// <returns></returns> public static UserGroups GetUserGroups(string UserId) { System.Data.Common.DbDataReader dbreader = null; UserGroups ugs = new UserGroups(); ugs.UserGroupId = string.Empty; ugs.UserGroupName = string.Empty; ugs.IsDefaultGroup = 0; ugs.AfterSecond = 0; ugs.PlaceOrderSlipPoint = 0; ugs.FlatOrderSlipPoint = 0; ugs.DelayPlaceOrder = 0; ugs.DelayFlatOrder = 0; try { string sql = string.Format( @"select a.UserGroupId, a.UserGroupName,a.IsDefaultGroup, a.AfterSecond, a.PlaceOrderSlipPoint, a.FlatOrderSlipPoint, a.DelayPlaceOrder, a.DelayFlatOrder from Trade_UserGroups a,Trade_User_Group b where a.UserGroupId=b.UserGroupId and b.userid=@userid"); //使用参数化的sql语句,防止sql注入 dbreader = DbHelper.ExecuteReader(sql, new System.Data.Common.DbParameter[] { DbHelper.CreateDbParameter(JinTong.Jyrj.Data.DataBase.Type, "@userid", DbParameterType.String, UserId, ParameterDirection.Input) }); if (dbreader.Read()) { ugs.UserGroupId = dbreader["UserGroupId"].ToString(); ugs.UserGroupName = System.DBNull.Value != dbreader["UserGroupName"] ? dbreader["UserGroupName"].ToString() : string.Empty; ugs.IsDefaultGroup = System.DBNull.Value != dbreader["IsDefaultGroup"] ? Convert.ToInt32(dbreader["IsDefaultGroup"]) : 0; ugs.AfterSecond = System.DBNull.Value != dbreader["AfterSecond"] ? Convert.ToInt32(dbreader["AfterSecond"]) : 0; ugs.PlaceOrderSlipPoint = System.DBNull.Value != dbreader["PlaceOrderSlipPoint"] ? Convert.ToInt32(dbreader["PlaceOrderSlipPoint"]) : 0; ugs.FlatOrderSlipPoint = System.DBNull.Value != dbreader["FlatOrderSlipPoint"] ? Convert.ToInt32(dbreader["FlatOrderSlipPoint"]) : 0; ugs.DelayPlaceOrder = System.DBNull.Value != dbreader["DelayPlaceOrder"] ? Convert.ToDouble(dbreader["DelayPlaceOrder"]) : 0; ugs.DelayFlatOrder = System.DBNull.Value != dbreader["DelayFlatOrder"] ? Convert.ToDouble(dbreader["DelayFlatOrder"]) : 0; } } catch (Exception ex) { ComFunction.WriteErr(ex); } finally { if (null != dbreader) { dbreader.Close(); dbreader.Dispose(); } } return ugs; }
/// <summary> /// 2.3.4.4 修改客户组 /// </summary> /// <param name="ugs"></param> /// <param name="LoginId"></param> /// <returns></returns> public ResultDesc ModifyUserGroups(UserGroups ugs, String LoginId) { ResultDesc rsdc = new ResultDesc(); string operUser = string.Empty;//操作人 try { TradeUser TdUser = new TradeUser(); #region 判断登陆标识是否过期 if (!ComFunction.ExistUserLoginID(LoginId, ref TdUser)) { rsdc.Result = false; rsdc.Desc = ResCode.UL003Desc; return rsdc; } if (UserType.NormalType == TdUser.UType) { rsdc.Result = false; rsdc.Desc = ComFunction.NotRightUser; return rsdc; } operUser = TdUser.Account; #endregion if (string.IsNullOrEmpty(ugs.UserGroupName)) { rsdc.Result = false; rsdc.Desc = "客户组名称不能为空"; return rsdc; } List<string> sqlList = new List<string>(); StringBuilder strbld = new StringBuilder(); strbld.Append("update Trade_UserGroups set "); strbld.AppendFormat(" UserGroupName='{0}',", string.IsNullOrEmpty(ugs.UserGroupName) ? string.Empty : ugs.UserGroupName); strbld.AppendFormat(" IsDefaultGroup={0},", ugs.IsDefaultGroup); strbld.AppendFormat(" AfterSecond={0},", ugs.AfterSecond); strbld.AppendFormat(" PlaceOrderSlipPoint={0},", ugs.PlaceOrderSlipPoint); strbld.AppendFormat(" FlatOrderSlipPoint={0},", ugs.FlatOrderSlipPoint); strbld.AppendFormat(" DelayPlaceOrder={0},", ugs.DelayPlaceOrder); strbld.AppendFormat(" DelayFlatOrder={0} ", ugs.DelayFlatOrder); strbld.AppendFormat(" where UserGroupId='{0}'", ugs.UserGroupId); sqlList.Add(strbld.ToString()); if (1 == ugs.IsDefaultGroup)//如果修改的组被设置为默认组时,需要把其他组全部修改为非默认组 { sqlList.Add(string.Format("update Trade_UserGroups set IsDefaultGroup=0 where UserGroupId<>'{0}'", ugs.UserGroupId)); } if (!ComFunction.SqlTransaction(sqlList)) { rsdc.Result = false; rsdc.Desc = "修改客户组出错"; return rsdc; } rsdc.Result = true; rsdc.Desc = "修改客户组成功"; } catch (Exception ex) { ComFunction.WriteErr(ex); rsdc.Result = false; rsdc.Desc = "修改客户组失败"; } return rsdc; }
/// <summary> /// 2.3.4.2 添加客户组 /// </summary> /// <param name="ugs"></param> /// <param name="LoginId"></param> /// <returns></returns> public ResultDesc AddUserGroups(UserGroups ugs, String LoginId) { ResultDesc rsdc = new ResultDesc(); string operUser = string.Empty;//操作人 try { TradeUser TdUser = new TradeUser(); #region 判断登陆标识是否过期 if (!ComFunction.ExistUserLoginID(LoginId, ref TdUser)) { rsdc.Result = false; rsdc.Desc = ResCode.UL003Desc; return rsdc; } if (UserType.NormalType == TdUser.UType) { rsdc.Result = false; rsdc.Desc = ComFunction.NotRightUser; return rsdc; } operUser = TdUser.Account; #endregion if (string.IsNullOrEmpty(ugs.UserGroupName)) { rsdc.Result = false; rsdc.Desc = "客户组名称不能为空"; return rsdc; } List<string> sqlList = new List<string>(); sqlList.Add(string.Format(@"insert into Trade_UserGroups(UserGroupId, UserGroupName, IsDefaultGroup, AfterSecond, PlaceOrderSlipPoint, FlatOrderSlipPoint, DelayPlaceOrder, DelayFlatOrder) values('{0}','{1}',{2},{3},{4},{5},{6},{7}) ", ugs.UserGroupId, ugs.UserGroupName, ugs.IsDefaultGroup, ugs.AfterSecond, ugs.PlaceOrderSlipPoint, ugs.FlatOrderSlipPoint, ugs.DelayPlaceOrder, ugs.DelayFlatOrder)); if (1 == ugs.IsDefaultGroup)//如果新加的组为默认组时,需要把其他组全部修改为非默认组 { sqlList.Add(string.Format("update Trade_UserGroups set IsDefaultGroup=0 where UserGroupId<>'{0}'", ugs.UserGroupId)); } if (!ComFunction.SqlTransaction(sqlList)) { rsdc.Result = false; rsdc.Desc = "添加客户组出错"; return rsdc; } rsdc.Result = true; rsdc.Desc = "添加客户组成功"; } catch (Exception ex) { ComFunction.WriteErr(ex); rsdc.Result = false; rsdc.Desc = "添加客户组失败"; } return rsdc; }
/// <summary> /// 客户分组查询 /// </summary> /// <returns></returns> public UserGroupsInfo GetUserGroupsInfo() { System.Data.Common.DbDataReader dbreader = DbHelper.ExecuteReader(@"select UserGroupId, UserGroupName,IsDefaultGroup, AfterSecond, PlaceOrderSlipPoint, FlatOrderSlipPoint, DelayPlaceOrder, DelayFlatOrder from Trade_UserGroups "); UserGroupsInfo ugsinfo = new UserGroupsInfo(); ugsinfo.UserGroupsInfoList = new List<UserGroups>(); try { ugsinfo.Result = false; while (dbreader.Read()) { UserGroups ugs = new UserGroups(); ugs.UserGroupId = dbreader["UserGroupId"].ToString(); ugs.UserGroupName = System.DBNull.Value != dbreader["UserGroupName"] ? dbreader["UserGroupName"].ToString() : string.Empty; ugs.IsDefaultGroup = System.DBNull.Value != dbreader["IsDefaultGroup"] ? Convert.ToInt32(dbreader["IsDefaultGroup"]) : 0; ugs.AfterSecond = System.DBNull.Value != dbreader["AfterSecond"] ? Convert.ToInt32(dbreader["AfterSecond"]) : 0; ugs.PlaceOrderSlipPoint = System.DBNull.Value != dbreader["PlaceOrderSlipPoint"] ? Convert.ToInt32(dbreader["PlaceOrderSlipPoint"]) : 0; ugs.FlatOrderSlipPoint = System.DBNull.Value != dbreader["FlatOrderSlipPoint"] ? Convert.ToInt32(dbreader["FlatOrderSlipPoint"]) : 0; ugs.DelayPlaceOrder = System.DBNull.Value != dbreader["DelayPlaceOrder"] ? Convert.ToDouble(dbreader["DelayPlaceOrder"]) : 0; ugs.DelayFlatOrder = System.DBNull.Value != dbreader["DelayFlatOrder"] ? Convert.ToDouble(dbreader["DelayFlatOrder"]) : 0; ugsinfo.UserGroupsInfoList.Add(ugs); } ugsinfo.Result = true; ugsinfo.Desc = "客户分组查询成功"; } catch (Exception ex) { ComFunction.WriteErr(ex); ugsinfo.UserGroupsInfoList.Clear(); ugsinfo.Result = false; ugsinfo.Desc = "客户分组查询失败"; } finally { dbreader.Close(); dbreader.Dispose(); } return ugsinfo; }