new public static List<Products> Products(int MID) { var l = new List<Products>(); try { SqlParameter[] param = { new SqlParameter("@MID",MID) }; var dr = SqlHelper.ExecuteReader(SqlHelper.Local, CommandType.StoredProcedure, "Get_Products", param); while (dr.Read()) { var m = new Products(); m.ID = Convert.ToInt32(dr["ID"]); m.PID = Convert.ToInt32(dr["PID"]); m.Price = Convert.ToDecimal(dr["Price"]); m.Name = Convert.ToString(dr["Name"]); m.Memo = Convert.ToString(dr["Memo"]); if (dr["ExpireDate"] != DBNull.Value) m.ExpireDate = Convert.ToDateTime(dr["ExpireDate"]); m.MyID = Convert.ToInt32(dr["MyID"]); l.Add(m); } dr.Close(); } catch (Exception ex) { log.Fatal(ex.Message); log.FatalException(ex.Message, ex); } return l; }
public static Products Products(int MID, int PID) { var m = new Products(); try { SqlParameter[] param = { new SqlParameter("@MID",MID), new SqlParameter("@PID",PID), }; var dr = SqlHelper.ExecuteReader(SqlHelper.Local, CommandType.StoredProcedure, "Get_Products", param); if (dr.Read()) { m.ID = Convert.ToInt32(dr["ID"]); m.PID = Convert.ToInt32(dr["PID"]); m.Price = Convert.ToDecimal(dr["Price"]); m.Name = Convert.ToString(dr["Name"]); m.Memo = Convert.ToString(dr["Memo"]); m.MyID = Convert.ToInt32(dr["MyID"]); } dr.Close(); } catch (Exception ex) { log.Fatal(ex.Message); log.FatalException(ex.Message, ex); } return m; }