/// <summary>
/// 得到初始化时用户的账号串
/// </summary>
protected void GetUserID()
{
string uid = ChangeHope.WebPage.PageRequest.GetQueryString("strId");
string userId = string.Empty;
ShowShop.BLL.Member.MemberAccount bll = new ShowShop.BLL.Member.MemberAccount();
List<ShowShop.Model.Member.MemberAccount> model = bll.GetAll(" UID in(" + uid + ")");
for (int i = 0; i <model.Count; i++)
{
userId += model[i].UserId + ",";
}
userId = userId.Substring(0, userId.LastIndexOf(','));
this.txtUserName.Text = userId;
}
protected void lbSave_Click(object sender, EventArgs e)
{
ShowShop.BLL.Member.MemberAccount bll = new ShowShop.BLL.Member.MemberAccount();
List<ShowShop.Model.Member.MemberAccount> model = new List<ShowShop.Model.Member.MemberAccount>();
//发送给全体
if (rabtnAllUser.Checked)
{
model = bll.GetAll(" 1=1");
for (int i = 0; i < model.Count; i++)
{
SendByType(model[i].Email);
}
this.ltlMsg.Text = "操作成功，已向所有用户发送该邮件！";
this.pnlMsg.Visible = true;
this.pnlMsg.CssClass = "actionOk";
}
//发送会员组
else if (rabtnMemberGroup.Checked)
{
string rankID = string.Empty;
for (int i = 0; i < cbxlMemberRank.Items.Count; i++)
{
if (cbxlMemberRank.Items[i].Selected)
{
rankID += cbxlMemberRank.Items[i].Value + ",";
}
}
if (rankID == string.Empty)
{
this.ltlMsg.Text = "请选择要发送到的会员组";
this.pnlMsg.Visible = true;
this.pnlMsg.CssClass = "actionErr";
return;
}
rankID = rankID.Substring(0, rankID.LastIndexOf(','));
model = bll.GetAll(" UserGroup in(" + rankID + ")");
for (int i = 0; i < model.Count; i++)
{
SendByType(model[i].Email);
}
this.ltlMsg.Text = "操作成功，已向指定用户组发送该邮件！";
this.pnlMsg.Visible = true;
this.pnlMsg.CssClass = "actionOk";
}
//指定用户名
else if (rabtnCheckUser.Checked)
{
string uid = this.txtUserName.Text.Trim();
if (uid.Length == 0)
{
this.ltlMsg.Text = "请输入要发送到的会员";
this.pnlMsg.Visible = true;
this.pnlMsg.CssClass = "actionErr";
return;
}
if (uid.EndsWith(","))
{
uid = uid.Substring(0, uid.LastIndexOf(','));
}
//进行拆分 给每个字段加上单引号
string[] arrUid = uid.Split(',');
uid = string.Empty;
for (int i = 0; i < arrUid.Length; i++)
{
uid += "'" + arrUid[i] + "'" + ",";
}
if (uid.EndsWith(","))
{
uid = uid.Substring(0, uid.LastIndexOf(','));
}
model = bll.GetAll(" UserId in(" + uid + ")");
for (int i = 0; i < model.Count; i++)
{
SendByType(model[i].Email);
}
this.ltlMsg.Text = "操作成功，已向指定用户发送该邮件！";
this.pnlMsg.Visible = true;
this.pnlMsg.CssClass = "actionOk";
}
//指定邮箱
else if (rabtnCheckEmail.Checked)
{
string email = this.txtEmail.Text.Trim();
if (email.Length == 0)
{
this.ltlMsg.Text = "请输入要发送到的邮箱";
this.pnlMsg.Visible = true;
this.pnlMsg.CssClass = "actionErr";
return;
}
SendByType(email);
this.ltlMsg.Text = "操作成功，已向所有用户发送该邮件！";
this.pnlMsg.Visible = true;
this.pnlMsg.CssClass = "actionOk";
}
}
protected void BtnWork_Click(object sender, EventArgs e)
{
ShowShop.Model.Admin.AdminInfo adminInfo = (ShowShop.Model.Admin.AdminInfo)ShowShop.Common.AdministrorManager.Get();
ShowShop.BLL.Member.MemberAccount memberBll = new ShowShop.BLL.Member.MemberAccount();
ShowShop.BLL.Member.UserInfoNote noteBll = new ShowShop.BLL.Member.UserInfoNote();
ShowShop.Model.Member.UserInfoNote noteModel = new ShowShop.Model.Member.UserInfoNote();
if (ViewState["Opreate"].ToString().Equals("add"))
{
noteModel.BuckleOrAdd = 0; //添加
}
else
{
noteModel.BuckleOrAdd = 1; //减
}
noteModel.NoteName = adminInfo.AdminName;
noteModel.NoteType = 0;//点卷
noteModel.NoteDate = Convert.ToDateTime(System.DateTime.Now);
noteModel.Causation = this.txtWhy.Text.Trim().ToString();
noteModel.BosomNote = this.txtLog.Text.Trim().ToString();
//全部用户
if (ViewState["M"].ToString() == "1")
{
List<ShowShop.Model.Member.MemberAccount> accountList = memberBll.GetAll("");
foreach (ShowShop.Model.Member.MemberAccount item in accountList)
{
switch (ViewState["Opreate"].ToString())
{
case "add":
item.Coupons = Convert.ToDecimal(item.Coupons) + Convert.ToDecimal(this.txtWrap.Text.Trim());
break;
case "allay":
if (Convert.ToDecimal(this.txtWrap.Text.Trim())<Convert.ToDecimal(item.Coupons) )
{
item.Coupons = Convert.ToDecimal(item.Coupons)-Convert.ToDecimal(this.txtWrap.Text.Trim());
}
else
{
this.ltlMsg.Text = "减少的点卷数量大于系统记录的数量！";
this.pnlMsg.Visible = true;
this.pnlMsg.CssClass = "actionErr";
return;
}
break;
default:
break;
}
memberBll.Update(item);
noteModel.UserID = Convert.ToInt32(item.UID);
noteModel.Username = item.UserId;
noteModel.TicketCount = Convert.ToDecimal(this.txtWrap.Text.Trim());
noteBll.Add(noteModel);
}
}
//指定用户组
if (ViewState["M"].ToString() == "2")
{
//获取会员类型
string typeId = this.cbxlMemberRank.SelectedValue;
List<ShowShop.Model.Member.MemberAccount> accountList = merberBll.GetAll("UserGroup=" + typeId);
foreach (ShowShop.Model.Member.MemberAccount item in accountList)
{
switch (ViewState["Opreate"].ToString())
{
case "add":
item.Coupons = Convert.ToDecimal(item.Coupons) + Convert.ToDecimal(this.txtWrap.Text.Trim());
break;
case "allay":
if (Convert.ToDecimal(this.txtWrap.Text.Trim()) < Convert.ToDecimal(item.Coupons))
{
item.Coupons = Convert.ToDecimal(item.Coupons) - Convert.ToDecimal(this.txtWrap.Text.Trim());
}
else
{
this.ltlMsg.Text = "减少的点卷数量大于系统记录的数量！";
this.pnlMsg.Visible = true;
this.pnlMsg.CssClass = "actionErr";
return;
}
break;
default:
break;
}
memberBll.Update(item);
noteModel.UserID = Convert.ToInt32(item.UID);
noteModel.Username = item.UserId;
noteModel.TicketCount = Convert.ToDecimal(this.txtWrap.Text.Trim());
noteBll.Add(noteModel);
}
}
//指定用户
if (ViewState["M"].ToString() == "3")
{
string assigner= this.txtName.Text.Trim();
String[] name = assigner.Split(',');
int con = name.Length;
for (int i = 0; i < con; i++)
{
string userName = name[i].ToString();
List<ShowShop.Model.Member.MemberAccount> accountList = memberBll.GetAll("UserId = '" + userName + "'");
foreach (ShowShop.Model.Member.MemberAccount item in accountList)
{
switch (ViewState["Opreate"].ToString())
{
case "add":
item.Coupons = Convert.ToDecimal(item.Coupons) + Convert.ToDecimal(this.txtWrap.Text.Trim());
break;
case "allay":
if (Convert.ToDecimal(this.txtWrap.Text.Trim()) < Convert.ToDecimal(item.Coupons))
{
item.Coupons = Convert.ToDecimal(item.Coupons) - Convert.ToDecimal(this.txtWrap.Text.Trim());
}
else
{
this.ltlMsg.Text = "减少的点卷数量大于系统记录的数量！";
this.pnlMsg.Visible = true;
this.pnlMsg.CssClass = "actionErr";
return;
}
break;
default:
break;
}
memberBll.Update(item);
noteModel.UserID = Convert.ToInt32(item.UID);
noteModel.Username = item.UserId;
noteModel.TicketCount = Convert.ToDecimal(this.txtWrap.Text.Trim());
noteBll.Add(noteModel);
}
}
}
this.ltlMsg.Text = "编辑点卷成功！";
this.pnlMsg.Visible = true;
this.pnlMsg.CssClass = "actionOk";
}
//批量事件(添加与减少)
protected void BtnWork_Click(object sender, EventArgs e)
{
ShowShop.Model.Admin.AdminInfo adminInfo = (ShowShop.Model.Admin.AdminInfo)ShowShop.Common.AdministrorManager.Get();
ShowShop.BLL.Member.MemberAccount memberBll = new ShowShop.BLL.Member.MemberAccount();
ShowShop.BLL.Member.UserInfoNote noteBll = new ShowShop.BLL.Member.UserInfoNote();
ShowShop.Model.Member.UserInfoNote noteModel = new ShowShop.Model.Member.UserInfoNote();
if (ViewState["Opreate"].ToString().Equals("add"))
{
noteModel.BuckleOrAdd = 0; //添加
}
else
{
noteModel.BuckleOrAdd = 1; //减少
}
noteModel.NoteName = adminInfo.AdminName;
noteModel.NoteType = 2;
noteModel.NoteDate = Convert.ToDateTime(System.DateTime.Now.ToShortDateString());
noteModel.Causation = this.txtWhy.Text.Trim().ToString();
noteModel.BosomNote = this.txtLog.Text.Trim().ToString();
//所有会员
if (ViewState["M"].ToString() == "1")
{
List <ShowShop.Model.Member.MemberAccount> accountList= memberBll.GetAll("");
foreach (ShowShop.Model.Member.MemberAccount item in accountList)
{
TimeSpan oldtime = new TimeSpan(Convert.ToDateTime(item.PeriodOfValidity).Ticks);
if (ViewState["time"].ToString() == "4")
{
switch (ViewState["Opreate"].ToString())
{
case "add":
if (Convert.ToDateTime(this.txtManageTime.Text) > Convert.ToDateTime(item.PeriodOfValidity))
{
item.PeriodOfValidity = Convert.ToDateTime(this.txtManageTime.Text);
}
else
{
this.ltlMsg.Text = "添加的有效期小于系统记录的有效期！";
this.pnlMsg.Visible = true;
this.pnlMsg.CssClass = "actionErr";
return;
}
break;
case "allay":
if (Convert.ToDateTime(this.txtManageTime.Text) < Convert.ToDateTime(item.PeriodOfValidity))
{
item.PeriodOfValidity = Convert.ToDateTime(this.txtManageTime.Text);
}
else
{
this.ltlMsg.Text = "减少的有效期大于系统记录的有效期！";
this.pnlMsg.Visible = true;
this.pnlMsg.CssClass = "actionErr";
return;
}
break;
default:
break;
}
}
else
{ //归0
item.PeriodOfValidity = Convert.ToDateTime(System.DateTime.Now.ToShortDateString());
}
memberBll.Update(item);
TimeSpan newtime=new TimeSpan(Convert.ToDateTime(this.txtManageTime.Text).Ticks);
TimeSpan gap=oldtime.Subtract(newtime).Duration();
noteModel.TicketCount=Convert.ToDecimal(gap.Days);
noteModel.UserID = Convert.ToInt32(item.UID);
noteModel.Username = item.UserId;
noteBll.Add(noteModel);
}
}
//指定会员组
if (ViewState["M"].ToString() == "2")
{ //获取会员类型
string typeId = this.cbxlMemberRank.SelectedValue;
List<ShowShop.Model.Member.MemberAccount> accountList = merberBll.GetAll("UserGroup="+typeId);
foreach (ShowShop.Model.Member.MemberAccount item in accountList)
{
TimeSpan oldtime = new TimeSpan(Convert.ToDateTime(item.PeriodOfValidity).Ticks);
if (ViewState["time"].ToString() == "4")
{
switch (ViewState["Opreate"].ToString())
{
case "add":
if (Convert.ToDateTime(this.txtManageTime.Text) > Convert.ToDateTime(item.PeriodOfValidity))
{
item.PeriodOfValidity = Convert.ToDateTime(this.txtManageTime.Text);
}
else
{
this.ltlMsg.Text = "添加的有效期小于系统记录的有效期！";
this.pnlMsg.Visible = true;
this.pnlMsg.CssClass = "actionErr";
return;
}
break;
case "allay":
if (Convert.ToDateTime(this.txtManageTime.Text) < Convert.ToDateTime(item.PeriodOfValidity))
{
item.PeriodOfValidity = Convert.ToDateTime(this.txtManageTime.Text);
}
else
{
this.ltlMsg.Text = "减少的有效期大于系统记录的有效期！";
this.pnlMsg.Visible = true;
this.pnlMsg.CssClass = "actionErr";
return;
}
break;
default:
break;
}
}
else
{ //归0
item.PeriodOfValidity = Convert.ToDateTime(System.DateTime.Now.ToShortDateString());
}
memberBll.Update(item);
TimeSpan newtime = new TimeSpan(Convert.ToDateTime(this.txtManageTime.Text).Ticks);
TimeSpan gap = oldtime.Subtract(newtime).Duration();
noteModel.TicketCount = Convert.ToDecimal(gap.Days);
noteModel.UserID = Convert.ToInt32(item.UID);
noteModel.Username = item.UserId;
noteBll.Add(noteModel);
}
}
//指定用户
if(ViewState["M"].ToString() =="3")
{
string assigner= this.txtName.Text.Trim();
String[] name = assigner.Split(',');
int con = name.Length;
for (int i = 0; i < con; i++)
{
string userName = name[i].ToString();
List<ShowShop.Model.Member.MemberAccount> accountList = memberBll.GetAll("UserId = '" + userName + "'");
foreach (ShowShop.Model.Member.MemberAccount item in accountList)
{
TimeSpan oldtime = new TimeSpan(Convert.ToDateTime(item.PeriodOfValidity).Ticks);
if (ViewState["time"].ToString() == "4")
{
switch (ViewState["Opreate"].ToString())
{
case "add":
if (Convert.ToDateTime(this.txtManageTime.Text) > Convert.ToDateTime(item.PeriodOfValidity))
{
item.PeriodOfValidity = Convert.ToDateTime(this.txtManageTime.Text);
}
else
{
this.ltlMsg.Text = "添加的有效期小于系统记录的有效期！";
this.pnlMsg.Visible = true;
this.pnlMsg.CssClass = "actionErr";
return;
}
break;
case "allay":
if (Convert.ToDateTime(this.txtManageTime.Text) < Convert.ToDateTime(item.PeriodOfValidity))
{
item.PeriodOfValidity = Convert.ToDateTime(this.txtManageTime.Text);
}
else
{
this.ltlMsg.Text = "减少的有效期大于系统记录的有效期！";
this.pnlMsg.Visible = true;
this.pnlMsg.CssClass = "actionErr";
return;
}
break;
default:
break;
}
}
else
{ //归0
item.PeriodOfValidity = Convert.ToDateTime(System.DateTime.Now.ToShortDateString());
}
memberBll.Update(item);
TimeSpan newtime = new TimeSpan(Convert.ToDateTime(this.txtManageTime.Text).Ticks);
TimeSpan gap = oldtime.Subtract(newtime).Duration();
noteModel.TicketCount = Convert.ToDecimal(gap.Days);
noteModel.UserID = Convert.ToInt32(item.UID);
noteModel.Username = item.UserId;
noteBll.Add(noteModel);
}
}
}
this.ltlMsg.Text = "编辑有效期成功！";
this.pnlMsg.Visible = true;
this.pnlMsg.CssClass = "actionOk";
}
protected void lbSave_Click(object sender, EventArgs e)
{
if (ViewState["to"] == null)
{
this.ltlMsg.Text = "请选择您要移动到的目标会员组";
this.pnlMsg.Visible = true;
this.pnlMsg.CssClass = "actionErr";
return;
}
ShowShop.BLL.Member.MemberAccount bll = new ShowShop.BLL.Member.MemberAccount();
List<ShowShop.Model.Member.MemberAccount> model = new List<ShowShop.Model.Member.MemberAccount>();
if (rabtnUser.Checked)
{
if (txtUserName.Text.Trim().Length != 0)
{
string uid = this.txtUserName.Text.Trim();
if (uid.EndsWith(","))
{
uid = uid.Substring(0, uid.LastIndexOf(','));
}
//进行拆分 给每个字段加上单引号
string[] arrUid = uid.Split(',');
uid = string.Empty;
for (int i = 0; i < arrUid.Length; i++)
{
uid += "'" + arrUid[i] + "'" + ",";
}
if (uid.EndsWith(","))
{
uid = uid.Substring(0, uid.LastIndexOf(','));
}
model = bll.GetAll(" UserId in(" + uid + ")");
for (int i = 0; i < model.Count; i++)
{
bll.Amend(Convert.ToInt32(model[i].UID), "UserGroup", this.lbxTo.SelectedValue);
}
this.ltlMsg.Text = "操作成功！";
this.pnlMsg.Visible = true;
this.pnlMsg.CssClass = "actionOk";
}
else
{
this.ltlMsg.Text = "请输入您要移动的用户";
this.pnlMsg.Visible = true;
this.pnlMsg.CssClass = "actionErr";
return;
}
}
//按会员组 批量移动
else if (rabtnGroup.Checked)
{
if (ViewState["from"] == null)
{
this.ltlMsg.Text = "请选择您要移动的会员组";
this.pnlMsg.Visible = true;
this.pnlMsg.CssClass = "actionErr";
return;
}
bll.UpdateGroup(this.lbxFrom.SelectedValue, this.lbxTo.SelectedValue);
this.ltlMsg.Text = "操作成功！";
this.pnlMsg.Visible = true;
this.pnlMsg.CssClass = "actionOk";
}
}