public DsMaster.PRICEMASTERDataTable UpdatePriceMaster(DsPurchase.PURINVDETAILDataTable dt, string suplierid)
{
var ds = new DsMaster().PRICEMASTER;
var dsf = new DsMaster().PRICEMASTER;
var ta = new DsMasterTableAdapters.PRICEMASTERTableAdapter();
foreach (DsPurchase.PURINVDETAILRow d in dt.Rows)
{
if (d.RowState != DataRowState.Deleted)
{
ta.Connection.ConnectionString = _constr;
ta.FillBySupNo(dsf, d["ITEMNO"].ToString(), suplierid);
if (dsf.Rows.Count > 0)
{
foreach (DsMaster.PRICEMASTERRow drf in dsf.Rows)
{
if (!d.IsEXPDATENull())
{
if (drf.LASTEXPDT != d.EXPDATE)
{
drf.LASTEXPDT = d.EXPDATE;
}
}
if (drf.PPRICE != d.CPRICE || drf.SPRICE != d.SPRICE)
{
var dr = (DsMaster.PRICEMASTERRow) ds.NewRow();
dr.SUPPLIERNO = suplierid;
dr.PPRICE = d.CPRICE;
dr.SPRICE = d.SPRICE;
dr.PDATE = DateTime.Now.Date;
if (!d.IsEXPDATENull())
{
dr.LASTEXPDT = d.EXPDATE;
}
ds.Rows.Add(dr);
}
}
}
else
{
var dr = (DsMaster.PRICEMASTERRow)ds.NewRow();
dr.SUPPLIERNO = suplierid;
dr.PPRICE = d.CPRICE;
dr.SPRICE = d.SPRICE;
dr.PDATE = DateTime.Now.Date;
if (!d.IsEXPDATENull())
{
dr.LASTEXPDT = d.EXPDATE;
}
ds.Rows.Add(dr);
}
}
}
return ds;
}
