public int AuditOrg(Tz888.Model.Register.OrgAuditModel model) { int rowsAffected; SqlParameter[] parameters = { new SqlParameter("@OrgAudID", SqlDbType.BigInt, 8), new SqlParameter("@OrgName", SqlDbType.VarChar, 200), 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), new SqlParameter("@Memo", SqlDbType.VarChar, 200) }; parameters[0].Value = model.OrgAudID; parameters[1].Value = model.OrgName; parameters[2].Value = model.LoginName; parameters[3].Value = model.AuditingRemark; parameters[4].Value = model.AuditingBy; parameters[5].Value = model.AuditingDate; parameters[6].Value = model.FeedbackStatus; parameters[7].Value = model.FeedBackNote; parameters[8].Value = model.OrgType; parameters[9].Value = model.Memo; DbHelperSQL.RunProcedure("UP_OrgAuditTab_Audit", parameters, out rowsAffected); return(rowsAffected); }
//审核 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 AuditOrg(Tz888.Model.Register.OrgAuditModel model) { return(dal.AuditOrg(model)); }