public List<OrderEntity> GetOrders(EnumSearchType searchtype, string typeid, int status, int paystatus, int invoicestatus, int returnstatus, string searchuserid, string searchteamid, string searchagentid,
string begintime, string endtime, string keyWords, string orderBy, int pageSize, int pageIndex, ref int totalCount, ref int pageCount, string userid, string agentid, string clientid)
{
List<OrderEntity> list = new List<OrderEntity>();
DataSet ds = OrdersDAL.BaseProvider.GetOrders((int)searchtype, typeid, status, paystatus, invoicestatus, returnstatus, searchuserid, searchteamid, searchagentid, begintime, endtime, keyWords, orderBy, pageSize, pageIndex, ref totalCount, ref pageCount, userid, agentid, clientid);
foreach (DataRow dr in ds.Tables[0].Rows)
{
OrderEntity model = new OrderEntity();
model.FillData(dr);
model.OrderType = SystemBusiness.BaseBusiness.GetOrderTypeByID(model.TypeID, model.AgentID, model.ClientID);
model.Owner = OrganizationBusiness.GetUserByUserID(model.OwnerID, model.AgentID);
model.StatusStr = CommonBusiness.GetEnumDesc((EnumOrderStatus)model.Status);
if (model.Status == 2)
{
model.SendStatusStr = CommonBusiness.GetEnumDesc((EnumSendStatus)model.SendStatus);
}
else if (model.Status < 2)
{
model.SendStatusStr = "--";
}
list.Add(model);
}
return list;
}
public List<OrderEntity> GetOrdersByCustomerID(string customerid, int pageSize, int pageIndex, ref int totalCount, ref int pageCount, string userid, string agentid, string clientid)
{
List<OrderEntity> list = new List<OrderEntity>();
DataTable dt = CommonBusiness.GetPagerData("Orders", "*", "CustomerID='" + customerid + "' and Status<>9 ", "AutoID", pageSize, pageIndex, out totalCount, out pageCount, false);
foreach (DataRow dr in dt.Rows)
{
OrderEntity model = new OrderEntity();
model.FillData(dr);
model.OrderType = SystemBusiness.BaseBusiness.GetOrderTypeByID(model.TypeID, model.AgentID, model.ClientID);
model.Owner = OrganizationBusiness.GetUserByUserID(model.OwnerID, model.AgentID);
model.StatusStr = CommonBusiness.GetEnumDesc((EnumOrderStatus)model.Status);
list.Add(model);
}
return list;
}
public OrderEntity GetOrderByID(string orderid, string agentid, string clientid)
{
DataSet ds = OrdersDAL.BaseProvider.GetOrderByID(orderid, agentid, clientid);
OrderEntity model = new OrderEntity();
if (ds.Tables["Order"].Rows.Count > 0)
{
model.FillData(ds.Tables["Order"].Rows[0]);
model.OrderType = SystemBusiness.BaseBusiness.GetOrderTypeByID(model.TypeID, model.AgentID, model.ClientID);
model.Owner = OrganizationBusiness.GetUserByUserID(model.OwnerID, model.AgentID);
model.CreateUser = OrganizationBusiness.GetUserByUserID(model.CreateUserID, model.AgentID);
model.StatusStr = model.Status == 0 ? "草案订单"
: model.Status == 1 ? "未审核"
: model.Status == 2 ? "已审核"
: model.Status == 9 ? "已删除"
: "";
model.ExpressTypeStr = model.ExpressType == 0 ? "邮寄"
: model.ExpressType == 1 ? "海运"
: model.ExpressType == 2 ? "空运"
: model.ExpressType == 3 ? "自提"
: "";
model.City = CommonBusiness.GetCityByCode(model.CityCode);
if (ds.Tables["Customer"].Rows.Count > 0)
{
model.Customer = new CustomerEntity();
model.Customer.FillData(ds.Tables["Customer"].Rows[0]);
}
model.Details = new List<OrderDetail>();
if (ds.Tables["Details"].Rows.Count > 0)
{
foreach (DataRow dr in ds.Tables["Details"].Rows)
{
OrderDetail detail = new OrderDetail();
detail.FillData(dr);
model.Details.Add(detail);
}
}
}
return model;
}
public OrderEntity GetOrderByID(string orderid, string agentid, string clientid)
{
DataSet ds = OrdersDAL.BaseProvider.GetOrderByID(orderid, agentid, clientid);
OrderEntity model = new OrderEntity();
if (ds.Tables["Order"].Rows.Count > 0)
{
model.FillData(ds.Tables["Order"].Rows[0]);
model.OrderType = SystemBusiness.BaseBusiness.GetOrderTypeByID(model.TypeID, model.AgentID, model.ClientID);
model.Owner = OrganizationBusiness.GetUserByUserID(model.OwnerID, model.AgentID);
model.CreateUser = OrganizationBusiness.GetUserByUserID(model.CreateUserID, model.AgentID);
model.StatusStr = CommonBusiness.GetEnumDesc((EnumOrderStatus)model.Status);
model.ExpressTypeStr = CommonBusiness.GetEnumDesc((EnumExpressType)model.ExpressType);
if (model.Status == 2)
{
model.SendStatusStr = CommonBusiness.GetEnumDesc((EnumSendStatus)model.SendStatus);
}
else if (model.Status < 2)
{
model.SendStatusStr = "--";
}
model.City = CommonBusiness.GetCityByCode(model.CityCode);
if (ds.Tables["Customer"].Rows.Count > 0)
{
model.Customer = new CustomerEntity();
model.Customer.FillData(ds.Tables["Customer"].Rows[0]);
}
model.Details = new List<OrderDetail>();
if (ds.Tables["Details"].Rows.Count > 0)
{
foreach (DataRow dr in ds.Tables["Details"].Rows)
{
OrderDetail detail = new OrderDetail();
detail.FillData(dr);
model.Details.Add(detail);
}
}
}
return model;
}
public List<OrderEntity> GetOrders(EnumSearchType searchtype, string typeid, int status, int paystatus, int invoicestatus, string searchuserid, string searchteamid, string searchagentid,
string begintime, string endtime, string keyWords, int pageSize, int pageIndex, ref int totalCount, ref int pageCount, string userid, string agentid, string clientid)
{
List<OrderEntity> list = new List<OrderEntity>();
DataSet ds = OrdersDAL.BaseProvider.GetOrders((int)searchtype, typeid, status, paystatus, invoicestatus, searchuserid, searchteamid, searchagentid, begintime, endtime, keyWords, pageSize, pageIndex, ref totalCount, ref pageCount, userid, agentid, clientid);
foreach (DataRow dr in ds.Tables[0].Rows)
{
OrderEntity model = new OrderEntity();
model.FillData(dr);
model.OrderType = SystemBusiness.BaseBusiness.GetOrderTypeByID(model.TypeID, model.AgentID, model.ClientID);
model.Owner = OrganizationBusiness.GetUserByUserID(model.OwnerID, model.AgentID);
model.StatusStr = model.Status == 0 ? "草案订单"
: model.Status == 1 ? "未审核"
: model.Status == 2 ? "已审核"
: model.Status == 9 ? "已删除"
: "";
list.Add(model);
}
return list;
}