private bool insPosUL()
{
bool bl = false;
try
{
var result = cmd.PV_POS_ULs.ToList();
foreach (var item in result)
{
POS_UL ul = new POS_UL();
ul.WH_ID = item.WH_ID;
ul.ABBNO = item.ABBNO;
ul.PTDATE = item.PTDATE;
ul.WORKDATE = item.WORKDATE;
ul.TMCODE = item.TMCODE;
ul.UFLAG = "N";
sup.POS_ULs.InsertOnSubmit(ul);
sup.SubmitChanges();
}
bl = true;
}
catch (Exception ex)
{
bl = false;
MessageBox.Show(ex.Message + "pro3");
}
return(bl);
}
private bool getABBNO()
{
bool bl = false;
try
{
var result = cmd.PV_POS_ULs.ToList();
foreach (var item in result)
{
POS_UL ul = new POS_UL();
ul.WH_ID = item.WH_ID;
ul.ABBNO = item.ABBNO;
ul.PTDATE = item.PTDATE;
ul.WORKDATE = item.WORKDATE;
ul.TMCODE = item.TMCODE;
ul.UFLAG = "N";
sup.POS_ULs.InsertOnSubmit(ul);
sup.SubmitChanges();
}
//var bill_rs = sup.POS_ULs.Where(s => s.UFLAG == "N" &&( s.ABBNO == "10789" ) ).ToList();
//var bill_rs = sup.POS_ULs.Where(s => s.UFLAG == "N" ).Take(1).ToList();
var bill_rs = sup.POS_ULs.Where(s => s.UFLAG == "N").ToList();
foreach (var item in bill_rs)
{
getList(item.WH_ID, item.TMCODE, item.WORKDATE, item.ABBNO);
}
bl = true;
}
catch (Exception ex)
{
sms = ex.Message + "TEST2";
bl = false;
}
return(bl);
}
partial void UpdatePOS_UL(POS_UL instance);
partial void DeletePOS_UL(POS_UL instance);
partial void InsertPOS_UL(POS_UL instance);