public bool Update(CsDistrict model)
{
var strSql = new StringBuilder();
strSql.Append("UPDATE CrabShop.dbo.[CsDistrict] SET ");
strSql.Append("Name = @Name,ParentId = @ParentId,Code = @Code,Sort = @Sort,FirstPrice = @FirstPrice,FllowPrice = @FllowPrice");
strSql.Append(" WHERE Id = @Id");
return(DbClient.Excute(strSql.ToString(), model) > 0);
}
public int Add(CsDistrict model)
{
var strSql = new StringBuilder();
strSql.Append("INSERT INTO CrabShop.dbo.[CsDistrict] (");
strSql.Append("Name,ParentId,Code,Sort,FirstPrice,FllowPrice");
strSql.Append(") VALUES (");
strSql.Append("@Name,@ParentId,@Code,@Sort,@FirstPrice,@FllowPrice);");
strSql.Append("SELECT @@IDENTITY");
return(DbClient.ExecuteScalar <int>(strSql.ToString(), model));
}
public IHttpActionResult GetAddress(string openId)
{
CsUsers user = _csUsersBll.GetModel(openId);
if (user != null)
{
//根据userId查询出发件信息和收获地址信息
List <CsSend> sendList = _csSendBll.GetModelList(" and UserId=" + user.UserId).OrderBy(x => x.IsDefault).ThenBy(x => x.SendId).ToList();
List <CsAddress> addressList = _csAddressBll.GetModelList(" and UserId=" + user.UserId + " and AddressState=1 ").OrderBy(x => x.IsDefault).ThenBy(x => x.AddressId).ToList();
CsDistrictBll disBLL = new CsDistrictBll();
int firstPrice = 0, fllowPrice = 0;
if (addressList.Count > 0)
{
string province = addressList[0].Details.Split('&')[0];
CsDistrict district = disBLL.GetModel(" Name ='" + province + "'");
if (district != null)
{
firstPrice = district.FirstPrice;
fllowPrice = district.FllowPrice;
}
}
return(Json(new
{
status = true,
user,
sendList,
addressList,
firstPrice,
fllowPrice
}));
}
LogHelper.Log("public IHttpActionResult GetAddress-------openId:" + openId, "openId 未能查询到用户信息");
return(Json(new
{
status = false,
user = "",
sendList = "",
addressList = "",
firstPrice = 0,
fllowPrice = 0
}));
}