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 btnSave_Click(object sender, EventArgs e) { if (txtUserName.Text.Trim() == "") { Response.Write("<script>alert('请输入用户名!')</script>"); return; } if (txtPanyName.Text.Trim() == "") { Response.Write("<script>alert('请输入公司名!')</script>"); return; } //if (txtMail.Text.Trim() == "") //{ // Response.Write("<script>alert('请输入邮件!')</script>"); // return; //} //if (txtUserName.Text.Trim() == "") //{ // Response.Write("<script>alert('请输入手机!')</script>"); // return; //} Tz888.Model.Mail.MailInfo model = new Tz888.Model.Mail.MailInfo(); model.LoginName = bp.LoginName; model.UserName = txtUserName.Text.Trim(); model.PanyName = txtPanyName.Text.Trim(); model.PositionId = Convert.ToInt32(this.ddrzhiwei.SelectedValue); model.Address = txtAddress.Text.Trim(); model.LinkUrl = txtLinkUrl.Text.Trim(); model.audit = 1; model.ProvinceId = Convert.ToInt32(this.ddrprovice.SelectedValue); if (this.ddrcity.Visible == true) { model.CityId = Convert.ToInt32(this.ddrcity.SelectedValue); } else { model.CityId = 0;//省级下没有市的话默认为:0 } model.industry = Convert.ToInt32(this.ddrxingye.SelectedValue); model.Mial = txtMail.Text.Trim(); model.phone = txtTelCountry.Value.Trim() + "-" + txtTelZoneCode.Value.Trim() + "-" + txtTelNumber.Value.Trim(); model.Mobile = txtMoblie.Text.Trim(); model.typeID = Convert.ToInt32(this.ddrleixing.SelectedValue); model.groupID = Convert.ToInt32(this.ddrzu.SelectedValue); model.remark = txtDescript.Text.Trim(); model.Mdatetime = DateTime.Now.ToShortDateString() + " " + DateTime.Now.ToLongTimeString().Trim(); int result = 0; try { result = mailinfobll.Add(model); } catch (Exception ex) { throw new Exception(ex.Message); } if (result > 0) { Response.Redirect("MailSupervise.aspx"); } else { Response.Write("<script>alert('录入失败!')</script>"); } }