예제 #1
0
        public AlipayInfoModel GetAlipayInfoModel(int id)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append(" select top 1 [id],[accId],dbo.GetAccountName(accId) accountName,[status],[companyType],[createTime],[modifiedTime],[completeTime],[artificialPerson],[phone],[alipayAccount],[companyName],[industryClassification],[businessArea],[shopOutPhotoURL],[shopInPhotoURL],[businessLicensePhotoURL],[doorPhotoURL],[firstShopWorkPhotoURL],[secondShopWorkPhotoURL],[thirdShopWorkPhotoURL],[companyAddress],[PID],[Key],[remark] ");
            strSql.Append(" from T_AlipayInfo ");
            strSql.Append(" where id=@id");
            return(HelperForFrontend.GetModel <AlipayInfoModel>(strSql.ToString(), new { id = id }));
        }