protected void BandInfo(int id)
{
ShowShop.BLL.OrderCard.OrderCardInfo bll = new ShowShop.BLL.OrderCard.OrderCardInfo();
ShowShop.Model.OrderCard.OrderCardInfo model = bll.GetModelID(id);
if (model != null)
{
this.rbCardType.SelectedValue = model.Type;
this.rblIsShopSale.SelectedValue = model.IsWhetherSale.ToString();
if (model.IsWhetherSale.ToString() == "1")
{
this.OptionProduct.Style.Value = "display:";
string Name=ProductName(model.ProductID.ToString());
if (Name!="")
{
this.txtProduct.Text = Name;
this.hfid.Value = model.ProductID.ToString();
}
}
this.brlmode.Enabled = false;
this.txtCardNumber.Text = model.CardNumber;
this.txtPassword.Text = model.JOCW_Password;
this.txtFaceValue.Text = model.FaceValue.ToString();
this.txtPoint.Text = model.Point.ToString();
this.ddty.SelectedValue = model.Unit;
this.txtPrice.Text = model.Price.ToString();
this.txtEndTime.Text = model.ExpirationDate.ToString();
this.txtBusinessAgent.Text = model.BusinessAgent;
ViewState["ID"] = model.ID;
ViewState["PassWord"] = model.JOCW_Password;
ViewState["UserName"] = model.UserName;
ViewState["CardNumber"] = model.CardNumber;
ViewState["FullMoneyDate"] = model.FullMoneyDate;
ViewState["WhetherRelease"] = model.WhetherRelease;
}
}
/// <summary>
/// 列表
/// </summary>
/// <returns></returns>
protected string GetList()
{
ShowShop.Common.SysParameter sp = new ShowShop.Common.SysParameter();
ChangeHope.WebPage.Table table = new ChangeHope.WebPage.Table();
ShowShop.BLL.OrderCard.OrderCardInfo data = new ShowShop.BLL.OrderCard.OrderCardInfo();
ChangeHope.DataBase.DataByPage dataPage = data.GetList();
//第一步先添加表头
table.AddHeadCol("4%", "序号");
table.AddHeadCol("11%", "类型");
table.AddHeadCol("15%", "卡号");
table.AddHeadCol("5%", "面值");
table.AddHeadCol("5%", "点数");
table.AddHeadCol("14%", "所属商品");
table.AddHeadCol("8%", "状态");
table.AddHeadCol("10%", "截止日期");
table.AddHeadCol("9%", "使用会员");
table.AddHeadCol("10%", "获取时间");
table.AddHeadCol("15%", "操作");
table.AddRow();
//添加表的内容
if (dataPage.DataReader != null)
{
int curpage = ChangeHope.WebPage.PageRequest.GetInt("pageindex");
if (curpage < 0)
{
curpage = 1;
}
int count = 0;
while (dataPage.DataReader.Read())
{
count++;
string No = (15 * (curpage - 1) + count).ToString();
table.AddCol(No);
table.AddCol(dataPage.DataReader["type"].ToString() == "1" ? "本商城充值卡" : "其它公司充值卡");
table.AddCol(dataPage.DataReader["cardnumber"].ToString());
table.AddCol(dataPage.DataReader["facevalue"].ToString());
table.AddCol(dataPage.DataReader["point"].ToString() + dataPage.DataReader["unit"].ToString());
table.AddCol(dataPage.DataReader["iswebsitersale"].ToString() == "1" ? ProductName(dataPage.DataReader["productid"].ToString()) : "不通过商城出售");
table.AddCol(Convert.ToDateTime(dataPage.DataReader["expirationdate"].ToString()) < System.DateTime.Now ? "已失效" : this.State(dataPage.DataReader["whetherRelease"].ToString(), dataPage.DataReader["productid"].ToString()));
table.AddCol(Convert.ToDateTime(dataPage.DataReader["expirationdate"].ToString()).ToString("yyyy-MM-dd"));
table.AddCol(dataPage.DataReader["username"].ToString());
table.AddCol(Convert.ToDateTime(dataPage.DataReader["fullmoneydate"].ToString()) != Convert.ToDateTime("1753-01-01") ? Convert.ToDateTime(dataPage.DataReader["fullmoneydate"].ToString()).ToString("yyyy-MM-dd") : "");
table.AddCol(string.Format("<a href=ordercard_edit.aspx?id={0}>编辑</a> <a href='#' onclick='Del({0})'>删除</a>", dataPage.DataReader["id"].ToString()));
table.AddRow();
}
}
string view = table.GetTable() + dataPage.PageToolBar;
dataPage.Dispose();
dataPage = null;
return view;
}
/// <summary>
/// 保存信息
/// </summary>
protected void Save()
{
string addManner = this.brlmode.SelectedValue;
string CardNo = this.txtCardNumber.Text;
string CardPassWord = this.txtPassword.Text;
string BatchCard = this.txtBatch.Text;
if (addManner == "1")
{
if (string.IsNullOrEmpty(CardNo))
{
this.ltlMsg.Text = "操作失败，卡号不能为空。";
this.pnlMsg.Visible = true;
this.pnlMsg.CssClass = "actionErr";
return;
}
if (string.IsNullOrEmpty(CardPassWord))
{
this.ltlMsg.Text = "操作失败，密码不能为空。";
this.pnlMsg.Visible = true;
this.pnlMsg.CssClass = "actionErr";
return;
}
}
else if (addManner == "2")
{
if (string.IsNullOrEmpty(BatchCard))
{
this.ltlMsg.Text = "操作失败，格式文本不能为空。";
this.pnlMsg.Visible = true;
this.pnlMsg.CssClass = "actionErr";
return;
}
}
if (txtFaceValue.Text.Trim()!="")
{
if(!ChangeHope.Common.ValidateHelper.IsMoney(txtFaceValue.Text.Trim()))
{
this.ltlMsg.Text = "操作失败，请输入正确面值。";
this.pnlMsg.Visible = true;
this.pnlMsg.CssClass = "actionErr";
return;
}
if(float.Parse(txtFaceValue.Text.Trim())<=0)
{
this.ltlMsg.Text = "操作失败，面值小于或等于0。";
this.pnlMsg.Visible = true;
this.pnlMsg.CssClass = "actionErr";
return;
}
}
if (txtPoint.Text.Trim()!="")
{
if(!ChangeHope.Common.ValidateHelper.IsMoney(txtPoint.Text.Trim()))
{
this.ltlMsg.Text = "操作失败，请输入正确数量。";
this.pnlMsg.Visible = true;
this.pnlMsg.CssClass = "actionErr";
return;
}
if(float.Parse(txtPoint.Text.Trim())<=0)
{
this.ltlMsg.Text = "操作失败，数量小于或等于0。";
this.pnlMsg.Visible = true;
this.pnlMsg.CssClass = "actionErr";
return;
}
}
if (txtPrice.Text.Trim()!="")
{
if(!ChangeHope.Common.ValidateHelper.IsMoney(txtPrice.Text.Trim()))
{
this.ltlMsg.Text = "操作失败，请输入正确价格。";
this.pnlMsg.Visible = true;
this.pnlMsg.CssClass = "actionErr";
return;
}
if(float.Parse(txtPrice.Text.Trim())<=0)
{
this.ltlMsg.Text = "操作失败，价格小于或等于0。";
this.pnlMsg.Visible = true;
this.pnlMsg.CssClass = "actionErr";
return;
}
}
ShowShop.BLL.OrderCard.OrderCardInfo bll = new ShowShop.BLL.OrderCard.OrderCardInfo();
ShowShop.Model.OrderCard.OrderCardInfo model = new ShowShop.Model.OrderCard.OrderCardInfo();
TryCode.SymmetricMethod pw = new TryCode.SymmetricMethod();
string isProductID =this.rblIsShopSale.SelectedValue;
if (addManner == "1")
{
if (ViewState["CardNumber"] == null)
{
ChangeHope.DataBase.DataByPage db = bll.GetList("[order by] id asc", 1, " and cardnumber=" + CardNo + "");
if (db.DataReader != null)
{
this.ltlMsg.Text = "操作失败，卡号和密码重复，请重新输入。";
this.pnlMsg.Visible = true;
this.pnlMsg.CssClass = "actionOk";
return;
}
}
model.ProductID = (isProductID == "1" && this.hfid.Value != string.Empty) ? Convert.ToInt32(this.hfid.Value) : 0;
model.IsWhetherSale = int.Parse(isProductID);
model.Type = this.rbCardType.Text;
model.CardNumber = CardNo;
model.Password = CardPassWord;
model.FaceValue = Convert.ToDecimal(this.txtFaceValue.Text);
model.Point = this.txtPoint.Text;
model.Unit = this.ddty.SelectedValue;
model.ExpirationDate = Convert.ToDateTime(this.txtEndTime.Text);
model.BusinessAgent = this.txtBusinessAgent.Text;
model.CreateDate = System.DateTime.Now;
model.Appearance = 0;
model.Price = this.txtPrice.Text.Trim() != "" ? Convert.ToDecimal(this.txtPrice.Text.Trim()) : 0;
model.UpdateDate = System.DateTime.Now;
if (ViewState["ID"] == null)
{
model.WhetherRelease = 0;
model.FullMoneyDate =Convert.ToDateTime("1753-01-01");
model.UserName = "******";
if (bll.Add(model) != 0)
{
this.hfid.Value = string.Empty;
this.ltlMsg.Text = "操作成功，添加信息保存成功。";
this.pnlMsg.Visible = true;
this.pnlMsg.CssClass = "actionOk";
}
}
else
{
model.ID = Convert.ToInt32(ViewState["ID"].ToString());
model.WhetherRelease = Convert.ToInt32(ViewState["WhetherRelease"].ToString());
model.UserName = ViewState["UserName"].ToString();
model.FullMoneyDate = Convert.ToDateTime(ViewState["FullMoneyDate"].ToString());
if (bll.Update(model) != 0)
{
this.hfid.Value = string.Empty;
this.ltlMsg.Text = "操作成功，修改信息保存成功。";
this.pnlMsg.Visible = true;
this.pnlMsg.CssClass = "actionOk";
}
}
}
else if (addManner == "2")
{
string str = "", strs = "", sp = "";
str = BatchCard.Replace("\n", ",");
string[] StringArray = str.Split(',');
if (this.tbSp.Text.Trim() != string.Empty)
{
sp = this.tbSp.Text.Trim();
}
else
{
sp = "|";
}
for (int i = 0; i < StringArray.Length; i++)
{
strs = StringArray[i];
if (strs != string.Empty)
{
if (strs.IndexOf(sp) > 0)
{
string[] slingArray = strs.Replace(sp, ",").Split(',');
ChangeHope.DataBase.DataByPage db = bll.GetList("[order by] id asc", 1, " and cardnumber=" + slingArray[0] + "");
if(db.DataReader!=null)
{
break;
}
if (db.DataReader != null)
{
this.ltlMsg.Text = "操作失败，卡号和密码重复，请重新输入。";
this.pnlMsg.Visible = true;
this.pnlMsg.CssClass = "actionOk";
return;
}
model.ProductID = (isProductID == "1" && this.txtProduct.Text.Trim() != string.Empty) ? Convert.ToInt32(this.hfid.Value) : 0;
model.IsWhetherSale = int.Parse(isProductID);
model.Type = this.rbCardType.Text;
model.CardNumber = slingArray[0];
model.Password = slingArray[1];
model.FaceValue = Convert.ToDecimal(this.txtFaceValue.Text);
model.Point = this.txtPoint.Text;
model.Unit = this.ddty.SelectedValue;
model.ExpirationDate = Convert.ToDateTime(this.txtEndTime.Text);
model.BusinessAgent = this.txtBusinessAgent.Text;
model.CreateDate = System.DateTime.Now;
model.Appearance = 0;
model.Price = this.txtPrice.Text.Trim() != "" ? Convert.ToDecimal(this.txtPrice.Text.Trim()) : 0;
model.WhetherRelease = 0;
model.UpdateDate = System.DateTime.Now;
model.UserName = "******";
model.FullMoneyDate = Convert.ToDateTime("1753-01-01");
bll.Add(model);
}
}
}
this.ltlMsg.Text = "操作成功，信息保存成功。";
this.pnlMsg.Visible = true;
this.pnlMsg.CssClass = "actionOk";
}
}
private void del(int id)
{
ShowShop.BLL.OrderCard.OrderCardInfo bll = new ShowShop.BLL.OrderCard.OrderCardInfo();
ShowShop.Model.OrderCard.OrderCardInfo model = bll.GetModelID(id);
if (model != null)
{
bll.Delete(id);
}
Response.Write("ok");
}