/// <summary>
/// 申请企业信息修改
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int AddCompanyApplyUpdate(CompanyApplyUpdateModel model)
{
const string sql = @"INSERT INTO settled_info_applyupdate(innerid, settid, contactmobile,pictures, companyname, address, opername, originalregistcapi, scope, companystatus, officephone, picurl, companytitle, ancestryids, categoryids, customdesc, boutiqueurl,introduction,status, contactsphone,remark,spare1, spare2, createrid, createdtime, modifierid, modifiedtime)
VALUES (@innerid, @settid, @contactmobile, @pictures, @companyname, @address, @opername, @originalregistcapi, @scope, @companystatus, @officephone, @picurl, @companytitle, @ancestryids, @categoryids, @customdesc, @boutiqueurl,@introduction,2,@contactsphone,@remark, @spare1, @spare2, @createrid, now(), @modifierid, @modifiedtime);";
using (var conn = Helper.GetConnection())
{
try
{
conn.Execute(sql, model);
return 1;
}
catch (Exception ex)
{
return 0;
}
}
}
/// <summary>
/// 更新申请表状态
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int UpdateApplyStatus(CompanyApplyUpdateModel model)
{
const string sql = @"update settled_info_applyupdate set status=@status,remark=@remark,modifierid=@modifierid,modifiedtime=now() where innerid=@innerid;";
using (var conn = Helper.GetConnection())
{
try
{
conn.Execute(sql, model);
return 1;
}
catch (Exception ex)
{
return 0;
}
}
}
