private void BindData( ) { LivcardAssociator card = FacadeManage.aideTreasureFacade.GetLivcardAssociatorInfo(StrParam); if (card == null) { return; } CtrlHelper.SetText(ltSerialID, card.SerialID); CtrlHelper.SetText(ltCardTypeName, GetCardTypeName(card.CardTypeID)); CtrlHelper.SetText(ltBuildID, card.BuildID.ToString( )); CtrlHelper.SetText(ltCardPrice, card.CardPrice.ToString( )); CtrlHelper.SetText(ltCurrency, card.Currency.ToString()); CtrlHelper.SetText(ltUseRange, GetUserRange(card.UseRange)); CtrlHelper.SetText(ltValidDate, card.ValidDate.ToString("yyyy-MM-dd HH:mm:ss")); CtrlHelper.SetText(ltBuildDate, card.BuildDate.ToString("yyyy-MM-dd HH:mm:ss")); CtrlHelper.SetText(ltSalesPerson, card.SalesPerson); CtrlHelper.SetText(ltNullity, GetNullityStatus(card.Nullity)); if (card.ApplyDate != null) { ShareDetailInfo detailInfo = FacadeManage.aideTreasureFacade.GetShareDetailInfo(StrParam); if (detailInfo != null) { plPyaCard.Visible = true; lbPayCardMsg.Text = "充值信息"; CtrlHelper.SetText(ltPayDate, detailInfo.ApplyDate.ToString( )); CtrlHelper.SetText(ltPayUser, GetAccounts(detailInfo.UserID) + "(" + GetGameID(detailInfo.UserID) + ")"); CtrlHelper.SetText(ltPayOperUser, GetAccounts(detailInfo.OperUserID)); CtrlHelper.SetText(ltPayBeforeCurrency, detailInfo.BeforeCurrency.ToString()); CtrlHelper.SetText(ltPayAddress, detailInfo.IPAddress + " " + Utils.IPQuery.GetAddressWithIP(detailInfo.IPAddress)); } } }
/// <summary> /// 获取实卡实体,根据SerialID /// </summary> /// <param name="serialID"></param> /// <returns></returns> public LivcardAssociator GetLivcardAssociatorInfo(string serialID) { string sqlQuery = string.Format("(NOLOCK) WHERE SerialID= '{0}'", serialID); LivcardAssociator livcardAssociator = aideLivcardAssociatorProvider.GetObject <LivcardAssociator>(sqlQuery); return(livcardAssociator); }
private void BindData( ) { LivcardAssociator card = aideTreasureFacade.GetLivcardAssociatorInfo(StrParam); if (card == null) { return; } CtrlHelper.SetText(ltSerialID, card.SerialID); CtrlHelper.SetText(ltCardTypeName, GetCardTypeName(card.CardTypeID)); CtrlHelper.SetText(ltBuildID, card.BuildID.ToString( )); CtrlHelper.SetText(ltCardPrice, card.CardPrice.ToString( )); CtrlHelper.SetText(ltCardGold, card.CardGold.ToString( )); CtrlHelper.SetText(ltMemberOrder, GetMemberName(card.MemberOrder)); CtrlHelper.SetText(ltMemberDays, card.MemberDays.ToString( )); CtrlHelper.SetText(ltUseRange, GetUserRange(card.UseRange)); CtrlHelper.SetText(ltValidDate, card.ValidDate.ToString("yyyy-MM-dd HH:mm:ss")); CtrlHelper.SetText(ltBuildDate, card.BuildDate.ToString("yyyy-MM-dd HH:mm:ss")); CtrlHelper.SetText(ltSalesPerson, card.SalesPerson); CtrlHelper.SetText(ltNullity, GetNullityStatus(card.Nullity)); if (card.ApplyDate != null) { ShareDetailInfo detailInfo = aideTreasureFacade.GetShareDetailInfo(StrParam); if (detailInfo != null) { plPyaCard.Visible = true; lbPayCardMsg.Text = "充值信息"; CtrlHelper.SetText(ltPayDate, detailInfo.ApplyDate.ToString( )); CtrlHelper.SetText(ltPayUser, GetAccounts(detailInfo.UserID) + "(" + GetGameID(detailInfo.UserID) + ")"); CtrlHelper.SetText(ltPayOperUser, GetAccounts(detailInfo.OperUserID)); CtrlHelper.SetText(ltPayBeforeGold, detailInfo.BeforeGold.ToString()); CtrlHelper.SetText(ltPayAddress, detailInfo.IPAddress + " " + Utils.IPQuery.GetAddressWithIP(detailInfo.IPAddress)); } } //用户权限 int intUserRight = card.UserRight; if (ckbUserRight.Items.Count > 0) { foreach (ListItem item in ckbUserRight.Items) { item.Selected = int.Parse(item.Value) == (intUserRight & int.Parse(item.Value)); } } }
/// <summary> /// 插入实卡记录 /// </summary> /// <param name="livcardAssociator"></param> /// <returns></returns> public void InsertLivcardAssociator(LivcardAssociator livcardAssociator, string[,] list) { for (int i = 0; i < list.GetLength(0); i++) { var prams = new List <DbParameter>( ); prams.Add(Database.MakeInParam("SerialID", list[i, 0])); prams.Add(Database.MakeInParam("Password", list[i, 1])); prams.Add(Database.MakeInParam("BuildID", livcardAssociator.BuildID)); prams.Add(Database.MakeInParam("CardTypeID", livcardAssociator.CardTypeID)); prams.Add(Database.MakeInParam("CardPrice", livcardAssociator.CardPrice)); prams.Add(Database.MakeInParam("CardGold", livcardAssociator.CardGold)); prams.Add(Database.MakeInParam("MemberOrder", livcardAssociator.MemberOrder)); prams.Add(Database.MakeInParam("MemberDays", livcardAssociator.MemberDays)); prams.Add(Database.MakeInParam("UserRight", livcardAssociator.UserRight)); prams.Add(Database.MakeInParam("ServiceRight", livcardAssociator.ServiceRight)); prams.Add(Database.MakeInParam("UseRange", livcardAssociator.UseRange)); prams.Add(Database.MakeInParam("SalesPerson", livcardAssociator.SalesPerson)); prams.Add(Database.MakeInParam("ValidDate", livcardAssociator.ValidDate)); Database.RunProc("WSP_PM_LivcardAdd", prams); } }
//生成实卡 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 void InsertLivcardAssociator(LivcardAssociator livcardAssociator, string[,] list) { this.aideTreasureData.InsertLivcardAssociator(livcardAssociator, list); }