/// <summary>
/// 物料是否是首页标记
/// </summary>
/// <param name="materialId"></param>
/// <returns></returns>
public void GetMaterialInfo(Context ctx, ref FInStockEntry entry)
{
if (entry != null && !string.IsNullOrWhiteSpace(entry.FMaterialId))
{
string sql = string.Format(@"/*dialect*/ select c.FNUMBER as F_HS_ListID,a.FNumber as FMaterialId,a.F_HS_YNHomePageMarkup
from T_BD_MATERIAL a
inner join HS_T_BD_LISTID c on c.FID = a.F_HS_ListIDNew
inner join HS_T_BD_LISTID_L d on d.FID = c.FID
inner join T_ORG_ORGANIZATIONS e on a.FUSEORGID=e.FORGID
where a.FNUMBER = '{0}'
and e.FNUMBER = '100' ", entry.FMaterialId);
DynamicObjectCollection coll = SQLUtils.GetObjects(ctx, sql);
if (coll != null && coll.Count > 0)
{
foreach (var item in coll)
{
if (item != null)
{
entry.F_HS_ListID = SQLUtils.GetFieldValue(item, "F_HS_ListID");
}
}
}
}
}
/// <summary>
/// 采购入库单.明细信息
/// </summary>
/// <param name="ctx"></param>
/// <param name="obj"></param>
/// <returns></returns>
public List <FInStockEntry> GetStockEntry(Context ctx, DynamicObject obj)
{
List <FInStockEntry> entries = null;
FInStockEntry entry = null;
if (obj != null)
{
DynamicObjectCollection coll = obj["InStockEntry"] as DynamicObjectCollection;
if (coll != null && coll.Count > 0)
{
entries = new List <FInStockEntry>();
foreach (var item in coll)
{
if (item != null)
{
entry = new FInStockEntry();
DynamicObject mat = item["MaterialId"] as DynamicObject;
entry.FMaterialId = SQLUtils.GetFieldValue(mat, "Number");
entry.SrcNo = entry.FMaterialId;
entry.FApproveDate = SQLUtils.GetFieldValue(obj, "ApproveDate");
GetMaterialInfo(ctx, ref entry);
entries.Add(entry);
}
}
}
}
return(entries);
}
