public static void AddPlannedOrderDetail(PlannedOrderDetail obj)
{
SqlParameter[] pars = new SqlParameter[9];
pars[0] = new SqlParameter("@plnum", SqlDbType.Int);
pars[0].Value = obj.Plnum;
pars[1] = new SqlParameter("@matnr", SqlDbType.NVarChar, 10);
pars[1].Value = obj.Matnr;
pars[2] = new SqlParameter("@maktx", SqlDbType.NVarChar, 100);
pars[2].Value = obj.Maktx;
pars[3] = new SqlParameter("@erfmg", SqlDbType.Float);
pars[3].Value = obj.Erfmg;
pars[4] = new SqlParameter("@erfme", SqlDbType.Char, 10);
pars[4].Value = obj.Erfme;
pars[5] = new SqlParameter("@plwmk", SqlDbType.VarChar, 4);
pars[5].Value = obj.Plwrk;
pars[6] = new SqlParameter("@lgpro", SqlDbType.VarChar, 4);
pars[6].Value = obj.Lgpro;
pars[7] = new SqlParameter("@charg", SqlDbType.VarChar, 50);
pars[7].Value = obj.Charg;
pars[8] = new SqlParameter("@posnr", SqlDbType.Int);
pars[8].Value = obj.Posnr;
DataProvider.Execute("usp_AddPlannedOrderDetail", pars, true);
}
public static PlannedOrderDetail GetPlannedOrderDetailFromMatnr(string matnr)
{
String query = "select * from PlannedOrderDetail where matnr = '" + matnr + "'";
PlannedOrderDetail objPlannedOrderDetail = new PlannedOrderDetail();
DataTable dt = DataProvider.GetList(query, null, false);
foreach (DataRow row in dt.Rows)
{
objPlannedOrderDetail = new PlannedOrderDetail(row);
}
return(objPlannedOrderDetail);
}
public static List <PlannedOrderDetail> GetListPlannedOrderDetail()
{
List <PlannedOrderDetail> lst = new List <PlannedOrderDetail>();
DataTable dt = DataProvider.GetList("usp_GetListPlannedOrderDetail", null, true);
foreach (DataRow row in dt.Rows)
{
PlannedOrderDetail obj = new PlannedOrderDetail(row);
lst.Add(obj);
}
return(lst);
}
//Lay chi tiet 1 plannedorder Detail
public static List <PlannedOrderDetail> GetPlannedOrderDetailFromPlnum(int plnum)
{
String query = "select * from PlannedOrderDetail where plnum = " + plnum;
List <PlannedOrderDetail> lst = new List <PlannedOrderDetail>();
DataTable dt = DataProvider.GetList(query, null, false);
foreach (DataRow row in dt.Rows)
{
PlannedOrderDetail objPlannedOrderDetail = new PlannedOrderDetail(row);
lst.Add(objPlannedOrderDetail);
}
return(lst);
}