protected void databindList(int ProfessionalID)
{
ProfessionalPlease plModel = plBll.GetModel(ProfessionalID);
ProfessionalLink linkModel = linkBll.GetModel(ProfessionalID);
ProfessionalinfoTab inModel = infoBll.GetModel(ProfessionalID);
txtTitle.Text = inModel.Titel.ToString();
this.ZoneSelectControl1.CountryID = plModel.CountryCode;
this.ZoneSelectControl1.ProvinceID = plModel.ProvinceID;
this.ZoneSelectControl1.CityID = plModel.CityID;
this.ZoneSelectControl1.CountyID = plModel.CountyID;
txtBusinesDetails.Text = plModel.description;
txtRegistYear.Text = plModel.companydate.ToString("yyyy-MM-dd");
ddlServiceType.SelectedValue = plModel.servicetypeID.ToString(); //服务类型
DropIndustry.SelectedValue = plModel.institutionsID.ToString(); //机构类别
txtEmployeeCount.Value = plModel.Enterprisesize; //企业规模
txtRegistMoeny.Value = plModel.funds; //注册资金
txtTurnover.Value = plModel.turnover; //营业额
rdlValiditeTerm.SelectedValue = plModel.validityID.ToString(); //有效期
txtAddress.Text = linkModel.Address;
txtLinkMan.Value = linkModel.UserName;
txtPhone.Text = linkModel.phone;
txtCompanyName.Value = linkModel.CompanyName;
txtEmail.Value = linkModel.Email;
txtLinkFax.Value = linkModel.Fax;
txtLinkTel.Value = linkModel.Tel;
txtWebSite.Value = linkModel.Site;
}
public ProfessionalLink GetModel(int Lid)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 Lid,ProfessionalID,UserName,CompanyName,Address,Tel,phone,Fax,Email,Site from ProfessionalLink ");
strSql.Append(" where ProfessionalID=@Lid");
SqlParameter[] parameters =
{
new SqlParameter("@Lid", SqlDbType.Int, 4)
};
parameters[0].Value = Lid;
ProfessionalLink model = new ProfessionalLink();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["Lid"].ToString() != "")
{
model.Lid = int.Parse(ds.Tables[0].Rows[0]["Lid"].ToString());
}
if (ds.Tables[0].Rows[0]["ProfessionalID"].ToString() != "")
{
model.ProfessionalID = int.Parse(ds.Tables[0].Rows[0]["ProfessionalID"].ToString());
}
model.UserName = ds.Tables[0].Rows[0]["UserName"].ToString();
model.CompanyName = ds.Tables[0].Rows[0]["CompanyName"].ToString();
model.Address = ds.Tables[0].Rows[0]["Address"].ToString();
model.Tel = ds.Tables[0].Rows[0]["Tel"].ToString();
model.phone = ds.Tables[0].Rows[0]["phone"].ToString();
model.Fax = ds.Tables[0].Rows[0]["Fax"].ToString();
model.Email = ds.Tables[0].Rows[0]["Email"].ToString();
model.Site = ds.Tables[0].Rows[0]["Site"].ToString();
return(model);
}
else
{
return(null);
}
}
//审核
protected void btnSubmit_Click(object sender, EventArgs e)
{
ProfessionalinfoTab MainInfo = new ProfessionalinfoTab();
Professionalview viewInfo = new Professionalview();
ProfessionalLink personInfo = new ProfessionalLink();
if (!string.IsNullOrEmpty(Request.QueryString["ProfessionalID"]))
{
int ProfessionalID = int.Parse(Request.QueryString["ProfessionalID"].ToString());
MainInfo.ProfessionalID = ProfessionalID;
MainInfo = infoBll.GetModel(ProfessionalID);
}
MainInfo.Titel = txtTitle.Text.Trim();
//0未审核 1审核通过2审核未通过
if (rdPass.Checked)
{
MainInfo.auditId = 1;
}
else if (rdAudit.Checked)
{
MainInfo.auditId = 0;
}
else if (rdNopass.Checked)
{
MainInfo.auditId = 2;
}
else
{
MainInfo.auditId = 4;
}
//是否收费 0 免费 1收费
if (rdomian.Checked)
{
MainInfo.chargeId = 0;
}
else
{
MainInfo.chargeId = 1;
}
//来源 1 会员中心 2 业务员
//MainInfo.FromId = int.Parse(ddlFrom.SelectedValue.ToString());
//类型 1 需要服务2提供专业 3专业人才
//if (rdoService.Checked) { MainInfo.typeID = 1; } else if (rdoPress.Checked) { MainInfo.typeID = 2; } else { MainInfo.typeID = 3; }
//状态 0无效 1有效 2已过期
if (rdoNoEnable.Checked)
{
MainInfo.stateId = 0;
}
else if (rdoYesEnable.Checked)
{
MainInfo.stateId = 1;
}
else
{
MainInfo.stateId = 2;
}
//是否推荐 不推荐 0 推荐 1
if (rdoYesAct.Checked)
{
MainInfo.recommendId = 1;
}
else
{
MainInfo.recommendId = 0;
}
MainInfo.price = Convert.ToDecimal(txtPrice.Text.ToString());
MainInfo.refreshTime = Convert.ToDateTime(txtReTime.Text.Trim().ToString());
MainInfo.FeedBackNote = tbAuditingRemark.Text.Trim();
MainInfo.clickId = int.Parse(txtClick.Text.Trim().ToString());
MainInfo.Titel = txtTitle.Text.Trim();
MainInfo.htmlUrl = "dservice/" + DateTime.Now.ToString("yyyyMM") + "/dservice" + DateTime.Now.ToString("yyyyMMdd") + "_" + Request.QueryString["ProfessionalID"].ToString() + ".shtml";
viewInfo.CountryCode = this.ZoneSelectControl1.CountryID;
viewInfo.ProvinceID = this.ZoneSelectControl1.ProvinceID;
viewInfo.CityID = this.ZoneSelectControl1.CityID;
viewInfo.CountyID = this.ZoneSelectControl1.CountyID;
viewInfo.description = txtContent.Text.Trim();
viewInfo.title = txtWtitle.Text.Trim();
viewInfo.keywords = txtKeyword1.Text.Trim();
viewInfo.Webdescription = txtWebDesr.Text.Trim();
viewInfo.validityID = int.Parse(rdlValiditeTerm.SelectedValue.ToString());
viewInfo.typeID = int.Parse(ddlServiceType.SelectedValue.ToString());
personInfo.Address = txtAddress.Text.Trim();
personInfo.CompanyName = txtCompany.Text.Trim();
personInfo.Email = txtEmail.Text.Trim();
personInfo.Fax = txtFax.Text.Trim();
personInfo.phone = txtPhone.Text.Trim();
string tel = string.Empty;
if (!string.IsNullOrEmpty(txtcontactsTel.Text.Trim()))
{
tel = txtcontactsTel.Text.Trim() + ",";
}
else
{
tel = ",";
}
if (!string.IsNullOrEmpty(txtTel.Text.Trim()))
{
tel += txtTel.Text.Trim() + ",";
}
else
{
tel += ",";
}
if (!string.IsNullOrEmpty(txttel2.Text.Trim()))
{
tel += txttel2.Text.Trim() + ",";
}
else
{
tel += ",";
}
personInfo.Tel = tel;
personInfo.UserName = txtLinkMan.Text.Trim();
personInfo.Site = txtSite.Text.Trim();
if (viewbll.UpdateProFessionlView(MainInfo, viewInfo, personInfo))
{
if (rdPass.Checked)
{
Tz888.BLL.ProfessionalManage.PageStatic stat = new PageStatic();
int result = stat.StaticHtml(int.Parse(Request.QueryString["ProfessionalID"].ToString()));
if (result <= 0)
{
Tz888.Common.MessageBox.Show(this.Page, "生成静态页面失败");
}
}
Response.Write("<script>alert('审核成功！');document.location='ProfessionalManage.aspx'</script>");
}
else
{
Tz888.Common.MessageBox.Show(this.Page, "审核失败！");
}
}
//申请
protected void btnSubmit_Click(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(this.txtTitle.Text))
{
Tz888.Common.MessageBox.Show(this.Page, "请填写标题!");
return;
}
if (string.IsNullOrEmpty(this.ddlServiceType.SelectedValue))
{
Tz888.Common.MessageBox.Show(this.Page, "请选择服务大类！");
return;
}
//if (string.IsNullOrEmpty(this.slServerMDrop.SelectedValue))
//{
// Tz888.Common.MessageBox.Show(this.Page, "请选择服务小类！");
// return;
//}
if (string.IsNullOrEmpty(this.txtContent.Text))
{
Tz888.Common.MessageBox.Show(this.Page, "请填写说明!");
return;
}
if (string.IsNullOrEmpty(this.txtLinkMan.Text))
{
Tz888.Common.MessageBox.Show(this.Page, "请填写申请人!");
return;
}
if (string.IsNullOrEmpty(this.txtCompany.Text))
{
Tz888.Common.MessageBox.Show(this.Page, "请填写单位名称!");
return;
}
//if (string.IsNullOrEmpty(this.txtTel.Text))
//{
// Tz888.Common.MessageBox.Show(this.Page, "请填写联系电话!");
// return;
//}
if (txtTel.Text.Trim() == "" && txtPhone.Text.Trim() == "")
{
Tz888.Common.MessageBox.Show(this.Page, "联系人电话和手机至少填一个！");
return;
}
else
{
if (txtTel.Text.Trim() != "")
{
if (!PageValidate.IsNumber(txtTel.Text.Trim()))
{
Tz888.Common.MessageBox.Show(this.Page, "联系人电话格式错误！");
return;
}
}
}
//if (string.IsNullOrEmpty(this.txtFax.Text))
//{
// Tz888.Common.MessageBox.Show(this.Page, "请填写传真号码!");
// return;
//}
if (txtEmail.Text.Trim() == "")
{
Tz888.Common.MessageBox.Show(this.Page, "Email不能为空！！");
return;
}
if (txtEmail.Text.Trim() != "")
{
if (!PageValidate.IsEmail(txtEmail.Text.ToLower().Trim()))
{
Tz888.Common.MessageBox.Show(this.Page, "Email地址格式错误！");
return;
}
}
ProfessionalinfoTab MainInfo = new ProfessionalinfoTab();
Professionalview viewInfo = new Professionalview();
ProfessionalLink personInfo = new ProfessionalLink();
MainInfo.LoginName = Page.User.Identity.Name;
MainInfo.Titel = txtTitle.Text.Trim();
MainInfo.typeID = 1;
//MainInfo.auditId = 0; MainInfo.stateId = 0; MainInfo.chargeId = 0;MainInfo.clickId = 0;
//MainInfo.creatgeDate = Convert.ToDateTime(DateTime.Now.ToString());MainInfo.refreshTime=
MainInfo.htmlUrl = "";
MainInfo.FromId = 1;
MainInfo.recommendId = 0;
MainInfo.price = 0; //Convert.ToDecimal(txtPrice.Text.Trim());
viewInfo.CountryCode = this.ZoneSelectControl1.CountryID;
viewInfo.ProvinceID = this.ZoneSelectControl1.ProvinceID;
viewInfo.CityID = this.ZoneSelectControl1.CityID;
viewInfo.CountyID = this.ZoneSelectControl1.CountyID;
viewInfo.description = txtContent.Text.Trim();
viewInfo.title = ""; //txtTitle.Text.Trim();
viewInfo.keywords = ""; //txtKeyword1.Text.Trim();
viewInfo.Webdescription = ""; //txtWebDesr.Text.Trim();
viewInfo.validityID = int.Parse(rdlValiditeTerm.SelectedValue.ToString());
viewInfo.typeID = int.Parse(ddlServiceType.SelectedValue.ToString());
personInfo.Address = txtAddress.Text.Trim();
personInfo.CompanyName = txtCompany.Text.Trim();
personInfo.Email = txtEmail.Text.Trim();
personInfo.Fax = txtFax.Text.Trim();
personInfo.phone = txtPhone.Text.Trim();
string tel = string.Empty;
if (!string.IsNullOrEmpty(txtcontactsTel.Text.Trim()))
{
tel = txtcontactsTel.Text.Trim() + ",";
}
else
{
tel = ",";
}
if (!string.IsNullOrEmpty(txtTel.Text.Trim()))
{
tel += txtTel.Text.Trim() + ",";
}
else
{
tel += ",";
}
if (!string.IsNullOrEmpty(txttel2.Text.Trim()))
{
tel += txttel2.Text.Trim() + ",";
}
else
{
tel += ",";
}
personInfo.Tel = tel;
personInfo.UserName = txtLinkMan.Text.Trim();//之前没改过来
personInfo.Site = txtSite.Text.Trim();
personInfo.phone = txtPhone.Text.Trim();
if (viewbll.InsertProFessionlView(MainInfo, viewInfo, personInfo))
{
Response.Write("<script>alert('发布成功！');document.location='ServiesManage.aspx'</script>");
}
else
{
Tz888.Common.MessageBox.Show(this.Page, "发布失败！");
}
}
/// <summary>
/// 修改一条专业服务数据
/// </summary>
/// <returns></returns>
public bool UpdateProFessionlView(ProfessionalinfoTab mainInfo, Professionalview viewInfo, ProfessionalLink link)
{
return(dal.UpdateProFessionlView(mainInfo, viewInfo, link));
}
protected void databindList(int ProfessionalID)
{
ProfessionalPlease plModel = plBll.GetModel(ProfessionalID);
ProfessionalLink linkModel = linkBll.GetModel(ProfessionalID);
ProfessionalinfoTab inModel = infoBll.GetModel(ProfessionalID);
txtTitle.Text = inModel.Titel.ToString();
txtPrice.Text = inModel.price.ToString();
tbAuditingRemark.Text = inModel.FeedBackNote;
this.ZoneSelectControl1.CountryID = plModel.CountryCode;
this.ZoneSelectControl1.ProvinceID = plModel.ProvinceID;
this.ZoneSelectControl1.CityID = plModel.CityID;
this.ZoneSelectControl1.CountyID = plModel.CountyID;
txtContent.Text = plModel.description;
txtRegistYear.Text = plModel.companydate.ToString("yyyy-MM-dd");
ddlServiceType.SelectedValue = plModel.servicetypeID.ToString(); //服务类型
DropIndustry.SelectedValue = plModel.institutionsID.ToString(); //机构类别
txtEmployeeCount.Value = plModel.Enterprisesize; //企业规模
txtRegistMoeny.Value = plModel.funds; //注册资金
txtTurnover.Value = plModel.turnover; //营业额
rdlValiditeTerm.SelectedValue = plModel.validityID.ToString(); //有效期
txtAddress.Text = linkModel.Address;
txtLinkMan.Text = linkModel.UserName;
txtPhone.Text = linkModel.phone;
txtCompany.Text = linkModel.CompanyName;
txtClick.Text = inModel.clickId.ToString();
txtEmail.Text = linkModel.Email;
txtFax.Text = linkModel.Fax;
string tel = linkModel.Tel;
string[] telLen = tel.Split(new char[] { ',' });
if (telLen.Length == 1)
{
txtTel.Text = linkModel.Tel;
}
else
{
txtcontactsTel.Text = telLen[0].ToString();
txtTel.Text = telLen[1].ToString();
txttel2.Text = telLen[2].ToString();
}
txtSite.Text = linkModel.Site;
txtWtitle.Text = plModel.title;
txtKeyword1.Text = plModel.keywords;
txtWebDesr.Text = plModel.webdescription;
txtReTime.Text = inModel.refreshTime.ToString("yyyy-MM-dd");
//0未审核 1审核通过2审核未通过
switch (int.Parse(inModel.auditId.ToString()))
{
case 0:
rdAudit.Checked = true;
Page.ClientScript.RegisterStartupScript(this.GetType(), "myKey", " ConAudit(0);", true);
break;
case 1:
rdPass.Checked = true;
Page.ClientScript.RegisterStartupScript(this.GetType(), "myKey", " ConAudit(1);", true);
break;
case 2:
rdNopass.Checked = true;
Page.ClientScript.RegisterStartupScript(this.GetType(), "myKey", " ConAudit(2);", true);
break;
case 4:
rdDelete.Checked = true;
rdPass.Enabled = false;
rdAudit.Enabled = false;
rdNopass.Enabled = false;
Page.ClientScript.RegisterStartupScript(this.GetType(), "myKey", " ConAudit(0);", true);
break;
default:
rdAudit.Checked = true;
Page.ClientScript.RegisterStartupScript(this.GetType(), "myKey", " ConAudit(0);", true);
break;
}
if (inModel.chargeId == 0)
{
rdomian.Checked = true;
spShowPoint.Attributes.Add("style", "display:none");
}
else
{
rdoShou.Checked = true;
spShowPoint.Attributes.Add("style", "display:''");
}
}
//修改
protected void btnSubmit_Click(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(this.txtTitle.Text))
{
Tz888.Common.MessageBox.Show(this.Page, "请填写标题!");
return;
}
if (string.IsNullOrEmpty(this.ddlServiceType.SelectedValue))
{
Tz888.Common.MessageBox.Show(this.Page, "请选择服务大类！");
return;
}
//if (string.IsNullOrEmpty(this.slServerMDrop.SelectedValue))
//{
// Tz888.Common.MessageBox.Show(this.Page, "请选择服务小类！");
// return;
//}
if (string.IsNullOrEmpty(this.txtContent.Text))
{
Tz888.Common.MessageBox.Show(this.Page, "请填写说明!");
return;
}
if (string.IsNullOrEmpty(this.txtCompany.Text))
{
Tz888.Common.MessageBox.Show(this.Page, "请填写单位名称!");
return;
}
if (string.IsNullOrEmpty(this.txtLinkMan.Text))
{
Tz888.Common.MessageBox.Show(this.Page, "请填写申请人!");
return;
}
if (txtTel.Text.Trim() == "" && txtPhone.Text.Trim() == "")
{
Tz888.Common.MessageBox.Show(this.Page, "联系人电话和手机至少填一个！");
return;
}
else
{
if (txtTel.Text.Trim() != "")
{
if (!PageValidate.IsNumber(txtTel.Text.Trim()))
{
Tz888.Common.MessageBox.Show(this.Page, "联系人电话格式错误！");
return;
}
}
}
if (txtEmail.Text.Trim() != "")
{
if (!PageValidate.IsEmail(txtEmail.Text.ToLower().Trim()))
{
Tz888.Common.MessageBox.Show(this.Page, "Email地址格式错误！");
return;
}
}
ProfessionalinfoTab MainInfo = new ProfessionalinfoTab();
Professionalview viewInfo = new Professionalview();
ProfessionalLink personInfo = new ProfessionalLink();
if (!string.IsNullOrEmpty(Request.QueryString["ProfessionalID"]))
{
int ProfessionalID = int.Parse(Request.QueryString["ProfessionalID"].ToString());
MainInfo.ProfessionalID = ProfessionalID;
}
MainInfo.Titel = txtTitle.Text.Trim();
viewInfo.CountryCode = this.ZoneSelectControl1.CountryID;
viewInfo.ProvinceID = this.ZoneSelectControl1.ProvinceID;
viewInfo.CityID = this.ZoneSelectControl1.CityID;
viewInfo.CountyID = this.ZoneSelectControl1.CountyID;
viewInfo.description = txtContent.Text.Trim();
viewInfo.validityID = int.Parse(rdlValiditeTerm.SelectedValue.ToString());
viewInfo.typeID = int.Parse(ddlServiceType.SelectedValue.ToString());
personInfo.Address = txtAddress.Text.Trim();
personInfo.CompanyName = txtCompany.Text.Trim();
personInfo.Email = txtEmail.Text.Trim();
personInfo.Fax = txtFax.Text.Trim();
personInfo.phone = txtPhone.Text.Trim();
personInfo.Tel = txtTel.Text.Trim();
personInfo.UserName = txtLinkMan.Text.Trim();
personInfo.Site = txtSite.Text.Trim();
personInfo.phone = txtPhone.Text.Trim();
MainInfo.LoginName = Page.User.Identity.Name;
if (viewbll.UpdateProFessionlView(MainInfo, viewInfo, personInfo))
{
Response.Write("<script>alert('更新成功！');document.location='ServiesManage.aspx'</script>");
}
else
{
Tz888.Common.MessageBox.Show(this.Page, "更新失败！");
}
}
public int StaticHtml(int professionalid)
{
try
{
infoModel = infoBll.GetModel(professionalid);
linkModel = linkBll.GetModel(professionalid);
viewModel = viewBll.GetModel(professionalid);
string TempFileName = CasesTem.ToString();
string Tem = Compage.Reader(TempFileName); //读取模板内容
string TempSoure = Tem;
string ProviceName = linkBll.GetProvinceNameByCode(viewModel.ProvinceID.ToString()).Trim();
string typeName = typeBll.GetModel(viewModel.typeID).typeName; //服务类别
if (ProviceName.Trim() == "")
{
ProviceName = "中国";
}
string systime = "";
if (viewModel.validityID == 3)
{
systime = "3个月";
}
else if (viewModel.validityID == 6)
{
systime = "半年";
}
else if (viewModel.validityID == 12)
{
systime = "1年";
}
else if (viewModel.validityID == 24)
{
systime = "2年";
}
else if (viewModel.validityID == 36)
{
systime = "3年";
}
else if (viewModel.validityID == 60)
{
systime = "5年";
}
string price = string.Empty;
if (infoModel.chargeId == 0)
{
price = "免费资源";
}
else
{
price = infoModel.price + "元";
}
string xiangxi = GetTop3Data(viewModel.ProvinceID.ToString());
string desc = Gettop6Data();
TempSoure = TempSoure.Replace("$ProfessionalID$", infoModel.ProfessionalID.ToString().Trim());
TempSoure = TempSoure.Replace("$title$", infoModel.Titel.ToString().Trim());
TempSoure = TempSoure.Replace("$AreaName$", ProviceName);
TempSoure = TempSoure.Replace("$typeName$", typeName);
TempSoure = TempSoure.Replace("$publishT$", infoModel.creatgeDate.ToString().Substring(0, 9));
TempSoure = TempSoure.Replace("$validateID$", systime);
TempSoure = TempSoure.Replace("$Content1$", viewModel.description.ToString().Trim());
TempSoure = TempSoure.Replace("$KeyWord$", viewModel.keywords.ToString().Trim());
TempSoure = TempSoure.Replace("$DisplayTitle$", viewModel.title.ToString().Trim());
TempSoure = TempSoure.Replace("$charge$", price);
TempSoure = TempSoure.Replace("$CompanyName$", linkModel.CompanyName.ToString().Trim());
//TempSoure = TempSoure.Replace("$Info$", xiangxi);
TempSoure = TempSoure.Replace("$Content$", xiangxi);
TempSoure = TempSoure.Replace("$Content2$", desc);
string inPathTo = "/dservice";
if (string.IsNullOrEmpty(infoModel.htmlUrl))
{
infoModel.htmlUrl = "dservice/" + DateTime.Now.ToString("yyyyMM") + "/dservice" + DateTime.Now.ToString("yyyyMMdd") + "_" + professionalid + ".shtml";
}
string htmlFile = infoModel.htmlUrl.ToString().Trim();
string[] html = htmlFile.Split('/');
string[] nn = html[2].Split('_');
string cc = nn[0].Substring(nn[0].Length - 8);
string folder = ProPath + html[1].Replace("dservice", "");
if (Directory.Exists(folder) == false)
{
Directory.CreateDirectory(folder);
}
string htmlpaths = folder + inPathTo + cc + "_" + professionalid + ".shtml";
Compage.Writer(htmlpaths, TempSoure);
return(1);
}
catch (Exception)
{
return(0);
}
}
protected void btnOk_Click(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(this.txtTitle.Text))
{
Tz888.Common.MessageBox.Show(this.Page, "请填写标题!");
return;
}
if (this.DropIndustry.SelectedValue == "" || this.DropIndustry.SelectedValue == "0")
{
Tz888.Common.MessageBox.Show(this.Page, "行业不能为空！");
return;
}
if (this.ddlServiceType.SelectedValue == "")
{
Tz888.Common.MessageBox.Show(this.Page, "服务类别不能为空！");
return;
}
if (txtEmployeeCount.Value != "")
{
if (!PageValidate.IsNumber(txtEmployeeCount.Value))
{
Tz888.Common.MessageBox.Show(this.Page, "企业规模请填写数字！");
return;
}
}
if (txtRegistMoeny.Value != "")
{
if (!PageValidate.IsNumber(txtRegistMoeny.Value))
{
Tz888.Common.MessageBox.Show(this.Page, "注册资金请填写数字！");
return;
}
}
//if (txtRegistYear.Text == "")
//{
// Tz888.Common.MessageBox.Show(this.Page, "创建时间请填写！");
// return;
//}
if (txtTurnover.Value != "")
{
if (!PageValidate.IsNumber(txtTurnover.Value))
{
Tz888.Common.MessageBox.Show(this.Page, "营业额请填写数字！");
return;
}
}
if (txtLinkMan.Value.Trim() == "")
{
Tz888.Common.MessageBox.Show(this.Page, "联系人不能为空！");
return;
}
if (txtCompanyName.Value.Trim() == "")
{
Tz888.Common.MessageBox.Show(this.Page, "公司名称不能为空！");
return;
}
//if (txtLinkTel.Value.Trim() == "")
//{
// Tz888.Common.MessageBox.Show(this.Page, "联系人电话不能为空！");
// return;
//}
if (txtLinkTel.Value.Trim() == "" && txtPhone.Text.Trim() == "")
{
Tz888.Common.MessageBox.Show(this.Page, "联系人电话和手机至少填一个！");
return;
}
else
{
if (txtLinkTel.Value.Trim() != "")
{
if (!PageValidate.IsNumber(txtLinkTel.Value.Trim()))
{
Tz888.Common.MessageBox.Show(this.Page, "联系人电话格式错误！");
return;
}
}
}
if (txtEmail.Value.Trim() != "")
{
if (!PageValidate.IsEmail(txtEmail.Value.ToLower().Trim()))
{
Tz888.Common.MessageBox.Show(this.Page, "Email地址格式错误！");
return;
}
}
ProfessionalPlease please = new ProfessionalPlease();
ProfessionalinfoTab MainInfo = new ProfessionalinfoTab();
if (!string.IsNullOrEmpty(Request.QueryString["ProfessionalID"]))
{
int ProfessionalID = int.Parse(Request.QueryString["ProfessionalID"].ToString());
MainInfo.ProfessionalID = ProfessionalID;
}
ProfessionalLink link = new ProfessionalLink();
please.CountryCode = this.ZoneSelectControl1.CountryID;
please.ProvinceID = this.ZoneSelectControl1.ProvinceID;
please.CityID = this.ZoneSelectControl1.CityID;
please.CountyID = this.ZoneSelectControl1.CountyID;
please.description = txtBusinesDetails.Text.Trim();
please.companydate = Convert.ToDateTime(txtRegistYear.Text.Trim().ToString());
please.servicetypeID = int.Parse(ddlServiceType.SelectedValue.ToString()); //服务类型
please.institutionsID = int.Parse(DropIndustry.SelectedValue.ToString()); //机构类别
please.Enterprisesize = txtEmployeeCount.Value.Trim(); //企业规模
please.funds = txtRegistMoeny.Value.Trim(); //注册资金
please.turnover = txtTurnover.Value.Trim(); //营业额
please.validityID = int.Parse(rdlValiditeTerm.SelectedValue.ToString()); //有效期
link.CompanyName = txtCompanyName.Value.Trim();
link.Email = txtEmail.Value.Trim();
link.Fax = txtLinkFax.Value.Trim();
link.Tel = txtLinkTel.Value.Trim();
link.UserName = txtLinkMan.Value.Trim();
link.Site = txtWebSite.Value.Trim();
link.Address = txtAddress.Text.Trim();
link.phone = txtPhone.Text.Trim();
MainInfo.Titel = txtTitle.Text.Trim();
MainInfo.LoginName = Page.User.Identity.Name;
if (plBll.UpdateProFessionlView(MainInfo, please, link))
{
Response.Write("<script>alert('修改成功！');document.location='ServiesManage.aspx'</script>");
}
else
{
Tz888.Common.MessageBox.Show(this.Page, "修改失败！");
}
}
protected void databindList(int ProfessionalID)
{
Professionaltalents plModel = plBll.GetModel(ProfessionalID);
ProfessionalLink linkModel = linkBll.GetModel(ProfessionalID);
ProfessionalinfoTab inModel = infoBll.GetModel(ProfessionalID);
txtTitle.Text = inModel.Titel.ToString();
txtPrice.Text = inModel.price.ToString();
if (!string.IsNullOrEmpty(plModel.Images))
{
if (plModel.Images.Equals("/dservice/image/photo.jpg"))
{
ViewState["flag"] = "true"; //默认图片
}
else
{
ViewState["strSavePath"] = plModel.Images;
}
Image1.ImageUrl = "http://www.topfo.com" + plModel.Images;
//Image1.ImageUrl = "F:/Topfo" + plModel.Images;////本地
imageDis.Attributes.Add("style", "display:''");
}
else
{
//DateTime Now = DateTime.Now;
ViewState["strSavePath"] = "/dservice/image/photo.jpg";
//ViewState["strSavePath"] = "/dservice/image/" + Now.Year.ToString() + "/" + Now.Year.ToString() + Now.Month.ToString() + Now.Day.ToString() +
// Now.Hour.ToString() + Now.Minute.ToString() + Now.Second.ToString() + ".jpg";
imageDis.Attributes.Add("style", "display:none");
}
this.ZoneSelectControl1.CountryID = plModel.CountryCode;
this.ZoneSelectControl1.ProvinceID = plModel.ProvinceID;
this.ZoneSelectControl1.CityID = plModel.CityID;
this.ZoneSelectControl1.CountyID = plModel.CountyID;
txtRegistYear.Text = plModel.companydate.ToString("yyyy-MM-dd");
txtPosition.Value = plModel.position; //职务
DropIndustry.SelectedValue = plModel.talentsTypeID.ToString(); //人才类别
txtRegistYear.Text = plModel.companydate.ToString("yyyy-MM-dd");
txtresume.Text = plModel.resume; //个人简历
txtspecialty.Text = plModel.specialty; //个人特长
txtSuccess.Text = plModel.ScuccCase; //成功案例
ddlServiceType.SelectedValue = plModel.servicetypeID.ToString(); //服务类型
rdlValiditeTerm.SelectedValue = plModel.validityID.ToString(); //有效期
txtAddress.Text = linkModel.Address;
txtLinkMan.Text = linkModel.UserName;
txtPhone.Text = linkModel.phone;
txtCompany.Text = linkModel.CompanyName;
txtClick.Text = inModel.clickId.ToString();
txtEmail.Text = linkModel.Email;
txtFax.Text = linkModel.Fax;
tbAuditingRemark.Text = inModel.FeedBackNote;
string tel = linkModel.Tel;
string[] telLen = tel.Split(new char[] { ',' });
if (telLen.Length == 1)
{
txtTel.Text = linkModel.Tel;
}
else
{
txtcontactsTel.Text = telLen[0].ToString();
txtTel.Text = telLen[1].ToString();
txttel2.Text = telLen[2].ToString();
}
txtSite.Text = linkModel.Site;
txtWtitle.Text = plModel.title;
txtKeyword1.Text = plModel.keywords;
txtWebDesr.Text = plModel.Webdescription;
txtReTime.Text = inModel.refreshTime.ToString("yyyy-MM-dd");
//0未审核 1审核通过2审核未通过
switch (int.Parse(inModel.auditId.ToString()))
{
case 0:
rdAudit.Checked = true;
Page.ClientScript.RegisterStartupScript(this.GetType(), "myKey", " ConAudit(0);", true);
break;
case 1:
rdPass.Checked = true;
Page.ClientScript.RegisterStartupScript(this.GetType(), "myKey", " ConAudit(1);", true);
break;
case 2:
rdNopass.Checked = true;
Page.ClientScript.RegisterStartupScript(this.GetType(), "myKey", " ConAudit(2);", true);
break;
case 4:
rdDelete.Checked = true;
rdPass.Enabled = false;
rdAudit.Enabled = false;
rdNopass.Enabled = false;
Page.ClientScript.RegisterStartupScript(this.GetType(), "myKey", " ConAudit(0);", true);
break;
default:
rdAudit.Checked = true;
Page.ClientScript.RegisterStartupScript(this.GetType(), "myKey", " ConAudit(0);", true);
break;
}
if (inModel.chargeId == 0)
{
rdomian.Checked = true;
spShowPoint.Attributes.Add("style", "display:none");
}
else
{
rdoShou.Checked = true;
spShowPoint.Attributes.Add("style", "display:''");
}
}
/// <summary>
/// 插入一条专业服务数据
/// </summary>
/// <returns></returns>
public bool InsertProFessionlView(ProfessionalinfoTab mainInfo, Professionalview viewInfo, ProfessionalLink link)
{
return(viewIdal.InsertProFessionlView(mainInfo, viewInfo, link));
}
public int StaticHtml(int professionalid)
{
try
{
infoModel = infoBll.GetModel(professionalid);
linkModel = linkBll.GetModel(professionalid);
plModel = viewBll.GetModel(professionalid);
string TempFileName = CasesTem.ToString();
string Tem = Compage.Reader(TempFileName); //读取模板内容
string TempSoure = Tem;
string ProviceName = linkBll.GetProvinceNameByCode(plModel.ProvinceID.ToString()).Trim(); //区域
string typeName = typeBll.GetList("institutionsID=" + plModel.institutionsID).Tables[0].Rows[0]["TypeName"].ToString(); //机构类别
if (ProviceName.Trim() == "")
{
ProviceName = "中国";
}
string price = string.Empty;
if (infoModel.chargeId == 0)
{
price = "免费资源";
}
else
{
price = infoModel.price + "元";
}
string xiangxi = GetTop3Data(plModel.ProvinceID.ToString());
string desc = Gettop6Data();
TempSoure = TempSoure.Replace("$ProfessionalID$", infoModel.ProfessionalID.ToString().Trim());
TempSoure = TempSoure.Replace("$title$", infoModel.Titel.ToString().Trim());
TempSoure = TempSoure.Replace("$AreaName$", ProviceName);
TempSoure = TempSoure.Replace("$typeName$", typeName);
TempSoure = TempSoure.Replace("$Enterprisesize$", plModel.Enterprisesize); //企业规模
TempSoure = TempSoure.Replace("$funds$", plModel.funds); //注册资金
TempSoure = TempSoure.Replace("$CreateTime$", plModel.companydate.ToString("yyyy-MM-dd")); //创建时间
TempSoure = TempSoure.Replace("$turnover$", plModel.turnover); //营业额
TempSoure = TempSoure.Replace("$charge$", price); //资源类型
TempSoure = TempSoure.Replace("$Content1$", plModel.description.ToString());
TempSoure = TempSoure.Replace("$KeyWord$", plModel.keywords.ToString().Trim());
TempSoure = TempSoure.Replace("$DisplayTitle$", plModel.title.ToString().Trim());
//TempSoure = TempSoure.Replace("$CompanyName$", linkModel.CompanyName.ToString().Trim());
TempSoure = TempSoure.Replace("$Content$", xiangxi);//相关项目信息
TempSoure = TempSoure.Replace("$Content2$", desc);
string inPathTo = "/dservice";
if (string.IsNullOrEmpty(infoModel.htmlUrl))
{
infoModel.htmlUrl = "dservice/" + DateTime.Now.ToString("yyyyMM") + "/dservice" + DateTime.Now.ToString("yyyyMMdd") + "_" + professionalid + ".shtml";
}
string htmlFile = infoModel.htmlUrl.ToString().Trim();
string[] html = htmlFile.Split('/');
string[] nn = html[2].Split('_');
string cc = nn[0].Substring(nn[0].Length - 8);
string folder = ProPath + html[1].Replace("dservice", "");
if (Directory.Exists(folder) == false)
{
Directory.CreateDirectory(folder);
}
string htmlpaths = folder + inPathTo + cc + "_" + professionalid + ".shtml";
Compage.Writer(htmlpaths, TempSoure);
return(1);
}
catch (Exception)
{
return(0);
}
}
/// <summary>
/// 修改一条专业人才数据
/// </summary>
/// <returns></returns>
public bool UpdateProFessionlView(ProfessionalinfoTab mainInfo, Professionaltalents viewInfo, ProfessionalLink link)
{
int result = 0;
SqlParameter[] parameters =
{
new SqlParameter("@Title", SqlDbType.VarChar, 200),
new SqlParameter("@LoginName", SqlDbType.VarChar, 50),
new SqlParameter("@typeID", SqlDbType.Int, 4),
new SqlParameter("@htmlUrl", SqlDbType.VarChar, 200),
new SqlParameter("@formID", SqlDbType.Int, 4),
new SqlParameter("@recommendID", SqlDbType.Int, 4), //6
new SqlParameter("@CountryCode", SqlDbType.VarChar, 10),
new SqlParameter("@ProvinceID", SqlDbType.VarChar, 10),
new SqlParameter("@CityID", SqlDbType.VarChar, 10),
new SqlParameter("@CountyID", SqlDbType.VarChar, 10),
new SqlParameter("@position", SqlDbType.VarChar, 20),
new SqlParameter("@servicetypeID", SqlDbType.Int, 4),
new SqlParameter("@talentsTypeID", SqlDbType.Int, 4),
new SqlParameter("@resume", SqlDbType.NVarChar, 2000),
new SqlParameter("@specialty", SqlDbType.NVarChar, 2000),
new SqlParameter("@ScuccCase", SqlDbType.NVarChar, 2000),
new SqlParameter("@companydate", SqlDbType.DateTime),
new SqlParameter("@validityID", SqlDbType.Int, 4),
new SqlParameter("@Webtitle", SqlDbType.VarChar, 50),
new SqlParameter("@keywords", SqlDbType.VarChar, 50),
new SqlParameter("@Webdescription", SqlDbType.VarChar, 50), //21
new SqlParameter("@UserName", SqlDbType.VarChar, 100),
new SqlParameter("@CompanyName", SqlDbType.VarChar, 100),
new SqlParameter("@Address", SqlDbType.VarChar, 100),
new SqlParameter("@Tel", SqlDbType.VarChar, 50),
new SqlParameter("@phone", SqlDbType.VarChar, 50),
new SqlParameter("@Fax", SqlDbType.VarChar, 50),
new SqlParameter("@Email", SqlDbType.VarChar, 50),
new SqlParameter("@Site", SqlDbType.VarChar, 50),
new SqlParameter("@price", SqlDbType.Decimal, 18), //9
new SqlParameter("@auditID", SqlDbType.Int, 4),
new SqlParameter("@chargeID", SqlDbType.Int, 4),
new SqlParameter("@stateId", SqlDbType.Int, 4),
new SqlParameter("@clickId", SqlDbType.Int, 4),
new SqlParameter("@refurbishtime", SqlDbType.DateTime), //5
new SqlParameter("@images", SqlDbType.VarChar, 100), //9
new SqlParameter("@FeedBackNote", SqlDbType.NVarChar, 1000),
new SqlParameter("@flag", SqlDbType.VarChar, 20),
new SqlParameter("@ProfessionalID", SqlDbType.Int, 4) //2
};
parameters[0].Value = mainInfo.Titel;
parameters[1].Value = mainInfo.LoginName;
parameters[2].Value = mainInfo.typeID;
parameters[3].Value = mainInfo.htmlUrl;
parameters[4].Value = mainInfo.FromId;
parameters[5].Value = mainInfo.recommendId;
parameters[6].Value = viewInfo.CountryCode;
parameters[7].Value = viewInfo.ProvinceID;
parameters[8].Value = viewInfo.CityID;
parameters[9].Value = viewInfo.CountyID;
parameters[10].Value = viewInfo.position;
parameters[11].Value = viewInfo.servicetypeID;
parameters[12].Value = viewInfo.talentsTypeID;
parameters[13].Value = viewInfo.resume;
parameters[14].Value = viewInfo.specialty;
parameters[15].Value = viewInfo.ScuccCase;
parameters[16].Value = viewInfo.companydate;
parameters[17].Value = viewInfo.validityID;
parameters[18].Value = viewInfo.title;
parameters[19].Value = viewInfo.keywords;
parameters[20].Value = viewInfo.Webdescription;
parameters[21].Value = link.UserName;
parameters[22].Value = link.CompanyName;
parameters[23].Value = link.Address;
parameters[24].Value = link.Tel;
parameters[25].Value = link.phone;
parameters[26].Value = link.Fax;
parameters[27].Value = link.Email;
parameters[28].Value = link.Site;
parameters[29].Value = mainInfo.price;
parameters[30].Value = mainInfo.auditId;
parameters[31].Value = mainInfo.chargeId;
parameters[32].Value = mainInfo.stateId;
parameters[33].Value = mainInfo.clickId;
parameters[34].Value = mainInfo.refreshTime;
parameters[35].Value = viewInfo.Images;
parameters[36].Value = mainInfo.FeedBackNote;
parameters[37].Value = "UpdateManage";
parameters[38].Value = mainInfo.ProfessionalID;
return(DbHelperSQL.RunProcLob("Professionaltalentstab_insert", parameters));
}
/// <summary>
/// 插入一条专业服务数据
/// </summary>
/// <returns></returns>
public bool InsertProFessionlView(ProfessionalinfoTab mainInfo, ProfessionalPlease viewInfo, ProfessionalLink link)
{
int result = 0;
SqlParameter[] parameters =
{
new SqlParameter("@Title", SqlDbType.VarChar, 200),
new SqlParameter("@LoginName", SqlDbType.VarChar, 50),
new SqlParameter("@typeID", SqlDbType.Int, 4),
new SqlParameter("@htmlUrl", SqlDbType.VarChar, 200),
new SqlParameter("@formID", SqlDbType.Int, 4),
new SqlParameter("@recommendID", SqlDbType.Int, 4), //6
new SqlParameter("@CountryCode", SqlDbType.VarChar, 10),
new SqlParameter("@ProvinceID", SqlDbType.VarChar, 10),
new SqlParameter("@CityID", SqlDbType.VarChar, 10),
new SqlParameter("@CountyID", SqlDbType.VarChar, 10),
new SqlParameter("@servicetypeID", SqlDbType.Int, 4),
new SqlParameter("@validityID", SqlDbType.Int, 4),
new SqlParameter("@description", SqlDbType.NVarChar, 2000),
new SqlParameter("@Webtitle", SqlDbType.VarChar, 50),
new SqlParameter("@keywords", SqlDbType.VarChar, 50),
new SqlParameter("@Webdescription", SqlDbType.VarChar, 50), //10
new SqlParameter("@UserName", SqlDbType.VarChar, 100),
new SqlParameter("@CompanyName", SqlDbType.VarChar, 100),
new SqlParameter("@Address", SqlDbType.VarChar, 100),
new SqlParameter("@Tel", SqlDbType.VarChar, 50),
new SqlParameter("@phone", SqlDbType.VarChar, 50),
new SqlParameter("@Fax", SqlDbType.VarChar, 50),
new SqlParameter("@Email", SqlDbType.VarChar, 50),
new SqlParameter("@Site", SqlDbType.VarChar, 50),
new SqlParameter("@price", SqlDbType.Decimal, 18), //9
new SqlParameter("@institutionsID", SqlDbType.Int, 4),
new SqlParameter("@Enterprisesize", SqlDbType.NVarChar, 2000),
new SqlParameter("@funds", SqlDbType.VarChar, 50),
new SqlParameter("@turnover", SqlDbType.VarChar, 50),
new SqlParameter("@companyDate", SqlDbType.DateTime) //5
};
parameters[0].Value = mainInfo.Titel;
parameters[1].Value = mainInfo.LoginName;
parameters[2].Value = mainInfo.typeID;
parameters[3].Value = mainInfo.htmlUrl;
parameters[4].Value = mainInfo.FromId;
parameters[5].Value = mainInfo.recommendId;
parameters[6].Value = viewInfo.CountryCode;
parameters[7].Value = viewInfo.ProvinceID;
parameters[8].Value = viewInfo.CityID;
parameters[9].Value = viewInfo.CountyID;
parameters[10].Value = viewInfo.servicetypeID;
parameters[11].Value = viewInfo.validityID;
parameters[12].Value = viewInfo.description;
parameters[13].Value = viewInfo.title;
parameters[14].Value = viewInfo.keywords;
parameters[15].Value = viewInfo.description;
parameters[16].Value = link.UserName;
parameters[17].Value = link.CompanyName;
parameters[18].Value = link.Address;
parameters[19].Value = link.Tel;
parameters[20].Value = link.phone;
parameters[21].Value = link.Fax;
parameters[22].Value = link.Email;
parameters[23].Value = link.Site;
parameters[24].Value = mainInfo.price;
parameters[25].Value = viewInfo.institutionsID;
parameters[26].Value = viewInfo.Enterprisesize;
parameters[27].Value = viewInfo.funds;
parameters[28].Value = viewInfo.turnover;
parameters[29].Value = viewInfo.companydate;
return(DbHelperSQL.RunProcLob("ProfessionalPleasetab_insert", parameters));
}
protected void btnOk_Click(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(this.txtTitle.Text))
{
Tz888.Common.MessageBox.Show(this.Page, "请填写标题!");
return;
}
if (this.DropIndustry.SelectedValue == "" || this.DropIndustry.SelectedValue == "0")
{
Tz888.Common.MessageBox.Show(this.Page, "请选择人才类别！");
return;
}
if (this.ddlServiceType.SelectedValue == "")
{
Tz888.Common.MessageBox.Show(this.Page, "服务类型不能为空！");
return;
}
//if (!string.IsNullOrEmpty(uploadPic.FileName))
//{
// string fileName1 = uploadPic.FileName;
// string extendName = fileName1.ToLower().Substring(fileName1.LastIndexOf("."));
// if (extendName != ".bmp" && extendName != ".gif" && extendName != ".jpg")
// {
// Tz888.Common.MessageBox.Show(this.Page, "只能上传｜jpg｜gif｜bmp｜格式的图片！");
// return;
// }
//}
if (txtPosition.Value == "")
{
Tz888.Common.MessageBox.Show(this.Page, "职务不能为空！");
return;
}
if (txtLinkMan.Value.Trim() == "")
{
Tz888.Common.MessageBox.Show(this.Page, "联系人不能为空！");
return;
}
if (txtCompanyName.Value.Trim() == "")
{
Tz888.Common.MessageBox.Show(this.Page, "公司名称不能为空！");
return;
}
if (txtLinkTel.Text.Trim() == "" && txtPhone.Text.Trim() == "")
{
Tz888.Common.MessageBox.Show(this.Page, "联系人电话和手机至少填一个！");
return;
}
else
{
if (txtLinkTel.Text.Trim() != "")
{
if (!PageValidate.IsNumber(txtLinkTel.Text.Trim()))
{
Tz888.Common.MessageBox.Show(this.Page, "联系人电话格式错误！");
return;
}
}
}
if (txtEmail.Value.Trim() == "")
{
Tz888.Common.MessageBox.Show(this.Page, "Email不能为空！！");
return;
}
if (txtEmail.Value.Trim() != "")
{
if (!PageValidate.IsEmail(txtEmail.Value.ToLower().Trim()))
{
Tz888.Common.MessageBox.Show(this.Page, "Email地址格式错误！");
return;
}
}
Professionaltalents please = new Professionaltalents();
ProfessionalinfoTab MainInfo = new ProfessionalinfoTab();
ProfessionalLink link = new ProfessionalLink();
if (!string.IsNullOrEmpty(Request.QueryString["ProfessionalID"]))
{
int ProfessionalID = int.Parse(Request.QueryString["ProfessionalID"].ToString());
MainInfo.ProfessionalID = ProfessionalID;
}
if (!string.IsNullOrEmpty(ViewState["strSavePath"].ToString()))
{
please.Images = ViewState["strSavePath"].ToString();
}
else
{
please.Images = "/dservice/image/photo.jpg";
}
please.CountryCode = this.ZoneSelectControl1.CountryID;
please.ProvinceID = this.ZoneSelectControl1.ProvinceID;
please.CityID = this.ZoneSelectControl1.CityID;
please.CountyID = this.ZoneSelectControl1.CountyID;
please.companydate = Convert.ToDateTime(DateTime.Now.ToString()); //Convert.ToDateTime(txtRegistYear.Text.Trim().ToString());
please.position = txtPosition.Value.Trim();
please.title = "";
please.servicetypeID = int.Parse(ddlServiceType.SelectedValue.ToString()); //服务类型
please.talentsTypeID = int.Parse(DropIndustry.SelectedValue.ToString()); //人才类别
please.resume = txtresume.Text; //个人简历
please.specialty = txtspecialty.Text; //个人特长
please.ScuccCase = txtSuccess.Text; //成功案例
please.validityID = int.Parse(rdlValiditeTerm.SelectedValue.ToString()); //有效期
link.CompanyName = txtCompanyName.Value.Trim();
link.Email = txtEmail.Value.Trim();
link.Fax = txtLinkFax.Value.Trim();
string tel = string.Empty;
if (!string.IsNullOrEmpty(txtcontactsTel.Text.Trim()))
{
tel = txtcontactsTel.Text.Trim() + ",";
}
else
{
tel = ",";
}
if (!string.IsNullOrEmpty(txtLinkTel.Text.Trim()))
{
tel += txtLinkTel.Text.Trim() + ",";
}
else
{
tel += ",";
}
if (!string.IsNullOrEmpty(txttel2.Text.Trim()))
{
tel += txttel2.Text.Trim() + ",";
}
else
{
tel += ",";
}
link.Tel = tel;
link.UserName = txtLinkMan.Value.Trim();
link.Site = txtWebSite.Value.Trim();
link.phone = txtPhone.Text.Trim();
link.Address = txtAddress.Text.Trim();
MainInfo.LoginName = Page.User.Identity.Name;
MainInfo.Titel = txtTitle.Text.Trim();
MainInfo.typeID = 3;
MainInfo.htmlUrl = "";
MainInfo.FromId = 1;
MainInfo.recommendId = 0;
MainInfo.price = 0;
if (plBll.InsertProFessionlView(MainInfo, please, link))
{
Response.Write("<script>alert('发布成功！');document.location='ServiesManage.aspx'</script>");
}
else
{
Tz888.Common.MessageBox.Show(this.Page, "发布失败！");
}
}
public bool UpdateProFessionlView(ProfessionalinfoTab mainInfo, Professionalview viewInfo, ProfessionalLink link)
{
int result = 0;
SqlParameter[] parameters =
{
new SqlParameter("@Title", SqlDbType.VarChar, 200),
new SqlParameter("@LoginName", SqlDbType.VarChar, 50),
new SqlParameter("@typeID", SqlDbType.Int, 4),
new SqlParameter("@htmlUrl", SqlDbType.VarChar, 200),
new SqlParameter("@formID", SqlDbType.Int, 4),
new SqlParameter("@recommendID", SqlDbType.Int, 4), //6
new SqlParameter("@CountryCode", SqlDbType.VarChar, 10),
new SqlParameter("@ProvinceID", SqlDbType.VarChar, 10),
new SqlParameter("@CityID", SqlDbType.VarChar, 10),
new SqlParameter("@CountyID", SqlDbType.VarChar, 10),
new SqlParameter("@typeID1", SqlDbType.Int, 4),
new SqlParameter("@validityID", SqlDbType.Int, 4),
new SqlParameter("@description", SqlDbType.NVarChar, 2000),
new SqlParameter("@Webtitle", SqlDbType.VarChar, 50),
new SqlParameter("@keywords", SqlDbType.VarChar, 50),
new SqlParameter("@Webdescription", SqlDbType.VarChar, 50), //10
new SqlParameter("@UserName", SqlDbType.VarChar, 100),
new SqlParameter("@CompanyName", SqlDbType.VarChar, 100),
new SqlParameter("@Address", SqlDbType.VarChar, 100),
new SqlParameter("@Tel", SqlDbType.VarChar, 50),
new SqlParameter("@phone", SqlDbType.VarChar, 50),
new SqlParameter("@Fax", SqlDbType.VarChar, 50),
new SqlParameter("@Email", SqlDbType.VarChar, 50),
new SqlParameter("@Site", SqlDbType.VarChar, 50), //8
new SqlParameter("@price", SqlDbType.Decimal, 18), //1
new SqlParameter("@flag", SqlDbType.VarChar, 20),
new SqlParameter("@ProfessionalID", SqlDbType.Int, 4) //2
};
parameters[0].Value = mainInfo.Titel;
parameters[1].Value = mainInfo.LoginName;
parameters[2].Value = mainInfo.typeID;
parameters[3].Value = mainInfo.htmlUrl;
parameters[4].Value = mainInfo.FromId;
parameters[5].Value = mainInfo.recommendId;
parameters[6].Value = viewInfo.CountryCode;
parameters[7].Value = viewInfo.ProvinceID;
parameters[8].Value = viewInfo.CityID;
parameters[9].Value = viewInfo.CountyID;
parameters[10].Value = viewInfo.typeID;
parameters[11].Value = viewInfo.validityID;
parameters[12].Value = viewInfo.description;
parameters[13].Value = viewInfo.title;
parameters[14].Value = viewInfo.keywords;
parameters[15].Value = viewInfo.Webdescription;
parameters[16].Value = link.UserName;
parameters[17].Value = link.CompanyName;
parameters[18].Value = link.Address;
parameters[19].Value = link.Tel;
parameters[20].Value = link.phone;
parameters[21].Value = link.Fax;
parameters[22].Value = link.Email;
parameters[23].Value = link.Site;
parameters[24].Value = mainInfo.price;
parameters[25].Value = "Update";
parameters[26].Value = mainInfo.ProfessionalID;
return(DbHelperSQL.RunProcLob("Professionalviewtab_insert", parameters));
}
public int StaticHtml(int professionalid)
{
try
{
infoModel = infoBll.GetModel(professionalid);
linkModel = linkBll.GetModel(professionalid);
plModel = viewBll.GetModel(professionalid);
string TempFileName = CasesTem.ToString();
string Tem = Compage.Reader(TempFileName); //读取模板内容
string TempSoure = Tem;
string ProviceName = linkBll.GetProvinceNameByCode(plModel.ProvinceID.ToString()).Trim(); //区域
//string typeName = typeBll.GetList("institutionsID=" + plModel.institutionsID).Tables[0].Rows[0]["TypeName"].ToString(); //机构类别
string typeName = talentsType.GetList("typeID=" + plModel.talentsTypeID).Tables[0].Rows[0]["TypeName"].ToString(); //人才类别
string Servicetype = typeBll1.GetModel(int.Parse(plModel.servicetypeID.ToString())).typeName;
if (ProviceName.Trim() == "")
{
ProviceName = "中国";
}
string price = string.Empty;
if (infoModel.chargeId == 0)
{
price = "免费资源";
}
else
{
price = infoModel.price + "元";
}
string xiangxi = GetTop3Data(plModel.ProvinceID.ToString());
string desc = Gettop6Data();
TempSoure = TempSoure.Replace("$ProfessionalID$", infoModel.ProfessionalID.ToString().Trim());
TempSoure = TempSoure.Replace("$title$", linkModel.UserName.ToString());
TempSoure = TempSoure.Replace("$AreaName$", ProviceName);
TempSoure = TempSoure.Replace("$type$", typeName);
TempSoure = TempSoure.Replace("$typeName$", Servicetype);
TempSoure = TempSoure.Replace("$position$", plModel.position.ToString());
TempSoure = TempSoure.Replace("$resume$ ", plModel.resume.ToString());
TempSoure = TempSoure.Replace("$CreateTime$", plModel.companydate.ToString("yyyy-MM-dd"));//创建时间
TempSoure = TempSoure.Replace("$specialty$", plModel.specialty.ToString());
TempSoure = TempSoure.Replace("$ScuccCase$ ", plModel.ScuccCase.ToString());
TempSoure = TempSoure.Replace("$KeyWord$", plModel.keywords.ToString().Trim());
TempSoure = TempSoure.Replace("$DisplayTitle$", plModel.title.ToString().Trim());
TempSoure = TempSoure.Replace("$image$", "http://www.topfo.com" + plModel.Images.ToString().Trim());
TempSoure = TempSoure.Replace("$CompanyName$", linkModel.CompanyName.ToString().Trim());
TempSoure = TempSoure.Replace("$Content$", xiangxi);//相关项目信息
TempSoure = TempSoure.Replace("$Content2$", desc);
string inPathTo = "/dservice";
if (string.IsNullOrEmpty(infoModel.htmlUrl))
{
infoModel.htmlUrl = "dservice/" + DateTime.Now.ToString("yyyyMM") + "/dservice" + DateTime.Now.ToString("yyyyMMdd") + "_" + professionalid + ".shtml";
}
string htmlFile = infoModel.htmlUrl.ToString().Trim();
string[] html = htmlFile.Split('/');
string[] nn = html[2].Split('_');
string cc = nn[0].Substring(nn[0].Length - 8);
string folder = ProPath + html[1].Replace("dservice", "");
if (Directory.Exists(folder) == false)
{
Directory.CreateDirectory(folder);
}
string htmlpaths = folder + inPathTo + cc + "_" + professionalid + ".shtml";
Compage.Writer(htmlpaths, TempSoure);
return(1);
}
catch (Exception)
{
return(0);
}
}
