/// <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(); }