public override DataTable getGlassesOrders(string CustId)
{
GlassesOrders order = null;
SqlCommand cmd = new SqlCommand();
string sql = "SELECT * FROM 日報表1 WHERE CustId = @CustId";
cmd.CommandText = sql;
cmd.Parameters.Add("@CustId", SqlDbType.VarChar, 0).Value = CustId;
DataTable dt = ExecuteScalarCmd3(cmd);
return(dt);
}
public override GlassesOrders getLatestGlassesOrders(string CustId)
{
GlassesOrders order = null;
SqlCommand cmd = new SqlCommand();
string sql = "select top 1 * from (SELECT TOP 99.99 PERCENT * FROM 日報表1 Where CustId = @CustId order by publishday desc)AS A ";
cmd.CommandText = sql;
cmd.Parameters.Add("@CustId", SqlDbType.VarChar, 0).Value = CustId;
using (SqlConnection conn = new SqlConnection(this.GetConnectionString())) {
cmd.Connection = conn;
conn.Open();
SqlDataReader reader = cmd.ExecuteReader();
order = new GlassesOrders();
while (reader.Read())
{
order.Balance = reader["Balance"].ToString();
order.BillNumber = reader["BillNumber"].ToString();
order.Contect = reader["Contect"].ToString();
order.LeftDegrees = reader["LeftDegrees"].ToString();
order.PinClass = reader["PinClass"].ToString();
order.PinManufacturerR = reader["PinManufacturerR"].ToString();
order.ProductName = reader["ProductName"].ToString();
order.PublishDay = reader["PublishDay"].ToString();
order.RightDegrees = reader["RightDegrees"].ToString();
order.SalesMan = reader["SalesMan"].ToString();
order.SellPrice = reader["SellPrice"].ToString();
order.SystemTime = reader["SystemTime"].ToString();
}
}
return(order);
}
