private void BindData( ) { GlobalLivcard cardType = aideTreasureFacade.GetGlobalLivcardInfo(IntParam); if (cardType == null) { return; } CtrlHelper.SetText(txtCardTypeName, cardType.CardName); CtrlHelper.SetText(txtCardPrice, cardType.CardPrice.ToString( )); CtrlHelper.SetText(txtCardGold, cardType.CardGold.ToString( )); if (rdoMemberOrder.Items.Count > 0) { foreach (ListItem item in rdoMemberOrder.Items) { item.Selected = item.Value == cardType.MemberOrder.ToString( ); } } //用户权限 int intUserRight = cardType.UserRight; if (ckbUserRight.Items.Count > 0) { foreach (ListItem item in ckbUserRight.Items) { item.Selected = int.Parse(item.Value) == (intUserRight & int.Parse(item.Value)); } } CtrlHelper.SetText(txtMemberDays, cardType.MemberDays.ToString( )); }
/// <summary> /// 获取实卡类型实体 /// </summary> /// <param name="cardTypeID"></param> /// <returns></returns> public GlobalLivcard GetGlobalLivcardInfo(int cardTypeID) { string sqlQuery = string.Format("(NOLOCK) WHERE CardTypeID= '{0}'", cardTypeID); GlobalLivcard globalLivcard = aideGlobalLivcardProvider.GetObject <GlobalLivcard>(sqlQuery); return(globalLivcard); }
/// <summary> /// 获取实卡展示图片 /// </summary> /// <param name="context"></param> private void GetCardImage(HttpContext context) { //获取类类型ID int cardTypeID = GameRequest.GetInt("param", 0); if (cardTypeID == 0) { return; } TreasureFacade aideTreasureFacade = new TreasureFacade( ); GlobalLivcard cardType = aideTreasureFacade.GetGlobalLivcardInfo(cardTypeID); if (cardType == null) { return; } //if( cardType.Image != null ) //{ // context.Response.Clear(); // context.Response.ContentType = "image/Bmp"; // context.Response.BinaryWrite( cardType.Image ); // context.Response.End(); //} }
/// <summary> /// 更新实卡类型 /// </summary> /// <param name="globalLivcard"></param> public void UpdateGlobalLivcard(GlobalLivcard globalLivcard) { StringBuilder sqlQuery = new StringBuilder( ); sqlQuery.Append("UPDATE GlobalLivcard SET ") .Append("CardName=@CardName, ") .Append("CardPrice=@CardPrice, ") .Append("CardGold=@CardGold, ") .Append("MemberOrder=@MemberOrder, ") .Append("MemberDays=@MemberDays, ") .Append("UserRight=@UserRight, ") .Append("ServiceRight=@ServiceRight ") .Append("WHERE CardTypeID=@CardTypeID"); var prams = new List <DbParameter>( ); prams.Add(Database.MakeInParam("CardName", globalLivcard.CardName)); prams.Add(Database.MakeInParam("CardPrice", globalLivcard.CardPrice)); prams.Add(Database.MakeInParam("CardGold", globalLivcard.CardGold)); prams.Add(Database.MakeInParam("MemberOrder", globalLivcard.MemberOrder)); prams.Add(Database.MakeInParam("MemberDays", globalLivcard.MemberDays)); prams.Add(Database.MakeInParam("UserRight", globalLivcard.UserRight)); prams.Add(Database.MakeInParam("ServiceRight", globalLivcard.ServiceRight)); prams.Add(Database.MakeInParam("CardTypeID", globalLivcard.CardTypeID)); Database.ExecuteNonQuery(CommandType.Text, sqlQuery.ToString( ), prams.ToArray( )); }
/// <summary> /// 获取实卡名称 /// </summary> /// <param name="typeID"></param> /// <returns></returns> protected string GetCardTypeName(int typeID) { GlobalLivcard card = aideTreasureFacade.GetGlobalLivcardInfo(typeID); if (card == null) { return(""); } return(card.CardName); }
public static string GetCardTypeName(int typeID) { GlobalLivcard globalLivcardInfo = FacadeManage.aideTreasureFacade.GetGlobalLivcardInfo(typeID); if (globalLivcardInfo == null) { return(""); } return(globalLivcardInfo.CardName); }
private void BindData() { GlobalLivcard cardType = FacadeManage.aideTreasureFacade.GetGlobalLivcardInfo(IntParam); if (cardType == null) { return; } CtrlHelper.SetText(txtCardTypeName, cardType.CardName); CtrlHelper.SetText(txtCardPrice, cardType.CardPrice.ToString()); CtrlHelper.SetText(txtCurrency, cardType.Currency.ToString()); }
/// <summary> /// 新增实卡类型 /// </summary> /// <param name="globalLivcard"></param> public void InsertGlobalLivcard(GlobalLivcard globalLivcard) { DataRow dr = aideGlobalLivcardProvider.NewRow( ); dr[GlobalLivcard._CardName] = globalLivcard.CardName; dr[GlobalLivcard._CardPrice] = globalLivcard.CardPrice; dr[GlobalLivcard._CardGold] = globalLivcard.CardGold; dr[GlobalLivcard._MemberOrder] = globalLivcard.MemberOrder; dr[GlobalLivcard._MemberDays] = globalLivcard.MemberDays; dr[GlobalLivcard._UserRight] = globalLivcard.UserRight; dr[GlobalLivcard._ServiceRight] = globalLivcard.ServiceRight; aideGlobalLivcardProvider.Insert(dr); }
//保存 protected void btnSave_Click(object sender, EventArgs e) { //计算用户权限 int intUserRight = 0; if (ckbUserRight.Items.Count > 0) { foreach (ListItem item in ckbUserRight.Items) { if (item.Selected) { intUserRight |= int.Parse(item.Value); } } } GlobalLivcard cardType; if (IntParam <= 0) { cardType = new GlobalLivcard( ); } else { cardType = aideTreasureFacade.GetGlobalLivcardInfo(IntParam); } cardType.CardName = CtrlHelper.GetText(txtCardTypeName); cardType.CardPrice = Utils.Validate.IsDouble(txtCardPrice.Text.Trim( )) ? decimal.Parse(txtCardPrice.Text.Trim( )) : 0; cardType.CardGold = CtrlHelper.GetInt(txtCardGold, 0); cardType.MemberOrder = byte.Parse(string.IsNullOrEmpty(rdoMemberOrder.SelectedValue) ? "0" : rdoMemberOrder.SelectedValue); cardType.MemberDays = CtrlHelper.GetInt(txtMemberDays, 0); cardType.UserRight = intUserRight; if (IntParam <= 0) { //判断权限 AuthUserOperationPermission(Permission.Add); aideTreasureFacade.InsertGlobalLivcard(cardType); ShowInfo("新增成功", "GlobalLivcardList.aspx", 1200); } else { //判断权限 AuthUserOperationPermission(Permission.Edit); aideTreasureFacade.UpdateGlobalLivcard(cardType); ShowInfo("更新成功", "GlobalLivcardList.aspx", 1200); } }
//绑定数据 private void BindData() { int cardTypeID = string.IsNullOrEmpty(ddlCardType.SelectedValue) ? 0 : int.Parse(ddlCardType.SelectedValue); if (cardTypeID <= 0) { return; } GlobalLivcard cardType = FacadeManage.aideTreasureFacade.GetGlobalLivcardInfo(cardTypeID); if (cardType == null) { return; } CtrlHelper.SetText(ltCardPrice, cardType.CardPrice.ToString()); CtrlHelper.SetText(txtCurrency, cardType.Currency.ToString()); }
private void BindData( ) { int cardTypeID = string.IsNullOrEmpty(ddlCardType.SelectedValue) ? 0 : int.Parse(ddlCardType.SelectedValue); if (cardTypeID <= 0) { return; } GlobalLivcard cardType = aideTreasureFacade.GetGlobalLivcardInfo(cardTypeID); if (cardType == null) { return; } CtrlHelper.SetText(ltCardPrice, cardType.CardPrice.ToString( )); CtrlHelper.SetText(txtCardGold, cardType.CardGold.ToString( )); CtrlHelper.SetText(ltMemberOrder, GetMemberName(cardType.MemberOrder)); CtrlHelper.SetText(txtMemberDays, cardType.MemberDays.ToString( )); }
//保存 protected void btnSave_Click(object sender, EventArgs e) { if (!IsValid) { return; } GlobalLivcard cardType; if (IntParam <= 0) { cardType = new GlobalLivcard(); } else { cardType = FacadeManage.aideTreasureFacade.GetGlobalLivcardInfo(IntParam); } cardType.CardName = CtrlHelper.GetText(txtCardTypeName); cardType.CardPrice = Utils.Validate.IsDouble(txtCardPrice.Text.Trim()) ? decimal.Parse(txtCardPrice.Text.Trim()) : 0; cardType.Currency = Convert.ToDecimal(txtCurrency.Text.Trim()); cardType.Gold = CtrlHelper.GetInt(txtGold, 0); if (IntParam <= 0) { //判断权限 AuthUserOperationPermission(Permission.Add); FacadeManage.aideTreasureFacade.InsertGlobalLivcard(cardType); ShowInfo("新增成功", "GlobalLivcardList.aspx", 1200); } else { //判断权限 AuthUserOperationPermission(Permission.Edit); FacadeManage.aideTreasureFacade.UpdateGlobalLivcard(cardType); ShowInfo("更新成功", "GlobalLivcardList.aspx", 1200); } }
//生成实卡 protected void btnCreate_Click(object sender, EventArgs e) { #region 验证 //判断权限 AuthUserOperationPermission(Permission.CreateCard); int cardCount = CtrlHelper.GetInt(txtCount, 0); int cardTypeID = string.IsNullOrEmpty(ddlCardType.SelectedValue) ? 0 : int.Parse(ddlCardType.SelectedValue); if (cardTypeID <= 0) { ShowError("请先添加实卡类型"); return; } if (cardCount <= 0) { ShowError("生成实卡的数量必须大于零的整数"); return; } if (cardCount > 10000) { ShowError("生成实卡的数量一次最多10000张"); return; } // 卡号规则 int cardLen = CtrlHelper.GetInt(txtCardNumLen, 0); if (cardLen < 15 || cardLen > 32) { ShowError("卡号长度必须大于等于15小于32 "); return; } //卡密规则 int passwordLen = CtrlHelper.GetInt(txtPassLen, 0); if (passwordLen < 8 || passwordLen > 32) { ShowError("密码长度必须大于等于8小于33 "); return; } #endregion GlobalLivcard cardType = aideTreasureFacade.GetGlobalLivcardInfo(cardTypeID); if (cardType == null) { ShowError("实卡类型不存在"); return; } byte[] bytes = Encoding.Default.GetBytes(""); LivcardBuildStream cardBuild = new LivcardBuildStream( ); cardBuild.AdminName = userExt.Username; cardBuild.BuildAddr = GameRequest.GetUserIP( ); cardBuild.BuildCardPacket = bytes; cardBuild.BuildCount = cardCount; cardBuild.BuildDate = DateTime.Now; cardBuild.CardGold = cardType.CardGold; cardBuild.CardPrice = cardType.CardPrice; cardBuild.CardTypeID = cardTypeID; cardBuild.DownLoadCount = 0; cardBuild.NoteInfo = CtrlHelper.GetText(txtRemark); int buildID = aideTreasureFacade.InsertLivcardBuildStream(cardBuild); if (buildID <= 0) { ShowError("添加实卡批次失败"); return; } //实卡信息 LivcardAssociator card = new LivcardAssociator( ); card.BuildID = buildID; card.CardTypeID = cardType.CardTypeID; card.CardPrice = cardType.CardPrice; card.CardGold = CtrlHelper.GetInt(txtCardGold, 0); card.MemberOrder = cardType.MemberOrder; card.MemberDays = CtrlHelper.GetInt(txtMemberDays, 0); card.UserRight = cardType.UserRight; card.ServiceRight = cardType.ServiceRight; card.UseRange = int.Parse(ddlUseRange.SelectedValue); card.SalesPerson = CtrlHelper.GetText(txtSalesPerson); card.ValidDate = Convert.ToDateTime(txtValidDate.Text.Trim( )); StringBuilder sb = new StringBuilder( ); string[,] list = new string[cardCount, 2]; int i = 0; Random rand = new Random( ); while (cardCount > 0) { string serialID = GetSerialID(cardLen, cardType.CardTypeID, rand); //卡号 bool isRepeat = false; for (int j = i; j > 0; j--) { if (list[j, 0] == serialID) { isRepeat = true; break; } } if (isRepeat) { isRepeat = false; continue; } string password = GetPassword(passwordLen, rand); //卡密 sb.AppendFormat("{0},{1}/", serialID, password); list[i, 0] = serialID; list[i, 1] = Utility.MD5(password); cardCount--; i++; } aideTreasureFacade.InsertLivcardAssociator(card, list); bytes = Encoding.Default.GetBytes(sb.ToString( )); cardBuild.BuildID = buildID; cardBuild.BuildCardPacket = bytes; try { aideTreasureFacade.UpdateLivcardBuildStream(cardBuild); txtCount.Text = "0"; ShowInfo("生成会员卡成功"); } catch { ShowError("生成会员卡失败"); } }
public Message UpdateGlobalLivcard(GlobalLivcard globalLivcard) { this.aideTreasureData.UpdateGlobalLivcard(globalLivcard); return(new Message(true)); }
public Message InsertGlobalLivcard(GlobalLivcard globalLivcard) { this.aideTreasureData.InsertGlobalLivcard(globalLivcard); return(new Message(true)); }