public string Getdiyu(int priovid, int cityid)
{
string par = "";
Tz888.Model.Mail.Province modelp = provincebll.GetModel(priovid);
Tz888.Model.Mail.City modelc = citybll.GetModel(cityid);
if (modelc != null)
{
par = modelp.Name + ": " + modelc.Name;
}
else
{
par = modelp.Name;
}
return(par);
}
protected void btnSave_Click(object sender, EventArgs e)
{
Tz888.BLL.Mail.ProvinceBLL bll = new Tz888.BLL.Mail.ProvinceBLL();
Tz888.Model.Mail.Province model = new Tz888.Model.Mail.Province();
if (txtName.Text.Trim() == "")
{
Response.Write("<script>alert('请输入省级名称！')</script>");
return;
}
model.Name = txtName.Text.Trim();
int result = bll.Add(model);
if (result > 0)
{
Response.Write("<script>alert('录入成功！')</script>");
}
else
{
Response.Write("<script>alert('已经存在该省！')</script>");
}
}
protected void btndaoru_Click(object sender, EventArgs e)
{
saveBPath = ConfigurationManager.AppSettings["upexcle"].ToString() + "MailInfo.xls";
if (count == 1)
{
DataTable BdtExcel = ExcelToDataTable(saveBPath, "Sheet1");
if (BdtExcel != null)
{
foreach (DataRow row in BdtExcel.Rows)
{
string zhanghao = row["账号"].ToString();
string UserNames = row["名称"].ToString();
string panyname = row["公司名称"].ToString();
string dizhi = row["地址"].ToString();
string wangzhi = row["网址"].ToString();
string zhiwei = row["职位"].ToString();
string type = row["类型"].ToString();
string diyu = row["地域"].ToString();
string xingye = row["行业"].ToString();
string statu = row["状态"].ToString();
string Mail = row["邮件"].ToString();
string shouji = row["手机"].ToString();
string zu = row["组"].ToString();
string beizhu = row["备注"].ToString();
string sd = row["时间"].ToString();
string sdasd = row["操作"].ToString();
Tz888.Model.Mail.Industry modelI = industrybll.GetModelByName(xingye);
Tz888.Model.Mail.MailInfo model = new Tz888.Model.Mail.MailInfo();
string[] diyulist = diyu.Split(':');
if (diyulist.Length > 1)
{
Tz888.Model.Mail.Province modelp = provincebll.GetModelByName(diyulist[0].ToString().Trim());
Tz888.Model.Mail.City modelc = citybll.GetModelByName(diyulist[1].ToString().Trim());
model.ProvinceId = Convert.ToInt32(modelp.Id);
model.CityId = Convert.ToInt32(modelc.Id);
}
else
{
Tz888.Model.Mail.Province modelps = provincebll.GetModelByName(diyu.Trim());
model.ProvinceId = Convert.ToInt32(modelps.Id);
model.CityId = 0;
}
model.LoginName = zhanghao;
model.UserName = UserNames.Trim();
Tz888.Model.Mail.MailType modeltype = mailtypebll.GetModelByTypeName(type);
model.PanyName = panyname.Trim();
model.PositionId = Convert.ToInt32(positionbll.GetModelByName(zhiwei.Trim()).Id);
model.Address = dizhi.Trim();
model.LinkUrl = wangzhi.Trim();
if (statu.Trim() == "未审核")
{
model.audit = 0;
}
else
{
model.audit = 1;
}
if (xingye.Trim() != "所有行业")
{
model.industry = Convert.ToInt32(industrybll.GetModelByName(xingye.Trim()).Id);
}
else
{
model.industry = -1;
}
model.Mial = Mail.Trim();
model.Mobile = shouji.Trim();
model.typeID = Convert.ToInt32(modeltype.typeID);
model.groupID = Convert.ToInt32(mialgroupbll.GetModelByName(zu.Trim()).groupID);
model.remark = beizhu.Trim();
model.Mdatetime = sd;
int result = mailinfobll.Add(model);
}
}
else
{
Response.Write("<script>alert('请上传的Excel表格！');</script>");
}
}
else
{
Response.Write("<script>alert('请上传的Excel表格！');</script>");
}
BindShow();
}
protected void btnDaoChu_Click(object sender, EventArgs e)
{
List <Tz888.Model.Mail.MailInfo> list = mailinfobll.GetModelList(par);
dt.Rows.Clear();
foreach (Tz888.Model.Mail.MailInfo model in list)
{
DataRow dr = dt.NewRow();
//单位名称 联系人 手机 电话 邮箱 类型 职位
// dr["编号"] = model .UserID;
//dr["账号"] = model.LoginName;
dr["名称"] = model.UserName;
dr["公司名称"] = model.PanyName;
Tz888.Model.Mail.Position modelpo = positionbll.GetModel(Convert.ToInt32(model.PositionId));
if (modelpo != null)
{
dr["职位"] = modelpo.Name;
//dr["地址"] = model.Address;
//dr["网址"] = model.LinkUrl;
Tz888.Model.Mail.MailType modeltype = mailtypebll.GetModel(Convert.ToInt32(model.typeID));
string type = modeltype.TypeName.Trim();
dr["类型"] = type;
string diyu = "";
Tz888.Model.Mail.Province modelp = provincebll.GetModel(Convert.ToInt32(model.ProvinceId));
Tz888.Model.Mail.City modelc = citybll.GetModel(Convert.ToInt32(model.CityId));
if (modelc != null)
{
diyu = modelp.Name + ": " + modelc.Name;
}
else
{
diyu = modelp.Name;
}
// dr["地域"] = diyu;
if (Convert.ToInt32(model.industry) != -1)
{
Tz888.Model.Mail.Industry modelIndustry = industrybll.GetModel(Convert.ToInt32(model.industry));
string xingye = modelIndustry.Name.Trim();
// dr["行业"] = xingye;
}
else //dr["行业"] = "所有行业";
{
}
// string statue = "";
// if (model.audit == 0)
//{
// statue = "未审核";
//}
//else { statue = "已审核"; }
//dr["状态"] = statue;
dr["邮件"] = model.Mial;
dr["手机"] = model.Mobile;
Tz888.Model.Mail.Mialgroup modelpr = mialgroupbll.GetModel(Convert.ToInt32(model.groupID));
// dr["组"] = modelpr.groupname;
// dr["备注"] = model.remark;
//dr["时间"] = model.Mdatetime;
//dr["操作"] = "";
dt.Rows.Add(dr);
}
}
HSSFWorkbook hssfworkbook = new HSSFWorkbook();
DocumentSummaryInformation dsi = PropertySetFactory.CreateDocumentSummaryInformation();
dsi.Company = "深圳拓富投资有限公司";
SummaryInformation si = PropertySetFactory.CreateSummaryInformation();
si.Subject = "邮件用户管理";
si.Author = "颜品庄";
si.CreateDateTime = DateTime.Now;
hssfworkbook.DocumentSummaryInformation = dsi;
hssfworkbook.SummaryInformation = si;
HSSFSheet sheet1 = hssfworkbook.CreateSheet("Sheet1");
//sheet1.DefaultColumnWidth=10;设置列宽
HSSFRow row = sheet1.CreateRow(0);
// row.CreateCell(0).SetCellValue("编号");
// row.CreateCell(1).SetCellValue("账号");
row.CreateCell(0).SetCellValue("名称");
row.CreateCell(1).SetCellValue("公司名称");
row.CreateCell(2).SetCellValue("职位");
// row.CreateCell(5).SetCellValue("地址");
// row.CreateCell(6).SetCellValue("网址");
row.CreateCell(3).SetCellValue("类型");
// row.CreateCell(8).SetCellValue("地域");
// row.CreateCell(9).SetCellValue("行业");
// row.CreateCell(10).SetCellValue("状态");
row.CreateCell(4).SetCellValue("邮件");
row.CreateCell(5).SetCellValue("手机");
// row.CreateCell(13).SetCellValue("组");
// row.CreateCell(14).SetCellValue("备注");
//row.CreateCell(6).SetCellValue("时间");
// row.CreateCell(16).SetCellValue("操作");
for (int i = 0; i < dt.Rows.Count; i++)
{
HSSFRow row0 = sheet1.CreateRow(i + 1);
// row0.CreateCell(0).SetCellValue(dt.Rows[i]["编号"].ToString());
// row0.CreateCell(1).SetCellValue(dt.Rows[i]["账号"].ToString());
row0.CreateCell(0).SetCellValue(dt.Rows[i]["名称"].ToString());
row0.CreateCell(1).SetCellValue(dt.Rows[i]["公司名称"].ToString());
row0.CreateCell(2).SetCellValue(dt.Rows[i]["职位"].ToString());
//row0.CreateCell(5).SetCellValue(dt.Rows[i]["地址"].ToString());
//row0.CreateCell(6).SetCellValue(dt.Rows[i]["网址"].ToString());
row0.CreateCell(3).SetCellValue(dt.Rows[i]["类型"].ToString());
//row0.CreateCell(8).SetCellValue(dt.Rows[i]["地域"].ToString());
//row0.CreateCell(9).SetCellValue(dt.Rows[i]["行业"].ToString());
//row0.CreateCell(10).SetCellValue(dt.Rows[i]["状态"].ToString());
row0.CreateCell(4).SetCellValue(dt.Rows[i]["邮件"].ToString());
row0.CreateCell(5).SetCellValue(dt.Rows[i]["手机"].ToString());
//row0.CreateCell(13).SetCellValue(dt.Rows[i]["组"].ToString());
//row0.CreateCell(14).SetCellValue(dt.Rows[i]["备注"].ToString());
//row0.CreateCell(15).SetCellValue(dt.Rows[i]["时间"].ToString());
// row0.CreateCell(6).SetCellValue(dt.Rows[i]["操作"].ToString());
}
string t1 = DateTime.Now.Year.ToString() + DateTime.Now.Month.ToString() + DateTime.Now.Day.ToString() + DateTime.Now.Hour.ToString() + DateTime.Now.Minute.ToString();
string filename = "attachment;filename=" + System.Web.HttpUtility.UrlEncode("邮件用户表" + t1, System.Text.Encoding.UTF8) + ".xls";
Response.ContentType = "application/vnd.ms-excel";
//Response.AddHeader("Content-Disposition", string.Format("attachment;filename={0}", filename));
Response.AppendHeader("Content-Disposition", filename);
Response.Clear();
//Write the stream data of workbook to the root directory
MemoryStream filestream = new MemoryStream();
hssfworkbook.Write(filestream);
Response.BinaryWrite(filestream.GetBuffer());
Response.End();
}