public void bind()
{
try
{
using (workflow.Components.Inventory cs = new workflow.Components.Inventory())
{
dsInvID = cs.GetData("Usp_GetHOQCInventoryID");
}
var VardvHOQC = ((DataSet)Session["dsHOQC"]).Tables[0].AsEnumerable();
var VardsInvID = dsInvID.Tables[0].AsEnumerable();
try
{
(from hoqc in VardvHOQC
join inv in VardsInvID
on hoqc.Field<int?>("ProductId") equals inv.Field<int?>("InvIntPrdId")
where hoqc.Field<int?>("Size") == inv.Field<int?>("InvVarGenIDSize")
&& hoqc.Field<int?>("Color") == inv.Field<int?>("InvVarGenIDColor")
&& (hoqc.Field<int>("WHID") == 1 || hoqc.Field<int>("WHID") == 2 || hoqc.Field<int>("WHID") == 30 || hoqc.Field<int>("WHID") == 34)
select new
{
h = hoqc
}).Distinct().ToList().ForEach(z => z.h.SetField("WfIDYesorNo", "1"));
if (VardvHOQC.Count() > 0)
{
dvHOQC = new DataView(VardvHOQC.CopyToDataTable());
}
if ( VardvHOQC.Where(z => z.Field<string>("WfIDYesorNo") == "0").Distinct().Select(z => z).Count() > 0)
{
DataTable res = VardvHOQC.Where(z => z.Field<string>("WfIDYesorNo") == "0").Distinct().Select(z => z).CopyToDataTable();
dvHOQC = new DataView(res);
}
VardvHOQC.Where(z => z.Field<string>("WfIDYesorNo") == "1").Distinct().Select(z => z).Count() > 0)
No comments:
Post a Comment