public List <MaterialPriceBean> getAllMaterialPrices(string sql, Dictionary <string, string> parameters) { List <MaterialPriceBean> materialPriceDataSource = new List <MaterialPriceBean>(); try { DataTable pricesResult = new ConnectionManager().select(sql, parameters); for (int i = 0; i < pricesResult.Rows.Count; i++) { MaterialPriceBean matrPriceBean = new MaterialPriceBean(); matrPriceBean.ID = int.Parse(pricesResult.Rows[i]["ID"].ToString()); matrPriceBean.MATER_ID = int.Parse(pricesResult.Rows[i]["MATER_ID"].ToString()); matrPriceBean.PRICE = float.Parse(pricesResult.Rows[i]["PRICE"].ToString()); matrPriceBean.CURRENCY = int.Parse(pricesResult.Rows[i]["CURRENCY"].ToString()); matrPriceBean.FROMDATE = DateTime.Parse(pricesResult.Rows[i]["FROMDATE"].ToString()); matrPriceBean.TODATE = DateTime.Parse(pricesResult.Rows[i]["TODATE"].ToString()); matrPriceBean.CREATE_DATE = DateTime.Parse(pricesResult.Rows[i]["CREATE_DATE"].ToString()); materialPriceDataSource.Add(matrPriceBean); } } catch (Exception ex) { } return(materialPriceDataSource); }
public MaterialPriceBean getCurrentMaterialPrices(int materialID) { MaterialPriceBean materialPriceDataSource = new MaterialPriceBean(); try { string currentDate = DateTime.Now.Year + "-" + DateTime.Now.Month + "-" + DateTime.Now.Day; string sql = " select * from pos.tmater_prce where MATER_ID = @material_id and FROMDATE < @FROMDATE and TODATE > @TODATE"; Dictionary <string, string> parameters = new Dictionary <string, string>(); parameters.Add("@material_id", materialID + ""); parameters.Add("@FROMDATE", currentDate); parameters.Add("@TODATE", currentDate); List <MaterialPriceBean> result = getAllMaterialPrices(sql, parameters); materialPriceDataSource = result[0]; } catch (Exception ex) { } return(materialPriceDataSource); }