/// <summary>
/// 添加
/// </summary>
/// <param name="mode"></param>
/// <returns></returns>
public static int Addvipcard(VIPCardRangeModel mode)
{
SqlParameter[] parameter =
{
new SqlParameter("@rangeID", SqlDbType.Int),
new SqlParameter("@storeid", SqlDbType.VarChar, 40),
new SqlParameter("@begincard", SqlDbType.Int),
new SqlParameter("@endcard", SqlDbType.Int),
new SqlParameter("@inuse", SqlDbType.Int)
};
parameter[0].Value = mode.RangeID;
parameter[1].Value = mode.StoreID;
parameter[2].Value = mode.BeginCard;
parameter[3].Value = mode.EndCard;
parameter[4].Value = mode.InUse;
return(DBHelper.ExecuteNonQuery("Addvipcard", parameter, CommandType.StoredProcedure));
}
/// <summary>
/// 新增卡号
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void Button1_Click(object sender, EventArgs e)
{
int RangeID = CommonDataBLL.getMaxqishu() + 1;
string ToStoreID = "";
string inuse = "0";
int count = VIPCardManageBll.valiStore(DisposeString.DisString(this.txt_ToStoreID.Text.Trim(), "<,>,',-", "<,>,', ", ","));
if (count == 0)
{
ToStoreID = "";
inuse = "0";
ScriptHelper.SetAlert(Page, GetTran("000388", "店铺") + txt_ToStoreID.Text.Trim() + GetTran("001584", "不存在！"));
return;
}
else
{
ToStoreID = txt_ToStoreID.Text.Trim();
inuse = "1";
}
VIPCardRangeModel vipmodel = new VIPCardRangeModel();
vipmodel.RangeID = RangeID;
vipmodel.StoreID = ToStoreID;
vipmodel.BeginCard = Convert.ToInt32(txt_BeginCard.Text.Trim());
vipmodel.EndCard = Convert.ToInt32(txt_EndCard.Text.Trim());
vipmodel.InUse = Convert.ToInt32(inuse);
int vipcard = VIPCardManageBll.Addvipcard(vipmodel);
if (vipcard > 0)
{
ScriptHelper.SetAlert(Page, GetTran("001583", "新增卡号范围成功，") + ((inuse == "1") ? GetTran("001581", "分配到店铺") + ToStoreID : GetTran("001580", "未分配到店铺")));
}
else
{
ScriptHelper.SetAlert(Page, GetTran("001541", "操作失败！！！"));
return;
}
btn_Query_Click1(null, null);
Translations();
}
