/// <summary>
/// 获取JQGrid动态列名
/// </summary>
/// <returns></returns>
public ActionResult GetGridRows()
{
List <object> obj = new List <object>();
//获取商品类别List
GoodstypeBLL goodstypebll = new GoodstypeBLL();
List <GoodstypeEntity> goodList = goodstypebll.GetListJson("0").ToList();
DataTable dt = new DataTable();
if (goodList != null && goodList.Count > 0)
{
//1、固定列名
dt.Columns.Add("部门");//部门
//2、动态创建列名
foreach (var item in goodList)
{
dt.Columns.Add(item.ftypename);
}
//3、固定列名
dt.Columns.Add("小计");//小计
for (int i = 0; i < dt.Columns.Count; i++)
{
var colm = new
{
label = dt.Columns[i].ColumnName,
name = dt.Columns[i].ColumnName,
align = "center",
sortable = false
};
obj.Add(colm);
}
}
return(ToJsonResult(obj));
}
public ActionResult GetListJson(string fparentcode)
{
var data = goodstypebll.GetListJson(fparentcode);
var treeList = new List <TreeEntity>();
foreach (GoodstypeEntity item in data)
{
TreeEntity tree = new TreeEntity();
bool hasChildren = false;//data.Count(t => t.ParentId == item.ItemDetailId) == 0 ? false : true;
tree.id = item.ftypecode;
tree.text = item.ftypename;
tree.value = item.ftypecode;
tree.parentId = "0";
tree.isexpand = true;
tree.complete = true;
tree.hasChildren = hasChildren;
treeList.Add(tree);
}
return(Content(treeList.TreeToJson()));
}
public ActionResult GetReceiveCostJson(string queryJson)
{
var queryParam = queryJson.ToJObject();
GoodstypeBLL goodstypebll = new GoodstypeBLL();
//获取商品类别List
List <GoodstypeEntity> goodList = goodstypebll.GetListJson("0").ToList();
DataTable dt = new DataTable();
List <object> obj = new List <object>();
if (goodList != null && goodList.Count > 0)
{
#region 1、创建列名
//1、固定列名
dt.Columns.Add("部门");//部门
//2、动态创建列名
foreach (var item in goodList)
{
dt.Columns.Add(item.ftypename);
}
//3、固定列名
dt.Columns.Add("小计");//小计
#endregion 1、创建列名
#region 2、添加行数据
//获取部门
HrDepartmentCache hrDepartmentCache = new HrDepartmentCache();
List <HrDepartmentEntity> departList = hrDepartmentCache.GetList().ToList();
//获取费用列表
List <ReceiveCostModel> list = outbillitembll.GetReceiveCostList().ToList();
List <ReceiveCostModel> costList = null;
DataRow dr = dt.NewRow();
//查询条件 领用时间
DateTime?startDate = null;
DateTime?endDate = null;
if (!queryParam["StartDate"].IsEmpty())
{
startDate = Convert.ToDateTime(queryParam["StartDate"]);
}
if (!queryParam["EndDate"].IsEmpty())
{
endDate = Convert.ToDateTime(queryParam["EndDate"]);
}
if (departList != null && departList.Count > 0 && list != null && list.Count > 0)
{
foreach (var dep in departList)
{
dr = dt.NewRow();
dr["部门"] = dep.deptname;
decimal amount = 0;
decimal money = 0;
foreach (var li in goodList)
{
costList = list.FindAll(o => o.fgoodsid == li.frootid && o.fdeptid == dep.deptid).ToList();
if (startDate != null)
{
costList = costList.FindAll(o => o.foutdate >= startDate).ToList();
}
if (endDate != null)
{
costList = costList.FindAll(o => o.foutdate <= endDate).ToList();
}
money = costList.Sum(o => o.fmoney);
dr[li.ftypename] = money.ToString("F");
amount += money;
}
dr["小计"] = amount.ToString("F");
dt.Rows.Add(dr);
}
}
#endregion 2、添加行数据
}
return(ToJsonResult(dt));
}