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;
}
