public IEnumerable <Management> ShowHistory(Input_Management data)
{
List <Management> results = new List <Management>();
try
{
Management getvalue = new Management();
getvalue.U_User = data.User;
getvalue.U_ABBNO = data.ABBNO;
using (HR_SALEDataContext db = new HR_SALEDataContext())
{
var sql = db.HR_SALE_ShowHistory(data.USERONLINE);
foreach (var ux in sql)
{
Management.GetManagement mp = new Management.GetManagement();
//mp.FULLNAME = ux.FULLNAME;
mp.ID_ST = ux.STCODE;
mp.ABBNO = ux.ABBNO;
mp.QTY = ux.QTY.ToString();
mp.NET = ux.NET;
mp.PTDATE = ux.WORKDATE.ToString();
mp.FLAG = ux.FLAG.ToString();
mp.Deteil = ux.DETEIL;
getvalue.AnsManagement.Add(mp);
//lstMP.Add(mp);
}
var sql2 = db.HR_SALE_ShowPI(data.USERONLINE, data.ABBNO);
foreach (var ux in sql2)
{
Management.GetPro sp = new Management.GetPro();
sp.MPCODE = ux.MPCODE;
sp.MPNAME = ux.FULLNAME;
sp.QTY = ux.QTY.ToString();
sp.DETAIL = ux.DETEIL;
sp.row = Int32.Parse(ux.Row_.ToString());
getvalue.ShowManagement.Add(sp);
//lstMP.Add(mp);
}
}
results.Add(getvalue);
}
catch (Exception ex)
{
//Detail res = new Detail();
//res.status = "F";
//res.message = ex.Message;
//results.Add(res);
}
return(results.ToArray());
}
public IEnumerable <Management> Setting(Input_Management data)
{
List <Management> results = new List <Management>();
try
{
Management getvalue = new Management();
using (HR_SALEDataContext db = new HR_SALEDataContext())
{
if (data.Check == "1")
{
getvalue.S_User = data.User;
getvalue.S_PTDATE = data.PTDATE;
getvalue.S_ABBNO = data.ABBNO;
getvalue.S_FULLNAME = data.FULLNAME;
getvalue.S_QTY = data.QTY;
getvalue.S_NET = data.NET;
var sql_PT = (from xx in db.HR_SALE_PTs
where xx.STCODE == data.User &&
xx.ABBNO == data.ABBNO
select xx).FirstOrDefault();
getvalue.Detail = sql_PT.DETEIL;
}
else if (data.Check == "2")
{
getvalue.C_ABBNO = data.ABBNO;
getvalue.C_User = data.User;
}
var sql = db.HR_SALE_GetManagement();
foreach (var ux in sql)
{
Management.GetManagement mp = new Management.GetManagement();
mp.FULLNAME = ux.FULLNAME;
mp.ID_ST = ux.STCODE;
mp.ABBNO = ux.ABBNO;
mp.QTY = ux.QTY.ToString();
mp.NET = ux.NET;
mp.PTDATE = ux.PTDATE.ToString();
mp.FLAG = ux.FLAG.ToString();
mp.Dpcode = ux.DPCODE;
getvalue.AnsManagement.Add(mp);
//lstMP.Add(mp);
}
var sql2 = db.HR_SALE_ShowPI(data.User, data.ABBNO);
foreach (var ux in sql2)
{
Management.GetPro sp = new Management.GetPro();
sp.MPCODE = ux.MPCODE;
sp.MPNAME = ux.FULLNAME;
sp.QTY = ux.QTY.ToString();
//sp.DETAIL = ux.DETEIL;
//sp.row = Int32.Parse(ux.Row_.ToString());
getvalue.ShowManagement.Add(sp);
//lstMP.Add(mp);
}
//}
results.Add(getvalue);
}
}
catch (Exception ex)
{
//Detail res = new Detail();
//res.status = "F";
//res.message = ex.Message;
//results.Add(res);
}
return(results.ToArray());
}