public IActionResult GetArea()
{
try
{
SugarHandler db = new SugarHandler();
return(new JsonResult(db.Queryable <retail_area>().OrderBy(x => x.CityId).ToList()));
}
catch (SqlSugar.SqlSugarException ex)
{
return(Problem(ex.Message));
}
}
public IActionResult GetCity()
{
try
{
SugarHandler db = new SugarHandler();
return(Ok(db.Queryable <retail_city>().OrderBy(x => x.ProvinceId).ToList()));
}
catch (SqlSugar.SqlSugarException ex)
{
return(Problem(ex.Message));
}
}
public IActionResult GetUnit()
{
var companyId = Request.Headers["CompanyId"].ObjToInt();
try
{
SugarHandler db = new SugarHandler();
var units = db.Queryable <retail_unit, retail_ref_company_unit>((t1, t2) => new object[] { JoinType.Inner, t1.Id == t2.UnitId }).Where((t1, t2) => t2.CompanyId == companyId).ToList();
return(Ok(units));
}
catch (SqlSugar.SqlSugarException ex)
{
return(Problem(ex.Message));
}
}
public IActionResult GetProductSizeInfo()
{
var companyId = Request.Headers["CompanyId"].ToString().ToInt();
try
{
SugarHandler db = new SugarHandler();
var products = db.Queryable <retail_product_size, retail_product, retail_ref_company_product>((t1, t2, t3) => new object[] { JoinType.Inner, t1.ProductId == t2.Id, JoinType.Inner, t2.Id == t3.ProductId }).Where((t1, t2, t3) => (t3.CompanyId == companyId && t2.Status == 1)).ToList();
return(Ok(products));
}
catch (SqlSugarException ex)
{
return(Problem(ex.Message));
}
}
public IActionResult GetCustom()
{
var companyId = Request.Headers["CompanyId"].ObjToInt();
var companyPid = Request.Headers["CompanyPid"].ObjToInt();
try
{
SugarHandler db = new SugarHandler();
var customs = db.Queryable <retail_custom, retail_ref_company_custom>((t1, t2) => new object[] { JoinType.Inner, t1.Id == t2.CustomId }).Where((t1, t2) => t2.CompanyId == companyId && t1.CompanyPid == companyPid && t1.Status == 1).ToList();
return(Ok(customs));
}
catch (SqlSugar.SqlSugarException ex)
{
return(Problem(ex.Message));
}
}