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