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