ss001/g.hnyhua.cn
1
0
Fork 0
Code Issues Pull Requests Actions Packages Projects Releases Wiki Activity
Files
main
g.hnyhua.cn/Mtxfw.shop/_Admin/manageCar.aspx.cs

319 lines
14 KiB
C#
Raw Permalink Normal View History

代码修改后的版本，全部提交
2026-02-07 15:48:27 +08:00
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 <20><>ժҪ˵<D2AA><CBB5><EFBFBD><EFBFBD>
/// </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)
{
// <20>ڴ˴<DAB4><CBB4><EFBFBD><EFBFBD><EFBFBD><EFBFBD>û<EFBFBD><C3BB><EFBFBD><EFBFBD><EFBFBD><EFBFBD>Գ<EFBFBD>ʼ<EFBFBD><CABC>ҳ<EFBFBD><D2B3>
if (!Page.IsPostBack)
{
}
}
protected void button1_Click(object sender, System.EventArgs e)
{
if(TextBox1.Text.Trim()=="index")
{
Response.Write("<script language='javascript'>alert('<27>˺Ų<CBBA><C5B2><EFBFBD>Ϊ<EFBFBD>գ<EFBFBD>')</script>");
}
else if(TextBox4.Text.Trim()=="")
{
Response.Write("<script language='javascript'>alert('<27>˺Ÿ<CBBA><C5B8><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>Ϊ<EFBFBD>գ<EFBFBD>')</script>");
}
else
{
string ConnStr = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=" + Server.MapPath("/App_Data/card.xls") + ";" + "Extended Properties=Excel 8.0;";
//<2F><><EFBFBD><EFBFBD>EXCEL<45><4C>
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 = "δע<CEB4><D7A2>";
model.RegTime = DateTime.Now;
model.utype = Drop_DJ.SelectedItem.Value;
daoUser.Add(model);
OleDbCommand mycmd = new OleDbCommand("insert into [Sheet1$]([<5B><><EFBFBD><EFBFBD>],[<5B><><EFBFBD><EFBFBD>]) values(@strCark,@strMM)", myconn);
mycmd.CommandType = CommandType.Text;
mycmd.Parameters.Add(new OleDbParameter("@strCark", i.ToString()));
mycmd.Parameters.Add(new OleDbParameter("@strMM", p));
//<2F><><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ݿ<EFBFBD><DDBF><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>
if (myconn.State == 0)
{
myconn.Open();
}
//ִ<>в<EFBFBD><D0B2><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ݿ⣩
mycmd.ExecuteNonQuery();
//<2F>ر<EFBFBD><D8B1><EFBFBD><EFBFBD>ݿ<EFBFBD><DDBF><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>
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 = "δע<CEB4><D7A2>";
model.RegTime = DateTime.Now;
model.utype = Drop_DJ.SelectedItem.Value;
daoUser.Add(model);
OleDbCommand mycmd = new OleDbCommand("insert into [Sheet1$]([<5B><><EFBFBD><EFBFBD>],[<5B><><EFBFBD><EFBFBD>]) values(@strCark,@strMM)", myconn);
mycmd.CommandType = CommandType.Text;
mycmd.Parameters.Add(new OleDbParameter("@strCark", i.ToString()));
mycmd.Parameters.Add(new OleDbParameter("@strMM", p));
//<2F><><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ݿ<EFBFBD><DDBF><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>
if (myconn.State == 0)
{
myconn.Open();
}
//ִ<>в<EFBFBD><D0B2><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ݿ⣩
mycmd.ExecuteNonQuery();
//<2F>ر<EFBFBD><D8B1><EFBFBD><EFBFBD>ݿ<EFBFBD><DDBF><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>
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 = "δע<CEB4><D7A2>";
model.RegTime = DateTime.Now;
model.utype = Drop_DJ.SelectedItem.Value;
daoUser.Add(model);
OleDbCommand mycmd = new OleDbCommand("insert into [Sheet1$]([<5B><><EFBFBD><EFBFBD>],[<5B><><EFBFBD><EFBFBD>]) values(@strCark,@strMM)", myconn);
mycmd.CommandType = CommandType.Text;
mycmd.Parameters.Add(new OleDbParameter("@strCark", i.ToString()));
mycmd.Parameters.Add(new OleDbParameter("@strMM", p));
//<2F><><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ݿ<EFBFBD><DDBF><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>
if (myconn.State == 0)
{
myconn.Open();
}
//ִ<>в<EFBFBD><D0B2><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ݿ⣩
mycmd.ExecuteNonQuery();
//<2F>ر<EFBFBD><D8B1><EFBFBD><EFBFBD>ݿ<EFBFBD><DDBF><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>
myconn.Close();
icount += 1;
}
}
}
}
Mtxfw.Utility.Tools.Message("<22>ɹ<EFBFBD><C9B9><EFBFBD><EFBFBD><EFBFBD>" + icount + "<22><><EFBFBD><EFBFBD><EFBFBD><EFBFBD>!", 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;";
//<2F><><EFBFBD><EFBFBD>EXCEL<45><4C>
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["<22><><EFBFBD><EFBFBD>"] != null)
{
strQuasiNumber = myDrv["<22><><EFBFBD><EFBFBD>"].ToString();
}
}
catch
{
strQuasiNumber = "";
}
try
{
if (myDrv["<22><><EFBFBD><EFBFBD>"] != null)
{
strMM = myDrv["<22><><EFBFBD><EFBFBD>"].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 = "δע<CEB4><D7A2>";
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("<22>ɹ<EFBFBD><C9B9><EFBFBD><EFBFBD><EFBFBD>" + icount + "<22><><EFBFBD><EFBFBD><EFBFBD><EFBFBD>!", Request.Url.AbsoluteUri);
}
}
}
Reference in New Issue Copy Permalink