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/manageCar2.aspx.cs

549 lines
24 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 manageCar2 : Mtxfw.Utility.AdminPage
{
public Mtxfw.DAL.user_info daoUser = new Mtxfw.DAL.user_info();
public Mtxfw.DAL.ConvertiblePaper daoPaper = new Mtxfw.DAL.ConvertiblePaper();
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;
Int64 uu = Convert.ToInt64(u.ToLower());
int g=Convert.ToInt32(TextBox4.Text);
Int32 icount=0;
string strUtype = Drop_DJ.SelectedItem.Value;
Double Amount = 0.00;
if (strUtype == "0")
{
Amount = 20;
}
else if (strUtype == "1")
{
Amount = 50;
}
else if (strUtype == "2")
{
Amount = 100;
}
if(RadioButtonList1.SelectedItem.Value=="0")
{
for (Int64 i = uu; i < uu + g; i++)
{
if (!daoPaper.IsExistsCar(i.ToString()))
{
string p = GetRandomint();
string pp = Mtxfw.Utility.Security.EncryptString(p);
/*Mtxfw.Model.ConvertiblePaper model = new Mtxfw.Model.ConvertiblePaper();
model.CardId = "";
model.AccountId = i.ToString();
model.Password = pp;
model.Amount = Amount;
model.State = "<22><>Ч";
model.Utype = strUtype;
daoPaper.Add(model);*/
string province = "", city = "", county = "", strMemberCard = i.ToString();
Mtxfw.Model.user_info model = new Mtxfw.Model.user_info();
model.MemberCard = strMemberCard;
model.UserName = i.ToString();
model.Password = pp;
model.Password2 = model.Password;
model.RealName = "";
model.NCName = "";
model.UserPic = "";
model.Sex = "";
model.SFZ = "";
model.Mobile = "";
model.Phone = "";
model.Email = "";
model.Province = province;
model.City = city;
model.County = county;
model.MailingAddress = "";
model.PostalCode = "";
model.QQ = "";
model.CompanyName = "";
model.CompanyNumber = "";
model.CompanyContact = "";
model.ProductName = "";
model.UserState = "<22><><EFBFBD><EFBFBD>";
model.RegTime = DateTime.Now;
model.RegTime2 = DateTime.Now;
/*SqlDataReader Dr = daoUser.GetUserId(Text_RememberID.Text);
if (Dr.Read())
{
RememberID = int.Parse(Dr["Id"].ToString());
RememberIDS = Dr["RememberIDS"].ToString();
}
Dr.Close();*/
model.RememberID = 0;
model.RememberIDS = "";
model.SuperiorsID = 0;
model.SuperiorsIDS = "";
model.ContactID = 0;
model.ContactIDS = "";
model.DLRememberID = 0;
model.DLRememberIDS = "";
model.SJRememberID = 0;
model.SJRememberIDS = "";
model.umoney20 = Amount;
model.umoney21 = 0;
model.uLevel0 = 0;
model.uLevel3 = 0;
int uLevel5 = 0;
model.uLevel5 = uLevel5;
model.utype = "0";
model.uutype = "2";
model.openid = "";
model.opentype = 0;
model.opentype2 = 0;
model.refresh_token = "";
model.refresh_token_time = "";
model.IFUpUserName = 0;
int Id=daoUser.Add(model);
daoUser.UpdateMoney("umoney30", 10, Id);
daoUser.UpdateuLevel("uLevel6", 1, Id);
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 (Int64 i = uu; i < uu + g; i++)
{
if (!daoPaper.IsExistsCar(i.ToString()))
{
string pp = Mtxfw.Utility.Security.EncryptString(p.ToString());
/*Mtxfw.Model.ConvertiblePaper model = new Mtxfw.Model.ConvertiblePaper();
model.CardId = "";
model.AccountId = i.ToString();
model.Password = pp;
model.Amount = Amount;
model.State = "<22><>Ч";
model.Utype = strUtype;
daoPaper.Add(model);*/
string province = "", city = "", county = "", strMemberCard = i.ToString();
Mtxfw.Model.user_info model = new Mtxfw.Model.user_info();
model.MemberCard = strMemberCard;
model.UserName = i.ToString();
model.Password = pp;
model.Password2 = model.Password;
model.RealName = "";
model.NCName = "";
model.UserPic = "";
model.Sex = "";
model.SFZ = "";
model.Mobile = "";
model.Phone = "";
model.Email = "";
model.Province = province;
model.City = city;
model.County = county;
model.MailingAddress = "";
model.PostalCode = "";
model.QQ = "";
model.CompanyName = "";
model.CompanyNumber = "";
model.CompanyContact = "";
model.ProductName = "";
model.UserState = "<22><><EFBFBD><EFBFBD>";
model.RegTime = DateTime.Now;
model.RegTime2 = DateTime.Now;
/*SqlDataReader Dr = daoUser.GetUserId(Text_RememberID.Text);
if (Dr.Read())
{
RememberID = int.Parse(Dr["Id"].ToString());
RememberIDS = Dr["RememberIDS"].ToString();
}
Dr.Close();*/
model.RememberID = 0;
model.RememberIDS = "";
model.SuperiorsID = 0;
model.SuperiorsIDS = "";
model.ContactID = 0;
model.ContactIDS = "";
model.DLRememberID = 0;
model.DLRememberIDS = "";
model.SJRememberID = 0;
model.SJRememberIDS = "";
model.umoney20 = Amount;
model.umoney21 = 0;
model.uLevel0 = 0;
model.uLevel3 = 0;
int uLevel5 = 0;
model.uLevel5 = uLevel5;
model.utype = "0";
model.uutype = "2";
model.openid = "";
model.opentype = 0;
model.opentype2 = 0;
model.refresh_token = "";
model.refresh_token_time = "";
model.IFUpUserName = 0;
int Id = daoUser.Add(model);
//daoUser.UpdateMoney("umoney15", Amount, Id);
//daoUser.UpdateMoney("umoney16", Amount, Id);
daoUser.UpdateuLevel("uLevel6", 1, Id);
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.ToString()));
//<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 (Int64 i = uu; i < uu + g; i++)
{
if (!daoPaper.IsExistsCar(i.ToString()))
{
string pp = Mtxfw.Utility.Security.EncryptString(p);
/*Mtxfw.Model.ConvertiblePaper model = new Mtxfw.Model.ConvertiblePaper();
model.CardId = "";
model.AccountId = i.ToString();
model.Password = pp;
model.Amount = Amount;
model.State = "<22><>Ч";
model.Utype = strUtype;
daoPaper.Add(model);*/
string province = "", city = "", county = "", strMemberCard = i.ToString();
Mtxfw.Model.user_info model = new Mtxfw.Model.user_info();
model.MemberCard = strMemberCard;
model.UserName = i.ToString();
model.Password = pp;
model.Password2 = model.Password;
model.RealName = "";
model.NCName = "";
model.UserPic = "";
model.Sex = "";
model.SFZ = "";
model.Mobile = "";
model.Phone = "";
model.Email = "";
model.Province = province;
model.City = city;
model.County = county;
model.MailingAddress = "";
model.PostalCode = "";
model.QQ = "";
model.CompanyName = "";
model.CompanyNumber = "";
model.CompanyContact = "";
model.ProductName = "";
model.UserState = "<22><><EFBFBD><EFBFBD>";
model.RegTime = DateTime.Now;
model.RegTime2 = DateTime.Now;
/*SqlDataReader Dr = daoUser.GetUserId(Text_RememberID.Text);
if (Dr.Read())
{
RememberID = int.Parse(Dr["Id"].ToString());
RememberIDS = Dr["RememberIDS"].ToString();
}
Dr.Close();*/
model.RememberID = 0;
model.RememberIDS = "";
model.SuperiorsID = 0;
model.SuperiorsIDS = "";
model.ContactID = 0;
model.ContactIDS = "";
model.DLRememberID = 0;
model.DLRememberIDS = "";
model.SJRememberID = 0;
model.SJRememberIDS = "";
model.umoney20 = Amount;
model.umoney21 = 0;
model.uLevel0 = 0;
model.uLevel3 = 0;
int uLevel5 = 0;
model.uLevel5 = uLevel5;
model.utype = "0";
model.uutype = "2";
model.openid = "";
model.opentype = 0;
model.opentype2 = 0;
model.refresh_token = "";
model.refresh_token_time = "";
model.IFUpUserName = 0;
int Id = daoUser.Add(model);
//daoUser.UpdateMoney("umoney15", Amount, Id);
//daoUser.UpdateMoney("umoney16", Amount, Id);
daoUser.UpdateuLevel("uLevel6", 1, Id);
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 = "";
}
string strUtype = Drop_DJ.SelectedItem.Value;
Double Amount = 0;
if (strUtype == "0")
{
Amount = 20;
}
else if (strUtype == "1")
{
Amount = 50;
}
else if (strUtype == "2")
{
Amount = 100;
}
if (!daoPaper.IsExistsCar(strQuasiNumber))
{
string pp = Mtxfw.Utility.Security.EncryptString(strMM);
/*Mtxfw.Model.ConvertiblePaper model = new Mtxfw.Model.ConvertiblePaper();
model.CardId = "";
model.AccountId = strQuasiNumber;
model.Password = pp;
model.Amount = Amount;
model.State = "<22><>Ч";
model.Utype = strUtype;
daoPaper.Add(model);*/
string province = "", city = "", county = "", strMemberCard = strQuasiNumber;
Mtxfw.Model.user_info model = new Mtxfw.Model.user_info();
model.MemberCard = strMemberCard;
model.UserName = strQuasiNumber;
model.Password = pp;
model.Password2 = model.Password;
model.RealName = "";
model.NCName = "";
model.UserPic = "";
model.Sex = "";
model.SFZ = "";
model.Mobile = "";
model.Phone = "";
model.Email = "";
model.Province = province;
model.City = city;
model.County = county;
model.MailingAddress = "";
model.PostalCode = "";
model.QQ = "";
model.CompanyName = "";
model.CompanyNumber = "";
model.CompanyContact = "";
model.ProductName = "";
model.UserState = "<22><><EFBFBD><EFBFBD>";
model.RegTime = DateTime.Now;
model.RegTime2 = DateTime.Now;
/*SqlDataReader Dr = daoUser.GetUserId(Text_RememberID.Text);
if (Dr.Read())
{
RememberID = int.Parse(Dr["Id"].ToString());
RememberIDS = Dr["RememberIDS"].ToString();
}
Dr.Close();*/
model.RememberID = 0;
model.RememberIDS = "";
model.SuperiorsID = 0;
model.SuperiorsIDS = "";
model.ContactID = 0;
model.ContactIDS = "";
model.DLRememberID = 0;
model.DLRememberIDS = "";
model.SJRememberID = 0;
model.SJRememberIDS = "";
model.umoney20 = Amount;
model.umoney21 = 0;
model.uLevel0 = 0;
model.uLevel3 = 0;
int uLevel5 = 0;
model.uLevel5 = uLevel5;
model.utype = "0";
model.uutype = "2";
model.openid = "";
model.opentype = 0;
model.opentype2 = 0;
model.refresh_token = "";
model.refresh_token_time = "";
model.IFUpUserName = 0;
int Id = daoUser.Add(model);
//daoUser.UpdateMoney("umoney15", Amount, Id);
//daoUser.UpdateMoney("umoney16", Amount, Id);
daoUser.UpdateuLevel("uLevel6", 1, Id);
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