/// <summary>
/// 获得记录差异信息
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public static BonusDifferenceModel GetBonusDifference(int id)
{
BonusDifferenceModel info = null;
string sql = "select * from BonusDifference where id=@id";
SqlParameter[] parm = new SqlParameter[] { new SqlParameter("@id", SqlDbType.Int) };
parm[0].Value = id;
SqlDataReader reader = DBHelper.ExecuteReader(sql, parm, CommandType.Text);
if (reader.Read())
{
info = new BonusDifferenceModel();
info.Chayi = Convert.ToDouble(reader["Chayi"]);
info.Cyflag = Convert.ToInt32(reader["Cyflag"]);
info.Id = Convert.ToInt32(reader["Id"]);
info.Jsdate = Convert.ToDateTime(reader["Jsdate"]);
info.Number = reader["Number"].ToString();
info.Qishu = Convert.ToInt32(reader["Qishu"]);
info.Xbukuan = Convert.ToDouble(reader["Xbukuan"]);
info.Xkoukuan = Convert.ToDouble(reader["Xkoukuan"]);
info.Xkoushui = Convert.ToDouble(reader["Xkoushui"]);
info.Xshifa = Convert.ToDouble(reader["Xshifa"]);
info.Xzongji = Convert.ToDouble(reader["Xzongji"]);
info.Ybukuan = Convert.ToDouble(reader["Ybukuan"]);
info.Ykoukuan = Convert.ToDouble(reader["Ykoukuan"]);
info.Ykoushui = Convert.ToDouble(reader["Ykoushui"]);
info.Yshifa = Convert.ToDouble(reader["Yshifa"]);
info.Yzongji = Convert.ToDouble(reader["Yzongji"]);
}
reader.Close();
return(info);
}
protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e)
{
string cname = e.CommandName.ToString();
if (cname == "Lbtn")
{
if (DeductBLL.isExistsBonusDifference(Convert.ToInt32(e.CommandArgument)))
{
this.Page.RegisterStartupScript("", "<script>alert('" + GetTran("005965", "已经添加，不能再添加！") + "');</script>");
return;
}
else
{
DeductBLL.upBonusDifference(Convert.ToInt32(e.CommandArgument));
BonusDifferenceModel model = DeductBLL.GetBonusDifference(Convert.ToInt32(e.CommandArgument));
MemberInfoModel memberinfo = DeductBLL.GetMemberInfo(model.Number);
DeductModel deduct = new DeductModel();
deduct.Number = model.Number;
deduct.DeductMoney = model.Chayi;
if (model.Chayi >= 0)
{
deduct.DeductReason = GetTran("000024", "会员编号") + "：" + model.Number + "," + GetTran("000107", "姓名") + "：" + Encryption.Encryption.GetDecipherName(memberinfo.Name) + "," + GetTran("000252", "补款") + "：" + model.Chayi + ",第" + model.Qishu + GetTran("006033", "期结算后的差异");
deduct.IsDeduct = 1;
}
else
{
deduct.DeductReason = GetTran("000024", "会员编号") + "：" + model.Number + "," + GetTran("000107", "姓名") + "：" + Encryption.Encryption.GetDecipherName(memberinfo.Name) + "," + GetTran("000251", "扣款") + "：" + model.Chayi + "," + GetTran("000156", "第") + model.Qishu + GetTran("006033", "期结算后的差异");
deduct.IsDeduct = 0;
}
deduct.ExpectNum = BLL.CommonClass.CommonDataBLL.getMaxqishu();
deduct.OperateIP = CommonDataBLL.OperateIP;
deduct.OperateNum = CommonDataBLL.OperateBh;
DeductBLL.AddInfo(deduct);
this.Page.RegisterStartupScript("", "<script>alert('" + GetTran("001401", "操作成功！") + "');</script>");
bind();
}
}
if (cname == "Del")
{
if (DeductBLL.isExistsBonusDifference(Convert.ToInt32(e.CommandArgument)))
{
this.Page.RegisterStartupScript("", "<script>alert('" + GetTran("005966", "已经添加，不能删除！") + "');</script>");
return;
}
else
{
if (DeductBLL.isDelBonusDifference(Convert.ToInt32(e.CommandArgument)))
{
DeductBLL.DelBonusDifference(Convert.ToInt32(e.CommandArgument));
this.Page.RegisterStartupScript("", "<script>alert('" + GetTran("000749", "删除成功！") + "');</script>");
}
else
{
this.Page.RegisterStartupScript("", "<script>alert('" + GetTran("005997", "已经被删除，不能再删！") + "');</script>");
}
bind();
}
}
}
