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