//修改
public int EnterpriseUpdate(Tz888.Model.Register.EnterpriseInfoModel model,
Tz888.Model.Register.OrgContactModel ContactModel,
List <Tz888.Model.Register.OrgContactMan> ContactManModels,
List <Tz888.Model.MemberResourceModel> infoResourceModels)
{
return(dal.EnterpriseUpdate(model, ContactModel, ContactManModels, infoResourceModels));
}
//审核
public bool AuditEnterprise(Tz888.Model.Register.EnterpriseInfoModel Enterprise, Tz888.Model.Register.OrgAuditModel OrgAudi)
{
SqlParameter[] parameters =
{
#region 公司基本信息
new SqlParameter("@EnterpriseID", SqlDbType.Int, 4),
new SqlParameter("@LoginName", SqlDbType.Char, 16),
new SqlParameter("@EnterpriseName", SqlDbType.VarChar, 200),
new SqlParameter("@ComAbout", SqlDbType.VarChar, -1),
new SqlParameter("@ComAboutBrief", SqlDbType.VarChar, -1),
new SqlParameter("@ManageTypeID", SqlDbType.Char, 10),
new SqlParameter("@Industrylist", SqlDbType.Char, 10),
new SqlParameter("@RegisterDate", SqlDbType.DateTime),
new SqlParameter("@CountryCode", SqlDbType.Char, 10),
new SqlParameter("@ProvinceID", SqlDbType.Char, 10),
new SqlParameter("@CityID", SqlDbType.Char, 10),
new SqlParameter("@CountyID", SqlDbType.Char, 10),
new SqlParameter("@currency", SqlDbType.Char, 10),
new SqlParameter("@RegCapital", SqlDbType.Float, 8),
new SqlParameter("@MainProduct", SqlDbType.VarChar, 30),
new SqlParameter("@RequirInfo", SqlDbType.Char, 30),
new SqlParameter("@AuditingStatus", SqlDbType.TinyInt, 1), //审核结果(1审核通过,2审核不通过)
new SqlParameter("@ExhibitionHall", SqlDbType.VarChar, 100), //展厅
new SqlParameter("@hits", SqlDbType.VarChar, 100), //点数
new SqlParameter("@remark", SqlDbType.VarChar, 100), //备注
#endregion
#region 附加信息
#endregion
#region 联系方式
new SqlParameter("@LoginName", SqlDbType.Char, 16),
new SqlParameter("@OrganizationName", SqlDbType.VarChar, 100),
new SqlParameter("@Name", SqlDbType.VarChar, 20),
new SqlParameter("@Career", SqlDbType.VarChar, 20),
new SqlParameter("@TelCountryCode", SqlDbType.Char, 3),
new SqlParameter("@TelStateCode", SqlDbType.Char, 4),
new SqlParameter("@TelNum", SqlDbType.VarChar, 60),
new SqlParameter("@FaxCountryCode", SqlDbType.Char, 3),
new SqlParameter("@FaxStateCode", SqlDbType.Char, 4),
new SqlParameter("@FaxNum", SqlDbType.VarChar, 60),
new SqlParameter("@Email", SqlDbType.VarChar, 50),
new SqlParameter("@Mobile", SqlDbType.VarChar, 30),
new SqlParameter("@address", SqlDbType.VarChar, 100),
new SqlParameter("@PostCode", SqlDbType.VarChar, 10),
new SqlParameter("@IsDel", SqlDbType.Bit, 1),
new SqlParameter("@remark", SqlDbType.VarChar, 100),
#endregion
#region 审核记录
//new SqlParameter("@OrgName", SqlDbType.VarChar,200),= @EnterpriseName
//new SqlParameter("@LoginName", SqlDbType.Char,16),
new SqlParameter("@AuditingRemark", SqlDbType.VarChar, 100), //未通过审核原因
new SqlParameter("@AuditingBy", SqlDbType.VarChar, 20), //审核人
new SqlParameter("@AuditingDate", SqlDbType.DateTime), //审核时间
new SqlParameter("@FeedbackStatus", SqlDbType.TinyInt, 1), //反馈状态
new SqlParameter("@FeedBackNote", SqlDbType.VarChar, 300), //邮件反馈内容
new SqlParameter("@OrgType", SqlDbType.TinyInt, 1), //组织类型(0企业，1政府机构)
new SqlParameter("@Memo", SqlDbType.VarChar, 200) //备注
#endregion
};
parameters[0].Direction = ParameterDirection.Output;
parameters[1].Value = Enterprise.LoginName;
parameters[2].Value = Enterprise.EnterpriseName;
parameters[3].Value = Enterprise.ComAbout;
parameters[4].Value = Enterprise.ComAboutBrief;
parameters[5].Value = Enterprise.SetComTypeID;
parameters[6].Value = Enterprise.Industrylist;
parameters[7].Value = Enterprise.RegisterDate;
parameters[8].Value = Enterprise.CountryCode;
parameters[9].Value = Enterprise.ProvinceID;
parameters[10].Value = Enterprise.CityID;
parameters[11].Value = Enterprise.CountyID;
parameters[12].Value = Enterprise.currency;
parameters[13].Value = Enterprise.RegCapital;
parameters[14].Value = Enterprise.MainProduct;
parameters[15].Value = Enterprise.RequirInfo;
parameters[16].Value = Enterprise.AuditingStatus;
parameters[17].Value = Enterprise.ExhibitionHall;
parameters[18].Value = Enterprise.hits;
parameters[19].Value = Enterprise.remark;
parameters[20].Value = OrgAudi.AuditingRemark;
parameters[21].Value = OrgAudi.AuditingBy;
parameters[22].Value = OrgAudi.AuditingDate;
parameters[23].Value = OrgAudi.FeedbackStatus;
parameters[24].Value = OrgAudi.FeedBackNote;
parameters[25].Value = OrgAudi.OrgType;
parameters[26].Value = OrgAudi.Memo;
return(true);
}
//修改
public int EnterpriseUpdate(Tz888.Model.Register.EnterpriseInfoModel model,
Tz888.Model.Register.OrgContactModel ContactModel,
List <Tz888.Model.Register.OrgContactMan> ContactManModels,
List <Tz888.Model.MemberResourceModel> infoResourceModels)
{
SqlParameter[] parameters =
{
#region 公司基本信息
new SqlParameter("@EnterpriseID", SqlDbType.Int, 4),
new SqlParameter("@LoginName", SqlDbType.Char, 16),
new SqlParameter("@EnterpriseName", SqlDbType.VarChar, 200),
new SqlParameter("@ComAbout", SqlDbType.VarChar, -1),
new SqlParameter("@ComAboutBrief", SqlDbType.VarChar, -1),
new SqlParameter("@SetComTypeID", SqlDbType.Char, 10),
new SqlParameter("@Industrylist", SqlDbType.Char, 10),
new SqlParameter("@RegisterDate", SqlDbType.DateTime),
new SqlParameter("@CountryCode", SqlDbType.Char, 10),
new SqlParameter("@ProvinceID", SqlDbType.Char, 10),
new SqlParameter("@CityID", SqlDbType.Char, 10),
new SqlParameter("@CountyID", SqlDbType.Char, 10),
new SqlParameter("@currency", SqlDbType.Char, 10),
new SqlParameter("@RegCapital", SqlDbType.Float, 8),
new SqlParameter("@MainProduct", SqlDbType.VarChar, 30),
new SqlParameter("@RequirInfo", SqlDbType.Char, 30),
new SqlParameter("@AuditingStatus", SqlDbType.TinyInt, 1),
new SqlParameter("@ExhibitionHall", SqlDbType.VarChar, 100),
new SqlParameter("@hits", SqlDbType.VarChar, 100),
new SqlParameter("@remark", SqlDbType.VarChar, 100),
#endregion
#region 联系方式
new SqlParameter("@OrganizationName", SqlDbType.VarChar, 100),
new SqlParameter("@Name", SqlDbType.VarChar, 20),
new SqlParameter("@Career", SqlDbType.VarChar, 20),
new SqlParameter("@TelCountryCode", SqlDbType.Char, 6),
new SqlParameter("@TelStateCode", SqlDbType.Char, 8),
new SqlParameter("@TelNum", SqlDbType.VarChar, 100),
new SqlParameter("@FaxCountryCode", SqlDbType.Char, 6),
new SqlParameter("@FaxStateCode", SqlDbType.Char, 8),
new SqlParameter("@FaxNum", SqlDbType.VarChar, 100),
new SqlParameter("@Email", SqlDbType.VarChar, 50),
new SqlParameter("@Mobile", SqlDbType.VarChar, 30),
new SqlParameter("@address", SqlDbType.VarChar, 100),
new SqlParameter("@PostCode", SqlDbType.VarChar, 10),
new SqlParameter("@Website", SqlDbType.VarChar, 200),
new SqlParameter("@IsDel", SqlDbType.Bit, 1),
new SqlParameter("@remark1", SqlDbType.VarChar, 100)
#endregion
};
parameters[0].Value = model.EnterpriseID;
parameters[1].Value = model.LoginName;
parameters[2].Value = model.EnterpriseName;
parameters[3].Value = model.ComAbout;
parameters[4].Value = model.ComAboutBrief;
parameters[5].Value = model.SetComTypeID;
parameters[6].Value = model.Industrylist;
parameters[7].Value = model.RegisterDate;
parameters[8].Value = model.CountryCode;
parameters[9].Value = model.ProvinceID;
parameters[10].Value = model.CityID;
parameters[11].Value = model.CountyID;
parameters[12].Value = model.currency;
parameters[13].Value = model.RegCapital;
parameters[14].Value = model.MainProduct;
parameters[15].Value = model.RequirInfo;
parameters[16].Value = model.AuditingStatus;
parameters[17].Value = model.ExhibitionHall;
parameters[18].Value = model.hits;
parameters[19].Value = model.remark;
parameters[20].Value = model.EnterpriseName;; //ContactModel.Name;
parameters[21].Value = ContactModel.Name;
parameters[22].Value = ContactModel.Career;
parameters[23].Value = ContactModel.TelCountryCode;
parameters[24].Value = ContactModel.TelStateCode;
parameters[25].Value = ContactModel.TelNum;
parameters[26].Value = ContactModel.FaxCountryCode;
parameters[27].Value = ContactModel.FaxStateCode;
parameters[28].Value = ContactModel.FaxNum;
parameters[29].Value = ContactModel.Email;
parameters[30].Value = ContactModel.Mobile;
parameters[31].Value = ContactModel.address;
parameters[32].Value = ContactModel.PostCode;
parameters[33].Value = ContactModel.Website;
parameters[34].Value = ContactModel.IsDel;
parameters[35].Value = ContactModel.remark;
int rowsAffected;
int EnterpriseID;
using (SqlConnection sqlConn = DbHelperSQL.GetSqlConnection())
{
sqlConn.Open();
SqlTransaction sqlTran = sqlConn.BeginTransaction();
try
{
//插入信息
DbHelperSQL.RunProcedure(sqlConn, sqlTran, "UP_EnterpriseTab_Update", parameters, out rowsAffected);
if (rowsAffected > 0)
{
EnterpriseID = (int)parameters[0].Value;
}
else
{
EnterpriseID = 0;
}
Tz888.SQLServerDAL.Register.common obj2 = new common();
if (ContactManModels != null)
{
for (int i = 0; i < ContactManModels.Count; i++)
{
if (ContactManModels[i].Name != "" && ContactManModels[i].Name != null)
{
foreach (Tz888.Model.Register.OrgContactMan cm in ContactManModels)
{
// model.ContactID = ContactID;
if (!obj2.InsertContactMan(sqlConn, sqlTran, cm))
{
throw new Exception();
}
}
}
}
}
if (infoResourceModels != null)
{
//图片资源
Tz888.SQLServerDAL.MemberResourceDAL obj3 = new MemberResourceDAL();
foreach (Tz888.Model.MemberResourceModel modelRes in infoResourceModels)
{
modelRes.LoginName = model.LoginName;
int i = obj3.Add(sqlConn, sqlTran, modelRes);
}
}
sqlTran.Commit();
}
catch
{
sqlTran.Rollback();
EnterpriseID = -1;
}
finally
{
sqlConn.Close();
}
}
return(EnterpriseID);
}
protected void buSend_Click(object sender, ImageClickEventArgs e)
{
obj = new EnterpriseRegisterBLL();
mode = new EnterpriseInfoModel();
List <Tz888.Model.Common.IndustryModel> industryModels = new List <Tz888.Model.Common.IndustryModel>(); //行业实体列表
List <Tz888.Model.Register.OrgContactMan> ContactManModels = new List <Tz888.Model.Register.OrgContactMan>(); //联系人实体列表
Tz888.Model.Register.OrgContactModel ContactModel = new Tz888.Model.Register.OrgContactModel(); //创建信息联系方式主体
List <Tz888.Model.MemberResourceModel> infoResourceModels = new List <Tz888.Model.MemberResourceModel>(); //图片资料
mode.LoginName = this.ViewState["MemberLoginName"].ToString();
mode.EnterpriseName = tbEnterpriseName.Text;
mode.SetComTypeID = Convert.ToInt32(ddManageType.SelectedValue);
try
{
mode.RegisterDate = Convert.ToDateTime(tbRegisterDate.Text);
}
catch
{
Tz888.Common.MessageBox.Show(this.Page, "注册时间输入错误");
return;
}
mode.CountryCode = this.ZoneSelectControl1.CountryID;
mode.ProvinceID = this.ZoneSelectControl1.ProvinceID;
mode.CityID = this.ZoneSelectControl1.CityID;
mode.CountyID = this.ZoneSelectControl1.CountyID;
if (mode.ProvinceID == "" && mode.CountryCode.Trim() == "CN")
{
Tz888.Common.MessageBox.Show(this.Page, "请选取更详细的注册地址");
return;
}
industryModels = this.SelectIndustryControl1.IndustryModels;
if (industryModels == null)
{
Tz888.Common.MessageBox.Show(this.Page, "行业不能为空");
return;
}
foreach (Tz888.Model.Common.IndustryModel IM in industryModels)
{
mode.Industrylist += IM.IndustryBID + ",";
}
mode.currency = ddlCapitalCurrency.SelectedValue;//币种
try
{
mode.RegCapital = Convert.ToDecimal(tbRegCapital.Text);//注册资金
}
catch
{
Tz888.Common.MessageBox.Show(this.Page, "请正确输入注册资金！");
return;
}
#region 主营产品或服务
string MainProduct = "";
if (!string.IsNullOrEmpty(this.tbMainProduct1.Text.Trim()))
{
MainProduct += this.tbMainProduct1.Text.Trim() + ",";
}
if (!string.IsNullOrEmpty(this.tbMainProduct2.Text.Trim()))
{
MainProduct += this.tbMainProduct2.Text.Trim() + ",";
}
if (!string.IsNullOrEmpty(this.tbMainProduct3.Text.Trim()))
{
MainProduct += this.tbMainProduct3.Text.Trim() + ",";
}
mode.MainProduct = MainProduct;
#endregion
#region 读取意向
Tz888.BLL.Conn objReq = new Tz888.BLL.Conn();
string req = "";
DataTable dtReq = objReq.GetList("logininfotab", "RequirInfo", "LoginName", 1, 1, 0, 1, "LoginName='" + this.ViewState["MemberLoginName"].ToString() + "'");
if (dtReq != null)
{
req = dtReq.Rows[0]["RequirInfo"].ToString().Trim();
}
#endregion
mode.RequirInfo = req; //意向(从注册表里读取)
mode.AuditingStatus = 0; //审核状态
if (tbComAbout.Text.Length < 50 || tbComAbout.Text.Length > 2000)
{
Tz888.Common.MessageBox.Show(this.Page, "请输入50-2000的公司介绍信息！");
return;
}
mode.ComAbout = Tz888.Common.Utility.PageValidate.TxtToHtml(tbComAbout.Text);//公司介绍
mode.ComAboutBrief = "";
mode.ExhibitionHall = tbExhibitionHall.Text; //展厅tbExhibitionHall
mode.hits = 0; //点击数
mode.remark = "";
ContactModel = this.OrgContactControl1.OrgContact; //联系信息
ContactManModels = this.OrgContactControl1.ContactMans; //联系人
if (ContactModel.Name.Trim() == "" && ContactModel.TelNum.Trim() == "" && ContactModel.Mobile.Trim() == "")
{
Tz888.Common.MessageBox.Show(this.Page, "请输入完整的联系信息！");
return;
}
//将已上传的图片从临时目录迁移到正式目录
//infoResourceModels = Tz888.Common.InfoResourceManage.MemberImageTransfer("Image", "EnterpriseRegister", Tz888.Common.ResourceType.Image, Tz888.Common.MemberResourceProperty.RP0, ImageUploadControl1.InfoList);
infoResourceModels = ImageUploadControl1.InfoList;
////展厅
//if (this.ViewState["WebInfo"].ToString() == "1")
//{
// bool IsVip = false;
// if (Page.User.IsInRole("GT1002")) IsVip = true;
// SelfCreateWeb.Model.DatabaseOperationStatus dos = new SelfCreateWeb.BLL.BSelfCreateWebInfo().AddSelfCreateWebInfo(new SelfCreateWeb.Model.MSelfCreateWebInfo(0, this.ViewState["MemberLoginName"].ToString(), "", 0, tbExhibitionHall.Text.Trim(), DateTime.Now, DateTime.Now), new SelfCreateWeb.ParameterMap.PSelfCreateWebInfo(false, true, false, false, true, false, false));
// if (dos == SelfCreateWeb.Model.DatabaseOperationStatus.Success)
// {
// new SelfCreateWeb.BLL.BSelfCreateWebInfo().InitPageParameter(this.ViewState["MemberLoginName"].ToString(), IsVip, false);
// }
// else
// {
// Tz888.Common.MessageBox.Show(this.Page, "此域名不可用，请重新输入！");
// return;
// }
//}
//信息
int EnterpriseId = Convert.ToInt32(this.ViewState["EnterpriseID"]);
int type = 0;
//if (Page.User.IsInRole("GT1001")) //普通会员
// type = 0;
//else
type = 1;
if (EnterpriseId == 0)
{
int rv = obj.EnterpriseAdd(mode, ContactModel, ContactManModels, infoResourceModels);
if (rv > 0)
{
Response.Redirect("OrgRegisterSucceed.aspx?type=" + type + "®=Ent_Add&web=" + tbExhibitionHall.Text + ".co.");
// string para="type=" + type + "®=Ent_Add&web=" + tbExhibitionHall.Text + ".co.";
// Response.Redirect("EnterpriseRegister_additive.aspx?reg=Ent_Add&web=" + tbExhibitionHall.Text + ".co.");
}
}
else
{
mode.EnterpriseID = EnterpriseId;
int rv = obj.EnterpriseUpdate(mode, ContactModel, ContactManModels, infoResourceModels);
Response.Redirect("OrgRegisterSucceed.aspx?type=" + type + "®=Ent_Update&web=" + tbExhibitionHall.Text + ".co.");
// string para ="type=" + type + "®=Ent_Update&web=" + tbExhibitionHall.Text + ".co.";
// Response.Redirect("EnterpriseRegister_additive.aspx?reg=Ent_Update&web=" + tbExhibitionHall.Text + ".co.");
}
}
