public ActionResult GetGridJson(Pagination pagination, string keyword)
{
var newsTypeList = fileApp.GetList();
var listResult = (from a in fileApp.GetList(pagination, keyword)
join b in userApp.GetList() on a.F_UploadUser equals b.F_Id into team
from c in team.DefaultIfEmpty()
select new FileEntity()
{
F_FileMax = a.F_FileMax,
F_Id = a.F_Id,
F_FileName = a.F_FileName,
F_FileVersion = a.F_FileVersion,
F_UploadDate = a.F_UploadDate,
F_UploadUser = c.F_RealName
}).ToList();
var data = new
{
rows = listResult,
total = pagination.total,
page = pagination.page,
records = pagination.records
};
return(Content(data.ToJson()));
}
public ActionResult GetBanerListJson()
{
List <object> baners = new List <object>();
FileApp fileApp = new FileApp();
var data = fileApp.GetList("baner");
foreach (var item in data)
{
baners.Add(new { name = item.FileName, base64 = item.FileContent });
}
return(Content(baners.ToJson()));
}
public ActionResult GetInventory(string f_Id, string longitude, string latitude)
{
string strSql = @"select a.Id,a.WareId,a.WareName,d.Address,d.Longitude,d.Latitude,Distince=6378137.0*acos(sin(cast('" + latitude + "' as decimal(18,6))/180*pi())*sin(Latitude/180*pi())+cos(cast('" + latitude + "' as decimal(18,6))/180*pi())*cos(Latitude/180*pi())*cos((cast('" + longitude + "' as decimal(18,6))-Longitude)/180*pi())),a.OrderNo,c.ProductName as ProductType,(select F_ItemName from View_ItemType_ItemDetail where F_EnCode='0202' and F_ItemCode=a.Grade) as Grade,a.Strength,(select F_ItemName from View_ItemType_ItemDetail where F_EnCode='0208' and F_ItemCode=a.Length) as Length,(select F_ItemName from View_ItemType_ItemDetail where F_EnCode='0203' and F_ItemCode=a.HorseValue) as HorseValue,(select F_ItemName from View_ItemType_ItemDetail where F_EnCode='0207' and F_ItemCode=a.Status) as Status,(select F_ItemName from View_ItemType_ItemDetail where F_EnCode='0206' and F_ItemCode=a.QuoteType) as QuoteType,(case when a.QuoteType<>'Futures' then a.Price else null end) as Price,(case when a.QuoteType<>'Futures' then null else a.Contract end) as Contract,(case when a.QuoteType<>'Futures' then null else cast(b.Price as decimal(18,2)) end) as ContractPrice,(case when a.QuoteType<>'Futures' then null else cast(a.Basis+b.Price as decimal(18,2)) end) as TotalPrice,(case when a.QuoteType<>'Futures' then null else Basis end) as Basis,a.Year,a.SailingSchedule,(a.Weight-isnull((select sum(Weight) from InventoryOut where InventoryId=a.Id),0)) as Weight,a.Description from Inventory a left join Contract b on a.Contract=b.ContractCode left join Product c on c.ProductCode=a.ProductType inner join WareHouse d on a.WareId=d.Id where a.Id='" + f_Id + "'";
DataView dv = DbHelper.ExecuteToDataView(strSql);
FileApp fileApp = new FileApp();
var files = fileApp.GetList(f_Id);
List <object> img = new List <object>();
foreach (FileEntity file in files)
{
//img.Add(new { base64 = file.FileContent });
if (!string.IsNullOrEmpty(file.FilePath))
{
img.Add(new { base64 = file.FilePath.Replace("\\", "/") });
}
}
object obj = new object();
obj = new
{
f_Id = Convert.ToString(dv[0]["Id"]),
wareId = Convert.ToString(dv[0]["WareId"]),
wareName = Convert.ToString(dv[0]["WareName"]),
address = Convert.ToString(dv[0]["Address"]),
distance = (Convert.ToDouble(dv[0]["Distince"]) / 1000).ToString("#0.00"),
longitude = Convert.ToDouble(dv[0]["Longitude"]),
latitude = Convert.ToDouble(dv[0]["Latitude"]),
orderNo = Convert.ToString(dv[0]["OrderNo"]),
productType = Convert.ToString(dv[0]["ProductType"]),
grade = Convert.ToString(dv[0]["Grade"]),
strength = Convert.ToString(dv[0]["Strength"]),
length = Convert.ToString(dv[0]["Length"]),
horseValue = Convert.ToString(dv[0]["HorseValue"]),
status = Convert.ToString(dv[0]["Status"]),
quoteType = Convert.ToString(dv[0]["QuoteType"]),
price = Convert.ToString(dv[0]["Price"]),
contract = Convert.ToString(dv[0]["Contract"]),
contractPrice = Convert.ToString(dv[0]["ContractPrice"]),
totalPrice = Convert.ToString(dv[0]["TotalPrice"]),
basis = Convert.ToString(dv[0]["Basis"]),
year = Convert.ToString(dv[0]["Year"]),
sailingSchedule = Convert.ToString(dv[0]["SailingSchedule"]),
weight = Convert.ToString(dv[0]["Weight"]),
description = Convert.ToString(dv[0]["Description"]),
imgList = img
};
return(Content(obj.ToJson()));
}
public ActionResult GetBanerListJson()
{
List <object> baners = new List <object>();
FileApp fileApp = new FileApp();
var data = fileApp.GetList("baner");
foreach (var item in data)
{
//baners.Add(new { name = item.FileName, base64 = item.FileContent });
if (!string.IsNullOrEmpty(item.FilePath))
{
baners.Add(new { name = item.FileName, base64 = item.FilePath.Replace("\\", "/") });
}
}
return(Content(baners.ToJson()));
}
public ActionResult GetInventoryListJson(InventoryReq inventoryReq)
{
//sql
string strSql = @"
select
a.Id,
WareName,
OrderNo,
c.ProductName as ProductType,
c.ImgContent as ProductImg,
(select F_ItemName from View_ItemType_ItemDetail where F_EnCode='0202' and F_ItemCode=a.Grade) as Grade,
Strength,
(select F_ItemName from View_ItemType_ItemDetail where F_EnCode='0208' and F_ItemCode=a.Length) as Length,
(select F_ItemName from View_ItemType_ItemDetail where F_EnCode='0203' and F_ItemCode=a.HorseValue) as HorseValue,
(select F_ItemName from View_ItemType_ItemDetail where F_EnCode='0207' and F_ItemCode=a.Status) as Status,
(select F_ItemName from View_ItemType_ItemDetail where F_EnCode='0206' and F_ItemCode=a.QuoteType) as QuoteType,
(case when a.QuoteType<>'Futures' then a.Price else null end) as Price,
(case when a.QuoteType<>'Futures' then null else a.Contract end) as Contract,
(case when a.QuoteType<>'Futures' then null else cast(b.Price as decimal(18,2)) end) as ContractPrice,
(case when a.QuoteType<>'Futures' then null else cast(a.Basis+b.Price as decimal(18,2)) end) as TotalPrice,
(case when a.QuoteType<>'Futures' then null else Basis end) as Basis,
Year,
SailingSchedule,
(Weight-isnull((select sum(Weight) from InventoryOut where InventoryId=a.Id),0)) as Weight,
IsRecommend,
b.FS,b.M,b.S,b.C,b.V
from Inventory a
left join Contract b on a.Contract=b.ContractCode
left join Product c on c.ProductCode=a.ProductType
where 1=1 ";
//where
string strQry = "";
if (inventoryReq.inventoryQry != null)
{
InventoryQry[] inventoryQrys = inventoryReq.inventoryQry;
foreach (InventoryQry inventoryQry in inventoryQrys)
{
if (inventoryQry.code.ToLower() == "strength")//强力是范围，其他都是选项
{
foreach (List selected in inventoryQry.list)
{
if (selected.name.ToLower() == "min")
{
strQry += " and cast(Strength as float)>=" + selected.code + " ";
}
else if (selected.name.ToLower() == "max")
{
strQry += " and cast(Strength as float)<=" + selected.code + " ";
}
}
}
else if (inventoryQry.code.ToLower() == "producttype")//分类中，其他是除美棉/澳棉/巴西棉/印度棉以外的所有
{
string condition = "";
foreach (List selected in inventoryQry.list)
{
if (selected.code.ToLower() != "qt")
{
if (selected.selected)
{
condition += "'" + selected.code + "',";
}
}
else
{
if (selected.selected)
{
DataView dvQT = DbHelper.ExecuteToDataView("select ProductCode from Product where ProductCode not in ('mm','bxm','ydm','om')");
foreach (DataRowView drv in dvQT)
{
condition += "'" + drv["ProductCode"] + "',";
}
}
}
}
if (!string.IsNullOrEmpty(condition))
{
strQry += " and " + inventoryQry.code + " in (" + condition.Trim(',') + ") ";
}
}
else
{
string condition = "";
foreach (List selected in inventoryQry.list)
{
if (selected.selected)
{
condition += "'" + selected.code + "',";
}
}
if (!string.IsNullOrEmpty(condition))
{
strQry += " and " + inventoryQry.code + " in (" + condition.Trim(',') + ") ";
}
}
}
}
//order
string strOrder = " order by IsRecommend desc,a.CreatorTime desc ";
//paging
Pagination pagination = inventoryReq.pagination;
string strPaging = " offset " + (pagination.page - 1) * pagination.rows + " rows fetch next " + pagination.rows + " rows only";
DataView dvInventory = DbHelper.ExecuteToDataView(strSql + strQry + strOrder + strPaging);
List <object> inventorys = new List <object>();
foreach (DataRowView drv in dvInventory)
{
FileApp fileApp = new FileApp();
var files = fileApp.GetList(Convert.ToString(drv["Id"]));
List <object> img = new List <object>();
foreach (FileEntity file in files)
{
//baer64改成url，参数名不变了
//img.Add(new { base64 = file.FileContent });
if (!string.IsNullOrEmpty(file.FilePath))
{
img.Add(new { base64 = file.FilePath.Replace("\\", "/") });
}
}
inventorys.Add(new
{
f_Id = Convert.ToString(drv["Id"]),
wareName = Convert.ToString(drv["WareName"]),
orderNo = Convert.ToString(drv["OrderNo"]),
productType = Convert.ToString(drv["ProductType"]),
productImg = Convert.ToString(drv["ProductImg"]),
grade = Convert.ToString(drv["Grade"]),
strength = Convert.ToString(drv["Strength"]),
length = Convert.ToString(drv["Length"]),
horseValue = Convert.ToString(drv["HorseValue"]),
status = Convert.ToString(drv["Status"]),
quoteType = Convert.ToString(drv["QuoteType"]),
price = Convert.ToString(drv["Price"]),
contract = Convert.ToString(drv["Contract"]),
contractPrice = Convert.ToString(drv["ContractPrice"]),
basis = Convert.ToString(drv["Basis"]),
totalPrice = Convert.ToString(drv["TotalPrice"]),
year = Convert.ToString(drv["Year"]),
sailingSchedule = Convert.ToString(drv["SailingSchedule"]),
weight = Convert.ToString(drv["Weight"]),
isRecommend = Convert.ToString(drv["IsRecommend"]),
fs = Convert.ToString(drv["FS"]),
m = Convert.ToString(drv["M"]),
s = Convert.ToString(drv["S"]),
c = Convert.ToString(drv["C"]),
v = Convert.ToString(drv["V"]),
imgList = img
});
}
return(Content(inventorys.ToJson()));
}
public ActionResult GetListJson(string related_Id)
{
var data = fileApp.GetList(related_Id);
return(Content(data.ToJson()));
}