319 lines
14 KiB
C#
319 lines
14 KiB
C#
using System;
|
|
using System.Collections;
|
|
using System.ComponentModel;
|
|
using System.Data;
|
|
using System.Data.OleDb;
|
|
using System.Drawing;
|
|
using System.Web;
|
|
using System.Web.SessionState;
|
|
using System.Web.UI;
|
|
using System.Web.UI.WebControls;
|
|
using System.Web.UI.HtmlControls;
|
|
using System.IO;
|
|
namespace Mtxfw.shop._admin
|
|
{
|
|
/// <summary>
|
|
/// index 的摘要说明。
|
|
/// </summary>
|
|
public partial class manageCar : Mtxfw.Utility.AdminPage
|
|
{
|
|
|
|
public Mtxfw.DAL.user_info daoUser = new Mtxfw.DAL.user_info();
|
|
protected void Page_Load(object sender, System.EventArgs e)
|
|
{
|
|
// 在此处放置用户代码以初始化页面
|
|
|
|
if (!Page.IsPostBack)
|
|
{
|
|
|
|
}
|
|
}
|
|
|
|
|
|
|
|
|
|
protected void button1_Click(object sender, System.EventArgs e)
|
|
{
|
|
if(TextBox1.Text.Trim()=="index")
|
|
{
|
|
Response.Write("<script language='javascript'>alert('账号不能为空！')</script>");
|
|
}
|
|
|
|
else if(TextBox4.Text.Trim()=="")
|
|
{
|
|
Response.Write("<script language='javascript'>alert('账号个数不能为空！')</script>");
|
|
}
|
|
else
|
|
{
|
|
string ConnStr = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=" + Server.MapPath("/App_Data/card.xls") + ";" + "Extended Properties=Excel 8.0;";
|
|
//建立EXCEL的
|
|
|
|
|
|
OleDbConnection myconn = new OleDbConnection(ConnStr);
|
|
|
|
string u=TextBox1.Text;
|
|
int uu=Convert.ToInt32(u.ToLower());
|
|
int g=Convert.ToInt32(TextBox4.Text);
|
|
Int32 icount=0;
|
|
if(RadioButtonList1.SelectedItem.Value=="0")
|
|
{
|
|
for(int i=uu;i<uu+g;i++)
|
|
{
|
|
if (!daoUser.IsExistsCar(i.ToString()))
|
|
{
|
|
Mtxfw.Model.user_info model = new Mtxfw.Model.user_info();
|
|
if (model != null)
|
|
{
|
|
string p = GetRandomint();
|
|
string pp = Mtxfw.Utility.Security.EncryptString(p);
|
|
model.MemberCard = i.ToString();
|
|
model.UserName = "";
|
|
model.Password = pp;
|
|
model.Password2 = pp;
|
|
model.RealName = "";
|
|
model.Sex = "";
|
|
model.SFZ = "";
|
|
model.Mobile = "";
|
|
model.Phone = "";
|
|
model.Email = "";
|
|
model.Province = "";
|
|
model.City = "";
|
|
model.County = "";
|
|
model.MailingAddress = "";
|
|
model.PostalCode = "";
|
|
model.QQ = "";
|
|
model.CompanyName = "";
|
|
model.CompanyNumber = "";
|
|
model.CompanyContact = "";
|
|
model.UserState = "未注册";
|
|
model.RegTime = DateTime.Now;
|
|
model.utype = Drop_DJ.SelectedItem.Value;
|
|
daoUser.Add(model);
|
|
|
|
OleDbCommand mycmd = new OleDbCommand("insert into [Sheet1$]([卡号],[密码]) values(@strCark,@strMM)", myconn);
|
|
mycmd.CommandType = CommandType.Text;
|
|
mycmd.Parameters.Add(new OleDbParameter("@strCark", i.ToString()));
|
|
mycmd.Parameters.Add(new OleDbParameter("@strMM", p));
|
|
//打开数据库的连接
|
|
if (myconn.State == 0)
|
|
{
|
|
myconn.Open();
|
|
}
|
|
//执行操作（访问数据库）
|
|
mycmd.ExecuteNonQuery();
|
|
//关闭数据库的连接
|
|
myconn.Close();
|
|
icount += 1;
|
|
}
|
|
}
|
|
}
|
|
}
|
|
else if(RadioButtonList1.SelectedItem.Value=="1")
|
|
{
|
|
int p = Convert.ToInt32(TextBox2.Text);
|
|
for(int i=uu;i<uu+g;i++)
|
|
{
|
|
if (!daoUser.IsExistsCar(i.ToString()))
|
|
{
|
|
Mtxfw.Model.user_info model = new Mtxfw.Model.user_info();
|
|
if (model != null)
|
|
{
|
|
string pp = Mtxfw.Utility.Security.EncryptString(p.ToString());
|
|
model.MemberCard = i.ToString();
|
|
model.UserName = "";
|
|
model.Password = pp;
|
|
model.Password2 = pp;
|
|
model.RealName = "";
|
|
model.Sex = "";
|
|
model.SFZ = "";
|
|
model.Mobile = "";
|
|
model.Phone = "";
|
|
model.Email = "";
|
|
model.Province = "";
|
|
model.City = "";
|
|
model.County = "";
|
|
model.MailingAddress = "";
|
|
model.PostalCode = "";
|
|
model.QQ = "";
|
|
model.CompanyName = "";
|
|
model.CompanyNumber = "";
|
|
model.CompanyContact = "";
|
|
model.UserState = "未注册";
|
|
model.RegTime = DateTime.Now;
|
|
model.utype = Drop_DJ.SelectedItem.Value;
|
|
daoUser.Add(model);
|
|
OleDbCommand mycmd = new OleDbCommand("insert into [Sheet1$]([卡号],[密码]) values(@strCark,@strMM)", myconn);
|
|
mycmd.CommandType = CommandType.Text;
|
|
mycmd.Parameters.Add(new OleDbParameter("@strCark", i.ToString()));
|
|
mycmd.Parameters.Add(new OleDbParameter("@strMM", p));
|
|
//打开数据库的连接
|
|
if (myconn.State == 0)
|
|
{
|
|
myconn.Open();
|
|
}
|
|
//执行操作（访问数据库）
|
|
mycmd.ExecuteNonQuery();
|
|
//关闭数据库的连接
|
|
myconn.Close();
|
|
icount += 1;
|
|
}
|
|
}
|
|
p+=1;
|
|
}
|
|
}
|
|
else if(RadioButtonList1.SelectedItem.Value=="2")
|
|
{
|
|
string p = TextBox2.Text;
|
|
for(int i=uu;i<uu+g;i++)
|
|
{
|
|
if (!daoUser.IsExistsCar(i.ToString()))
|
|
{
|
|
Mtxfw.Model.user_info model = new Mtxfw.Model.user_info();
|
|
if (model != null)
|
|
{
|
|
|
|
string pp = Mtxfw.Utility.Security.EncryptString(p);
|
|
model.MemberCard = i.ToString();
|
|
model.UserName = "";
|
|
model.Password = pp;
|
|
model.Password2 = pp;
|
|
model.RealName = "";
|
|
model.Sex = "";
|
|
model.SFZ = "";
|
|
model.Mobile = "";
|
|
model.Phone = "";
|
|
model.Email = "";
|
|
model.Province = "";
|
|
model.City = "";
|
|
model.County = "";
|
|
model.MailingAddress = "";
|
|
model.PostalCode = "";
|
|
model.QQ = "";
|
|
model.CompanyName = "";
|
|
model.CompanyNumber = "";
|
|
model.CompanyContact = "";
|
|
model.UserState = "未注册";
|
|
model.RegTime = DateTime.Now;
|
|
model.utype = Drop_DJ.SelectedItem.Value;
|
|
daoUser.Add(model);
|
|
OleDbCommand mycmd = new OleDbCommand("insert into [Sheet1$]([卡号],[密码]) values(@strCark,@strMM)", myconn);
|
|
mycmd.CommandType = CommandType.Text;
|
|
mycmd.Parameters.Add(new OleDbParameter("@strCark", i.ToString()));
|
|
mycmd.Parameters.Add(new OleDbParameter("@strMM", p));
|
|
//打开数据库的连接
|
|
if (myconn.State == 0)
|
|
{
|
|
myconn.Open();
|
|
}
|
|
//执行操作（访问数据库）
|
|
mycmd.ExecuteNonQuery();
|
|
//关闭数据库的连接
|
|
myconn.Close();
|
|
icount += 1;
|
|
}
|
|
}
|
|
}
|
|
}
|
|
|
|
Mtxfw.Utility.Tools.Message("成功生成" + icount + "个卡号!", Request.Url.AbsoluteUri);
|
|
}
|
|
}
|
|
private string GetRandomint()
|
|
{
|
|
Random random = new Random();
|
|
return (random.Next(100000,999999).ToString());
|
|
}
|
|
protected void button2_Click(object sender, System.EventArgs e)
|
|
{
|
|
string FileName, FileType, Folders;
|
|
int icount = 0;
|
|
Folders = "/App_Data/";
|
|
FileName = DateTime.Now.Year.ToString() + DateTime.Now.Month.ToString() + DateTime.Now.Day.ToString() + DateTime.Now.Hour.ToString() + DateTime.Now.Second.ToString() + DateTime.Now.Minute.ToString() + DateTime.Now.Millisecond.ToString();
|
|
FileType = UploadFile.PostedFile.FileName.Substring(UploadFile.PostedFile.FileName.LastIndexOf(".")).ToLower();
|
|
string strFilePath = Folders + FileName + FileType;
|
|
UploadFile.PostedFile.SaveAs(Server.MapPath(strFilePath));
|
|
string ConnStr = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=" + Server.MapPath(strFilePath) + ";" + "Extended Properties=Excel 8.0;";
|
|
//建立EXCEL的
|
|
OleDbConnection myconn = new OleDbConnection(ConnStr);
|
|
myconn.Open();
|
|
OleDbCommand mycmd = new OleDbCommand("SELECT * FROM [Sheet1$]", myconn);
|
|
OleDbDataAdapter myAdapter = new OleDbDataAdapter();
|
|
myAdapter.SelectCommand = mycmd;
|
|
DataSet myDataset1 = new DataSet();
|
|
myAdapter.Fill(myDataset1, "XLData");
|
|
DataTable dt = myDataset1.Tables[0];
|
|
DataView myView = new DataView(dt);
|
|
foreach (DataRowView myDrv in myView)
|
|
{
|
|
string strQuasiNumber = "", strMM = "";
|
|
try
|
|
{
|
|
if (myDrv["卡号"] != null)
|
|
{
|
|
strQuasiNumber = myDrv["卡号"].ToString();
|
|
}
|
|
}
|
|
catch
|
|
{
|
|
strQuasiNumber = "";
|
|
}
|
|
try
|
|
{
|
|
if (myDrv["密码"] != null)
|
|
{
|
|
strMM = myDrv["密码"].ToString();
|
|
}
|
|
}
|
|
catch
|
|
{
|
|
strMM = "";
|
|
}
|
|
|
|
if (!daoUser.IsExistsCar(strQuasiNumber))
|
|
{
|
|
Mtxfw.Model.user_info model = new Mtxfw.Model.user_info();
|
|
if (model != null)
|
|
{
|
|
|
|
string pp = Mtxfw.Utility.Security.EncryptString(strMM);
|
|
|
|
model.MemberCard = strQuasiNumber;
|
|
model.UserName = "";
|
|
model.Password = pp;
|
|
model.Password2 = pp;
|
|
model.RealName = "";
|
|
model.Sex = "";
|
|
model.SFZ = "";
|
|
model.Mobile = "";
|
|
model.Phone = "";
|
|
model.Email = "";
|
|
model.Province = "";
|
|
model.City = "";
|
|
model.County = "";
|
|
model.MailingAddress = "";
|
|
model.PostalCode = "";
|
|
model.QQ = "";
|
|
model.CompanyName = "";
|
|
model.CompanyNumber = "";
|
|
model.CompanyContact = "";
|
|
model.UserState = "未注册";
|
|
model.RegTime = DateTime.Now;
|
|
model.utype = Drop_DJ.SelectedItem.Value;
|
|
daoUser.Add(model);
|
|
icount += 1;
|
|
}
|
|
}
|
|
}
|
|
myView.Table.Clear();
|
|
myconn.Close();
|
|
if (File.Exists(Server.MapPath(strFilePath)))
|
|
{
|
|
File.Delete(Server.MapPath(strFilePath));
|
|
}
|
|
Mtxfw.Utility.Tools.Message("成功生成" + icount + "个卡号!", Request.Url.AbsoluteUri);
|
|
}
|
|
|
|
}
|
|
|
|
}
|