//修改 public int GovernmentUpdate(Tz888.Model.Register.GovernmentInfoModel model, Tz888.Model.Register.OrgContactModel ContactModel, List <Tz888.Model.Register.OrgContactMan> ContactManModels, List <Tz888.Model.MemberResourceModel> infoResourceModels) { return(dal.GovernmentUpdate(model, ContactModel, ContactManModels, infoResourceModels)); }
//修改 public int GovernmentUpdate(Tz888.Model.Register.GovernmentInfoModel model, Tz888.Model.Register.OrgContactModel ContactModel, List <Tz888.Model.Register.OrgContactMan> ContactManModels, List <Tz888.Model.MemberResourceModel> infoResourceModels) { SqlParameter[] parameters = { #region 基本信息 new SqlParameter("@GovernmentID", SqlDbType.Int, 4), new SqlParameter("@LoginName", SqlDbType.Char, 16), new SqlParameter("@GovernmentName", SqlDbType.VarChar, 200), new SqlParameter("@GovAbout", SqlDbType.VarChar, -1), new SqlParameter("@GovAboutBrief", SqlDbType.VarChar, -1), new SqlParameter("@SubjectType", SqlDbType.Char, 10), 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("@AuditingStatus", SqlDbType.TinyInt, 1), new SqlParameter("@hits", SqlDbType.Int, 4), new SqlParameter("@ExhibitionHall", 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, 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("@Website", SqlDbType.VarChar, 200), new SqlParameter("@IsDel", SqlDbType.Bit, 1), new SqlParameter("@remark1", SqlDbType.VarChar, 100) #endregion }; parameters[0].Value = model.GovernmentID; parameters[1].Value = model.LoginName; parameters[2].Value = model.GovernmentName; parameters[3].Value = model.GovAbout; parameters[4].Value = model.GovAboutBrief; parameters[5].Value = model.SubjectType; parameters[6].Value = model.CountryCode; parameters[7].Value = model.ProvinceID; parameters[8].Value = model.CityID; parameters[9].Value = model.CountyID; parameters[10].Value = model.AuditingStatus; parameters[11].Value = model.Hits; parameters[12].Value = model.ExhibitionHall; parameters[13].Value = model.remark; parameters[14].Value = model.GovernmentName; parameters[15].Value = ContactModel.Name; parameters[16].Value = ContactModel.Career; parameters[17].Value = ContactModel.TelCountryCode; parameters[18].Value = ContactModel.TelStateCode; parameters[19].Value = ContactModel.TelNum; parameters[20].Value = ContactModel.FaxCountryCode; parameters[21].Value = ContactModel.FaxStateCode; parameters[22].Value = ContactModel.FaxNum; parameters[23].Value = ContactModel.Email; parameters[24].Value = ContactModel.Mobile; parameters[25].Value = ContactModel.address; parameters[26].Value = ContactModel.PostCode; parameters[27].Value = ContactModel.Website; parameters[28].Value = ContactModel.IsDel; parameters[29].Value = ContactModel.remark; int rowsAffected; int GovernmentID; using (SqlConnection sqlConn = DbHelperSQL.GetSqlConnection()) { sqlConn.Open(); SqlTransaction sqlTran = sqlConn.BeginTransaction(); try { //插入信息 DbHelperSQL.RunProcedure(sqlConn, sqlTran, "UP_GovernmentTab_Update", parameters, out rowsAffected); if (rowsAffected > 0) { GovernmentID = (int)parameters[0].Value; } else { GovernmentID = 0; } //添加多个联系人(检查原联系人列表中是否己存在 LoginName = model.LoginName的联系人, //如果己存就,将先删除全部后重新添加,obj2.InsertContactMan代码逻辑中) 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) { 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(); GovernmentID = -1; } finally { sqlConn.Close(); } } return(GovernmentID); }
protected void buSend_Click(object sender, ImageClickEventArgs e) { if (!Page.IsValid) { return; } obj = new GovernmentRegisterBLL(); mode = new GovernmentInfoModel(); 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 = Page.User.Identity.Name; mode.GovernmentName = tbGovernmentName.Text; mode.GovAbout = Tz888.Common.Utility.PageValidate.TxtToHtml(tbGovAbout.Text);//公司介绍 mode.GovAboutBrief = ""; mode.SubjectType = ddlSubjectType.SelectedValue; mode.CountryCode = this.ZoneSelectControl1.CountryID; mode.ProvinceID = this.ZoneSelectControl1.ProvinceID; mode.CityID = this.ZoneSelectControl1.CityID; mode.CountyID = this.ZoneSelectControl1.CountyID; mode.AuditingStatus = 0;//审核状态 //if (mode.ProvinceID == "" && mode.CountryCode.Trim() == "CN") //{ // Tz888.Common.MessageBox.Show(this.Page, "请选取更详细的注册地址"); // return; //} mode.ExhibitionHall = tbExhibitionHall.Text; //展厅 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", "GovernmentRegister", 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, Page.User.Identity.Name, "", 0, tbExhibitionHall.Text.Trim(), DateTime.Now, DateTime.Now, 0, ""), new SelfCreateWeb.ParameterMap.PSelfCreateWebInfo(false, true, false, false, true, false, false, false, false)); if (dos == SelfCreateWeb.Model.DatabaseOperationStatus.Success) { new SelfCreateWeb.BLL.BSelfCreateWebInfo().InitPageParameter(Page.User.Identity.Name, IsVip, true); } else { Tz888.Common.MessageBox.Show(this.Page, "此域名不可用,请重新输入!"); return; } } int type = 0; if (Page.User.IsInRole("GT1001")) //普通会员 { type = 0; } else { type = 1; } int GovernmentId = Convert.ToInt32(ViewState["GovermentID"].ToString()); if (GovernmentId == 0) { int rv = obj.GovernmentAdd(mode, ContactModel, ContactManModels, infoResourceModels); if (rv > 0) { Response.Redirect("OrgRegisterSucceed.aspx?type=" + type + "®=Gov_Add&web=" + tbExhibitionHall.Text + ".gov."); } else { Tz888.Common.MessageBox.Show(this.Page, "此域名不可用,请重新输入!"); return; } } else { mode.GovernmentID = GovernmentId; int rv = obj.GovernmentUpdate(mode, ContactModel, ContactManModels, infoResourceModels); Response.Redirect("OrgRegisterSucceed.aspx?type=" + type + "®=Gov_Update&web=" + tbExhibitionHall.Text + ".gov."); } }