public IEnumerable <OrderViewEntity> GetView()
{
string sqlExpression = "SELECT * FROM OrderTable ORDER BY [Date]";
List <OrderViewEntity> orders = new List <OrderViewEntity>();
SqlConnection sql = _connection.CreateSqlConnection();
sql.Open();
SqlCommand command = new SqlCommand(sqlExpression, sql);
SqlDataReader reader = command.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
OrderViewEntity order = new OrderViewEntity
{
Id = reader.GetInt32(0),
Customer = reader.GetString(1),
Service = reader.GetString(2),
Price = reader.GetDecimal(3),
Date = reader.GetDateTime(4),
Status = reader.GetString(5)
};
orders.Add(order);
}
}
sql.Close();
return(orders);
}
public OrderViewEntity GetSingleView(int id)
{
string sqlExpression = "SELECT * FROM OrderTable WHERE Id = {id}";
OrderViewEntity order = new OrderViewEntity();
SqlConnection sql = _connection.CreateSqlConnection();
sql.Open();
SqlCommand command = new SqlCommand(sqlExpression, sql);
SqlDataReader reader = command.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
order = new OrderViewEntity
{
Id = reader.GetInt32(0),
Customer = reader.GetString(1),
Service = reader.GetString(2),
Price = reader.GetDecimal(3),
Date = reader.GetDateTime(4),
Status = reader.GetString(5)
};
}
}
sql.Close();
return(order);
}
public void SetViewEntity(OrderViewEntity entity, OrderEntity item, bool IsGetDetailList = false)
{
AgentApp app = new AgentApp();
var agent = app.GetForm(item.c_agent_id);
if (agent != null)
{
entity.c_agent_name = agent.c_name;
entity.c_agent_mobile = agent.c_mobile;
}
if (IsGetDetailList)
{
entity.detailList = GetDetailList(item.F_Id);
}
entity.F_Id = item.F_Id;
entity.c_agent_id = item.c_agent_id;
entity.c_order_num = item.c_order_num;
entity.c_total = item.c_total;
entity.c_state = item.c_state;
entity.c_express_num = item.c_express_num;
entity.c_express_name = item.c_express_name;
entity.c_rec_person = item.c_rec_person;
entity.c_mobile = item.c_mobile;
entity.c_address = item.c_address;
entity.c_order_type = item.c_order_type;
entity.c_remark = item.c_remark;
entity.F_CreatorTime = item.F_CreatorTime;
}
public List <OrderViewEntity> GetViewList(Pagination pagination, int orderType, int state)
{
var expression = ExtLinq.True <OrderEntity>();
expression = expression.And(t => t.c_state != 0);
if (orderType != 0)
{
expression = expression.And(t => t.c_order_type == orderType);
}
if (state != 0)
{
expression = expression.And(t => t.c_state == state);
}
var list = service.FindList(expression, pagination);
List <OrderViewEntity> viewList = new List <OrderViewEntity>();
foreach (var item in list)
{
OrderViewEntity entity = new OrderViewEntity();
SetViewEntity(entity, item);
viewList.Add(entity);
}
return(viewList);
}
public OrderViewEntity GetViewForm(string keyValue)
{
OrderEntity item = service.FindEntity(keyValue);
OrderViewEntity entity = new OrderViewEntity();
SetViewEntity(entity, item, true);
return(entity);
}
