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.UserID = Id;
model.LoginName = bp.LoginName.Trim();
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 = Convert.ToInt32(this.radioaudit.SelectedValue);
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.Mobile = txtMoblie.Text.Trim();
model.phone = txtTelCountry.Value + "-" + txtTelZoneCode.Value + "-" + txtTelNumber.Value;
model.typeID = Convert.ToInt32(this.ddrleixing.SelectedValue);
model.groupID = Convert.ToInt32(this.ddrzu.SelectedValue);
model.remark = txtDescript.Text.Trim();
int result = mailinfobll.Update(model);
if (result > 0)
{
Response.Redirect("MailSupervise.aspx");
}
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();
}
private void BindShow()
{
Tz888.Model.Mail.MailInfo model = mailinfobll.GetModel(Id);
this.ddrcity.Visible = false;
this.ddrprovice.DataSource = provincebll.GetModelList();
this.ddrprovice.DataValueField = "Id";
this.ddrprovice.DataTextField = "Name";
this.ddrprovice.DataBind();
// ddrprovice.Items.FindByValue(model.ProvinceId.ToString().Trim()).Selected = true;
ddrprovice.SelectedValue = model.ProvinceId.ToString().Trim();
this.ddrxingye.DataSource = industrybll.GetModelList();
this.ddrxingye.DataValueField = "Id";
this.ddrxingye.DataTextField = "Name";
this.ddrxingye.DataBind();
ListItem items = new ListItem();
items.Value = "-1";
items.Text = "所有行业";
ddrxingye.Items.Add(items);
// ddrxingye.Items.FindByValue(model.industry.ToString().Trim()).Selected = true;
ddrxingye.SelectedValue = model.industry.ToString().Trim();
this.ddrzhiwei.DataSource = positionbll.GetModelList();
this.ddrzhiwei.DataValueField = "Id";
this.ddrzhiwei.DataTextField = "Name";
this.ddrzhiwei.DataBind();
// ddrzhiwei.Items.FindByValue(model.PositionId.ToString().Trim()).Selected = true;
ddrzhiwei.SelectedValue = model.PositionId.ToString().Trim();
this.ddrzu.DataSource = mialgroupbll.GetModelList();
this.ddrzu.DataValueField = "groupID";
this.ddrzu.DataTextField = "groupname";
this.ddrzu.DataBind();
// ddrzu.Items.FindByValue(model.groupID.ToString().Trim()).Selected = true;
ddrzu.SelectedValue = model.groupID.ToString().Trim();
this.ddrleixing.DataSource = mailtypebll.GetModelList();
this.ddrleixing.DataValueField = "typeID";
this.ddrleixing.DataTextField = "TypeName";
this.ddrleixing.DataBind();
// ddrleixing.Items.FindByValue(model.typeID.ToString().Trim()).Selected = true;
ddrleixing.SelectedValue = model.typeID.ToString().Trim();
List <Tz888.Model.Mail.City> list = citybll.GetModelList(Convert.ToInt32(this.ddrprovice.SelectedValue));
if (list.Count > 0)
{
this.ddrcity.Visible = true;
this.ddrcity.DataSource = list;
this.ddrcity.DataValueField = "Id";
this.ddrcity.DataTextField = "Name";
this.ddrcity.DataBind();
if (Convert.ToInt32(model.CityId.ToString()) > 0)
{
// ddrcity.Items.FindByValue(model.CityId.ToString().Trim()).Selected = true;
ddrcity.SelectedValue = model.CityId.ToString().Trim();
}
else
{
this.ddrcity.Visible = false;
}
}
else
{
this.ddrcity.Visible = false;
}
txtUserName.Text = model.UserName;
txtPanyName.Text = model.PanyName;
txtAddress.Text = model.Address;
txtLinkUrl.Text = model.LinkUrl;
txtMail.Text = model.Mial;
txtMoblie.Text = model.Mobile;
string Phone = model.phone;
if (Phone.Split('-').Length < 3)
{
txtTelNumber.Value = Phone;
}
else
{
txtTelCountry.Value = (Phone.Split('-')[0] == null) ? "" : Phone.Split('-')[0];
txtTelZoneCode.Value = (Phone.Split('-')[1] == null) ? "" : Phone.Split('-')[1];
txtTelNumber.Value = (Phone.Split('-')[2] == null) ? "" : Phone.Split('-')[2];
}
txtDescript.Text = model.remark;
// this.radioaudit.Items.FindByValue(model.audit.ToString().Trim()).Selected = true;
radioaudit.SelectedValue = model.audit.ToString().Trim();
}
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("MailInfoManage.aspx");
}
else
{
Response.Write("<script>alert('录入失败！')</script>");
}
}
