public DataSet Order_Input_M_Item_Data(string MakerItemCD)
{
DataSet ds = new DataSet();
BaseDL dl = new BaseDL();
if (!string.IsNullOrWhiteSpace(MakerItemCD))
{
string[] itemcd = MakerItemCD.Split(',');
SqlParameter[] prms = new SqlParameter[9];
for (int i = 0; i < itemcd.Count(); i++)
{
prms[i] = new SqlParameter("@MakerItemCD" + i, SqlDbType.VarChar)
{
Value = itemcd[i].ToString()
};
}
for (int i = itemcd.Count(); i < 8; i++)
{
prms[i] = new SqlParameter("@MakerItemCD" + i, SqlDbType.VarChar)
{
Value = ""
};
}
prms[8] = new SqlParameter("@CompanyCD", SqlDbType.VarChar)
{
Value = "1001"
};
ds = dl.SelectDataSet("OrderInput_M_Item_Select", prms);
}
return(ds);
}
public DataSet _GetReportData(string OrderID)
{
DataSet ds = new DataSet();
SqlParameter prm = new SqlParameter();
if (OrderID == null)
{
prm = new SqlParameter("@OrderID", SqlDbType.VarChar)
{
Value = DBNull.Value
};
}
else
{
prm = new SqlParameter("@OrderID", SqlDbType.VarChar)
{
Value = OrderID
};
}
ds = dl.SelectDataSet("Order_History_Report", prm);
return(ds);
}
