public bool SaveUserCompany(string mobile, UserCompanyInfoVM company)
{
using (var ctx = new ShtxSms2008Entities())
{
try
{
var cb = ctx.CustomerBases.FirstOrDefault(o => o.SendInterFace == 102 && o.Tel.Contains(mobile));
if (cb != null)
{
cb.AppAddressDesc = company.AppAddressDesc;
cb.AppBusinessDesc = company.AppBusinessDesc;
cb.AppCity = company.AppCity;
cb.AppCompanyName = company.AppCompanyName;
cb.AppCompanyPics = company.AppCompanyPics;
cb.AppCustomerName = company.AppCustomerName;
cb.AppIndustry = company.AppIndustry;
cb.AppProduct = company.AppProduct;
cb.AppProvince = company.AppProvince;
cb.IsOpenMsg = company.IsOpenMsg;
cb.AppTel = company.AppTel;
ctx.SaveChanges();
return(true);
}
else
{
return(false);
}
}
catch (Exception)
{
return(false);
}
}
}
public List <UserCompanyInfoVM> getUserCompanyInfo(int id)
{
List <UserCompanyInfoVM> list = new List <UserCompanyInfoVM>();
using (var ctx = new ShtxSms2008Entities())
{
var cbs = ctx.CustomerBases.Where(o => o.IsOpenMsg.Value && o.CustomerID > id).OrderBy(o => o.CustomerID).Take(30).ToList();
foreach (var cb in cbs)
{
var vm = new UserCompanyInfoVM();
vm.AppAddressDesc = cb.AppAddressDesc;
vm.AppBusinessDesc = cb.AppBusinessDesc;
vm.AppCity = cb.AppCity;
vm.AppCompanyName = cb.AppCompanyName;
vm.AppCompanyPics = cb.AppCompanyPics;
vm.AppCustomerName = cb.AppCustomerName;
vm.AppIndustry = cb.AppIndustry;
vm.AppProduct = cb.AppProduct;
vm.AppProvince = cb.AppProvince;
vm.AppTel = cb.AppTel;
vm.Id = cb.CustomerID;
list.Add(vm);
}
}
return(list);
}
