62,025
社区成员
发帖
与我相关
我的任务
分享
DataTable dt = GetTable();
for (int i = 0; i < Convert.ToInt32(txt_count.Text); i++)
{
new_gift card = new new_gift();
card.gift_id = Convert.ToInt32(txt_id.Text.Trim());
card.type = 0;
card.serial_num = CommonMethod.GetRandomString(16).ToUpper();
//写入数据库
var collection = db.GetCollection<new_gift>("new_gift");
collection.Insert(card);
//保存到DateTable
DataRow dr = dt.NewRow();
dr["gift_id"] = card.gift_id;
dr["serial_num"] = card.serial_num;
dt.Rows.Add(dr);
}
//调用导出Excel的方法
CreateExcel.CreateExcelByDataTable(dt, "礼包ID-" + txt_id.Text.Trim());
private string GetRandomCode()
{
char[] chars = { '0', '1', '2', '3', '4', '5', '6', '7', '8', '9' }; //随机数范围,填上字母就会生成字母
string code = string.Empty;
for (int i = 0; i < 4; i++) //4是生成多少位的随机数,自己可以改
{
Random rnd = new Random(GetRandomSeed());
code += chars[rnd.Next(0, 10)].ToString();
}
return code;
}
private int GetRandomSeed()
{
byte[] bytes = new byte[4];
System.Security.Cryptography.RNGCryptoServiceProvider rng = new System.Security.Cryptography.RNGCryptoServiceProvider();
rng.GetBytes(bytes);
return BitConverter.ToInt32(bytes, 0);
}
Random rdm = new Random(unchecked((int)DateTime.Now.Ticks));