public void Update(OtherDuihuanInfo entity)
{
using (var conn = new SqlConnection(connectString))
{
string sql = @"UPDATE OtherDuihuan SET userid = @userid, truename = @truename, mobile = @mobile, note = @note, integral = @integral, adminid = @adminid, addtime = @addtime
where id=@id";
conn.Execute(sql, entity);
}
}
public int Add(OtherDuihuanInfo entity)
{
using (var conn = new SqlConnection(connectString))
{
string sql = @"INSERT INTO OtherDuihuan(userid,truename,mobile,note,integral,adminid,addtime) VALUES(@userid,@truename,@mobile,@note,@integral,@adminid,@addtime);
select SCOPE_IDENTITY()";
return(conn.Query <int>(sql, entity).Single());
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
int id = RequestHelper.GetQueryString <int>("ID");
if (id != int.MinValue)
{
//CheckAdminPower("ReadUser", PowerCheckType.Single);
OtherDuihuan = OtherDuihuanBLL.Read(id);
userid.Text = OtherDuihuan.userid.ToString();
name.Text = OtherDuihuan.truename;
mobile.Text = OtherDuihuan.mobile;
integral.Text = OtherDuihuan.integral;
note.Text = OtherDuihuan.note;
}
}
}
public static void Update(OtherDuihuanInfo entity)
{
dal.Update(entity);
}
public static int Add(OtherDuihuanInfo entity)
{
return(dal.Add(entity));
}
protected void SubmitButton_Click(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(userid.Text))
{
ScriptHelper.Alert("会员ID不能为空");
return;
}
OtherDuihuanInfo model = new OtherDuihuanInfo();
model.id = RequestHelper.GetQueryString <int>("ID");
if (model.id > 0)
{
//model = OtherDuihuanBLL.Read(model.id);
//model.truename = name.Text;
//model.mobile = mobile.Text;
//model.note = note.Text;
//model.integral = integral.Text;
//model.adminid = Cookies.Admin.GetAdminID(true);
//model.addtime = RequestHelper.DateNow;
//OtherDuihuanBLL.Update(model);
//AdminLogBLL.Add(ShopLanguage.ReadLanguage("UpdateRecord"), "修改兑换记录", model.id);
}
else
{
UserInfo usermodel = UserBLL.Read(Convert.ToInt32(userid.Text));
if (usermodel.Id > 0)
{
if (string.IsNullOrEmpty(integral.Text) || Convert.ToInt32(integral.Text) <= 0)
{
ScriptHelper.Alert("请填写兑换积分");
return;
}
if (usermodel.PointLeft < Convert.ToInt32(integral.Text))
{
ScriptHelper.Alert("会员可用积分不足");
return;
}
model.userid = usermodel.Id;
model.truename = name.Text;
model.mobile = mobile.Text;
model.note = note.Text;
model.integral = integral.Text;
model.adminid = Cookies.Admin.GetAdminID(true);
model.addtime = RequestHelper.DateNow;
//CheckAdminPower("UpdateUserMessage", PowerCheckType.Single);
int _id = OtherDuihuanBLL.Add(model);
if (_id > 0)
{
//会员积分扣除
usermodel.PointLeft -= Convert.ToInt32(integral.Text);
UserBLL.Update(usermodel);
AdminLogBLL.Add(ShopLanguage.ReadLanguage("AddRecord"), "添加兑换记录", _id);
}
}
else
{
ScriptHelper.Alert("会员ID不存在或已删除");
return;
}
}
ScriptHelper.Alert(ShopLanguage.ReadLanguage("OperateOK"), RequestHelper.RawUrl);
}
