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