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));
}
