excletocustomerinfo.aspx.cs
来自「该服务平台解决了计算机网络与移动网络之间信息交换问题」· CS 代码 · 共 636 行 · 第 1/2 页
CS
636 行
using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using Common;
public partial class Customermanangement_ExcletoCustomerInfo : System.Web.UI.Page
{
private Security.RulesManagement rulesManagement;
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
rulesManagement = new Security.RulesManagement();
int rolesID = 0;
try
{
HttpCookie rolesCookie = Request.Cookies["RolesID"];
//rolesID = int.Parse(rolesCookie.Value);
rolesID = int.Parse(Session["RolesID"].ToString());
if (rulesManagement.ValidUserRules(rolesID, 18))
{
FillComboBox();
}
else
{
Response.Redirect("../none.aspx");
}
}
catch
{
Response.Redirect("../none.aspx");
}
}
}
private void FillComboBox()
{
DataAccess.TableAccessor.CountyVillage countyVillage = new DataAccess.TableAccessor.CountyVillage();
cbUserTeam.DataTextField = "TypeName";
cbUserTeam.DataValueField = "TypeID";
cbUserTeam.DataSource = countyVillage.GetcoustomertypeInfo();
cbUserTeam.DataBind();
cbUserTeam.Items.Insert(0, "");
}
protected void cbUserTeam_SelectedIndexChanged(object sender, EventArgs e)
{
if (cbUserTeam.SelectedValue != "")
{
int userTeamID = int.Parse(cbUserTeam.SelectedValue);
DataAccess.TableAccessor.UserConporation userCorporation = new DataAccess.TableAccessor.UserConporation();
cbDept.DataTextField = "GroupName";
cbDept.DataValueField = "GroupID";
cbDept.DataSource = userCorporation.GetMostGroupByTypeID(userTeamID);
cbDept.DataBind();
cbDept.Items.Insert(0, "");
}
}
protected void btnExcelFileDown_Click(object sender, EventArgs e)
{
int userTeam = 0;
int deptID = 0;
if (cbUserTeam.SelectedValue == "")
{
//Response.Write("<script language='javascript'>alert('请选择群组！');</script>");
//return;
this.textLabel.Text = "<script language='javascript'>alert('请选择群组！');</script>";
return;
}
if (cbDept.SelectedValue == "")
{
//Response.Write("<script language='javascript'>alert('请选择部门单位！');</script>");
//return;
this.textLabel.Text = "<script language='javascript'>alert('请选择部门单位！');</script>";
return;
}
userTeam = int.Parse(cbUserTeam.SelectedValue);
deptID = int.Parse(cbDept.SelectedValue);
String excelPath = Server.MapPath(@".\UpLoadFiles\" + "ExcelFile.xls");
DataAccess.ExcelTransfer excelTransfer = new DataAccess.ExcelTransfer(excelPath);
if (excelTransfer.InsertDataToExcel(userTeam, deptID, 100) > 0)
{
String url = "UpLoadFiles/ExcelFile.xls";
//HttpResponse response = HttpContext.Current.Response;
//string js = "<script language=javascript>window.open('{0}');</script>";
//js = string.Format(js, url);
//response.Write(js);
Response.Redirect("UpLoadFiles/ExcelFile.xls");
}
else
{
this.textLabel.Text = "<script language='javascript'>alert('下载文件失败！');</script>";
//Response.Write("<script language='javascript'>alert('下载文件失败！');</script>");
return;
}
}
public override void VerifyRenderingInServerForm(Control control)
{
//base.VerifyRenderingInServerForm(control);
}
private void ShowExcelFile(String excelPathName, String excelTableName)
{
DataAccess.ExcelTransfer excelTransfer = new DataAccess.ExcelTransfer(excelPathName, excelTableName);
DataTable dt = excelTransfer.GetExcelFileData();
gvDownExcel.DataSource = dt;
gvDownExcel.DataBind();
}
public void UploadFile(object sender, EventArgs E)
{
//检查上传文件不为空
if (myFile.PostedFile != null)
{
string nam = myFile.PostedFile.FileName;
//取得文件名(抱括路径)里最后一个"."的索引
int i = nam.LastIndexOf(".");
if (i == -1)
{
this.textLabel.Text = "<script language='javascript'>alert('上传文件不为空！');</script>";
return;
}
//取得文件扩展名
string newext = nam.Substring(i);
//这里我自动根据日期和文件大小不同为文件命名,确保文件名不重复
DateTime now = DateTime.Now;
string newname = now.Year.ToString() + now.Month.ToString() + now.Day.ToString() + now.Hour.ToString() +
now.Minute + now.Second.ToString() + myFile.PostedFile.ContentLength.ToString();
//保存文件到你所要的目录,这里是IIS根目录下的uploadfiles目录
//注意: 我这里用Server.MapPath()取当前文件的绝对目录.
String excelPath = Server.MapPath(@".\UpLoadFiles\" + newname + newext);
myFile.PostedFile.SaveAs(excelPath);
//得到这个文件的相关属性:文件名,文件类型,文件大小
tbFileName.Text = myFile.PostedFile.FileName;
tbFileType.Text = myFile.PostedFile.ContentType;
tbFileSize.Text = myFile.PostedFile.ContentLength.ToString();
gvDownExcel.Visible = true;
try
{
ShowExcelFile(excelPath, tbExcelTableName.Text);
// LabelTitle.Visible = false;
}
catch
{
this.textLabel.Text = "<script language='javascript'>alert('上传数据失败！');</script>";
//Response.Write("<script language='javascript'>alert('上传数据失败！');</script>");
return;
}
}
}
protected void btnImportData_Click(object sender, EventArgs e)
{
if (gvDownExcel.Rows.Count <= 0)
{
this.textLabel.Text = "<script>alert('并没有数据可供上传！');</script>";
//Response.Write("<script language='javascript'>alert('并没有数据可供上传！');</script>");
return;
}
Common.Model.UserInfo userInfoData = new Common.Model.UserInfo();
for (int i = 0; i < gvDownExcel.Rows.Count; i++)
{
if (gvDownExcel.Rows[i].Cells[2].Text != " ")
{
DataRow row = userInfoData.Tables[Common.Model.UserInfo.TABLE_CUSTOMER_INFO].NewRow();
if (gvDownExcel.Rows[i].Cells[0].Text != " ")
row[Common.Model.UserInfo.COLUMNS_TYPE_ID] = gvDownExcel.Rows[i].Cells[0].Text;
else
row[Common.Model.UserInfo.COLUMNS_TYPE_ID] = "";
if (gvDownExcel.Rows[i].Cells[1].Text != " ")
row[Common.Model.UserInfo.COLUMNS_GROUP_ID] = gvDownExcel.Rows[i].Cells[1].Text;
else
row[Common.Model.UserInfo.COLUMNS_GROUP_ID] = "";
if (gvDownExcel.Rows[i].Cells[2].Text != " ")
row[Common.Model.UserInfo.COLUMNS_CUSTOMERMOBILE] = gvDownExcel.Rows[i].Cells[2].Text;
else
row[Common.Model.UserInfo.COLUMNS_CUSTOMERMOBILE] = "";
if (gvDownExcel.Rows[i].Cells[3].Text != " ")
row[Common.Model.UserInfo.COLUMNS_CUSTOMERTRADE_ID] = gvDownExcel.Rows[i].Cells[3].Text;
else
row[Common.Model.UserInfo.COLUMNS_CUSTOMERTRADE_ID] = "";
//if (gvDownExcel.Rows[i].Cells[11].Text != " ")
// row[Common.Model.UserInfo.COLUMNS_USER_DEFINE_ID] = gvDownExcel.Rows[i].Cells[11].Text;
//else
// row[Common.Model.UserInfo.COLUMNS_USER_DEFINE_ID] = "";
if (gvDownExcel.Rows[i].Cells[4].Text != " ")
row[Common.Model.UserInfo.COLUMNS_CUSTOMERNAME] = gvDownExcel.Rows[i].Cells[4].Text;
else
row[Common.Model.UserInfo.COLUMNS_CUSTOMERNAME] = "";
if (gvDownExcel.Rows[i].Cells[5].Text != " ")
row[Common.Model.UserInfo.COLUMNS_CUSTOMERBIRTHDAY] = gvDownExcel.Rows[i].Cells[5].Text;
else
row[Common.Model.UserInfo.COLUMNS_CUSTOMERBIRTHDAY] = "";
if (gvDownExcel.Rows[i].Cells[6].Text != " ")
row[Common.Model.UserInfo.COLUMNS_CUSTOMERDUTY] = gvDownExcel.Rows[i].Cells[6].Text;
else
row[Common.Model.UserInfo.COLUMNS_CUSTOMERDUTY] = "";
//if (gvDownExcel.Rows[i].Cells[5].Text != " ")
// row[Common.Model.UserInfo.COLUMNS_SPECIALITY] = gvDownExcel.Rows[i].Cells[7].Text;
//else
// row[Common.Model.UserInfo.COLUMNS_SPECIALITY] = "";
if (gvDownExcel.Rows[i].Cells[7].Text != " ")
row[Common.Model.UserInfo.COLUMNS_CUSTOMERHOMEADDRESS] = gvDownExcel.Rows[i].Cells[7].Text;
else
row[Common.Model.UserInfo.COLUMNS_CUSTOMERHOMEADDRESS] = "";
string sex = gvDownExcel.Rows[i].Cells[8].Text;
if (sex =="1" || sex == "0")
{
row[Common.Model.UserInfo.COLUMNS_SEX] = sex;
}
else
{
row[Common.Model.UserInfo.COLUMNS_SEX] = 2;
}
if (gvDownExcel.Rows[i].Cells[9].Text != " ")
row[Common.Model.UserInfo.COLUMNS_CUSTOMER_DEFINE_ID] = gvDownExcel.Rows[i].Cells[9].Text;
else
row[Common.Model.UserInfo.COLUMNS_CUSTOMER_DEFINE_ID] = "";
if (gvDownExcel.Rows[i].Cells[10].Text != " ")
row[Common.Model.UserInfo.COLUMNS_CUSTOMERIDCARD] = gvDownExcel.Rows[i].Cells[10].Text;
else
row[Common.Model.UserInfo.COLUMNS_CUSTOMERIDCARD] = "";
if (gvDownExcel.Rows[i].Cells[11].Text != " ")
row[Common.Model.UserInfo.COLUMNS_UNIT] = gvDownExcel.Rows[i].Cells[11].Text;
else
row[Common.Model.UserInfo.COLUMNS_UNIT] = "";
if (gvDownExcel.Rows[i].Cells[12].Text != " ")
row[Common.Model.UserInfo.COLUMNS_UNITADDRESS] = gvDownExcel.Rows[i].Cells[12].Text;
else
row[Common.Model.UserInfo.COLUMNS_UNITADDRESS] = "";
if (gvDownExcel.Rows[i].Cells[13].Text != " ")
row[Common.Model.UserInfo.COLUMNS_JOINDATE] = gvDownExcel.Rows[i].Cells[13].Text;
else
row[Common.Model.UserInfo.COLUMNS_JOINDATE] = "";
if (gvDownExcel.Rows[i].Cells[14].Text != " ")
row[Common.Model.UserInfo.COLUMNS_CUSTOMER_BEIZHU] = gvDownExcel.Rows[i].Cells[14].Text;
else
row[Common.Model.UserInfo.COLUMNS_CUSTOMER_BEIZHU] = "";
//if (gvDownExcel.Rows[i].Cells[15].Text != " ")
// row[Common.Model.UserInfo.COLUMNS_JIGUAN] = gvDownExcel.Rows[i].Cells[15].Text;
//else
// row[Common.Model.UserInfo.COLUMNS_JIGUAN] = "";
//if (gvDownExcel.Rows[i].Cells[16].Text != " ")
// row[Common.Model.UserInfo.COLUMNS_JOINTIME] = gvDownExcel.Rows[i].Cells[16].Text;
//else
// row[Common.Model.UserInfo.COLUMNS_JOINTIME] = "";
//if (gvDownExcel.Rows[i].Cells[17].Text != " ")
// row[Common.Model.UserInfo.COLUMNS_IDCARD] = gvDownExcel.Rows[i].Cells[17].Text;
//else
// row[Common.Model.UserInfo.COLUMNS_IDCARD] = "";
//if (gvDownExcel.Rows[i].Cells[17].Text != " ")
// row[Common.Model.UserInfo.COLUMNS_NOWADDRESS] = gvDownExcel.Rows[i].Cells[17].Text;
//else
// row[Common.Model.UserInfo.COLUMNS_NOWADDRESS] = "";
//if (gvDownExcel.Rows[i].Cells[18].Text != " ")
// row[Common.Model.UserInfo.COLUMNS_BEIZHU] = gvDownExcel.Rows[i].Cells[18].Text;
//else
// row[Common.Model.UserInfo.COLUMNS_BEIZHU] = "";
//if (gvDownExcel.Rows[i].Cells[19].Text != " ")
// row[Common.Model.UserInfo.COLUMNS_IDCARD] = gvDownExcel.Rows[i].Cells[19].Text;
//else
// row[Common.Model.UserInfo.COLUMNS_IDCARD] = "";
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?