public static Model.mdlDeliveryOrder LoadDeliveryOrderbyDONumber(string lDoNumber)
{
List <SqlParameter> sp = new List <SqlParameter>()
{
new SqlParameter()
{
ParameterName = "@DoNumber", SqlDbType = SqlDbType.NVarChar, Value = lDoNumber
}
};
DataTable dtDeliveryOrder = DataFacade.DTSQLCommand(@"SELECT TOP 1 DONumber
,DODate
,BranchID
,VehicleID
From DeliveryOrder WHERE DONumber = @DoNumber", sp);
var mdlDeliveryOrder = new Model.mdlDeliveryOrder();
foreach (DataRow row in dtDeliveryOrder.Rows)
{
mdlDeliveryOrder.DONumber = row["DONumber"].ToString();
mdlDeliveryOrder.DODate = Convert.ToDateTime(row["DODate"]).ToString("yyyy-MM-dd hh:mm:ss");
mdlDeliveryOrder.BranchID = row["BranchID"].ToString();
mdlDeliveryOrder.VehicleID = row["VehicleID"].ToString();
}
return(mdlDeliveryOrder);
}
//001
//public static List<Model.DeliveryOrder> GetDOByCustomerID(string customerID,string warehouseID)
//{
// var DO = DataContext.DeliveryOrders.Where(fld => fld.CustomerID.Equals(customerID) && fld.WarehouseID.Equals(warehouseID)).OrderByDescending(fld => fld.DODate).ToList();
// return DO;
//}
public static List <Model.mdlDeliveryOrder> LoadDeliveryOrder(Model.mdlParam json)
{
var mdlDeliveryOrderList = new List <Model.mdlDeliveryOrder>();
List <SqlParameter> sp = new List <SqlParameter>()
{
new SqlParameter()
{
ParameterName = "@StartDate", SqlDbType = SqlDbType.DateTime, Value = Convert.ToDateTime(json.Date).Date
},
new SqlParameter()
{
ParameterName = "@FinishDate", SqlDbType = SqlDbType.DateTime, Value = Convert.ToDateTime(json.Date).Date.AddDays(1)
},
new SqlParameter()
{
ParameterName = "@EmployeeID", SqlDbType = SqlDbType.NVarChar, Value = json.EmployeeID
},
new SqlParameter()
{
ParameterName = "@BranchID", SqlDbType = SqlDbType.NVarChar, Value = json.BranchID
}
};
DataTable dtDeliveryOrder = DataFacade.DTSQLCommand(@"SELECT a.DONumber
,a.CallPlanID
,a.DODate
,a.DOStatus
,a.Description
,a.CustomerID
,a.EmployeeID
,a.VehicleID
,a.BranchID
,a.Signature
,a.IsPrint
,a.Remark
,a.WarehouseID
FROM DeliveryOrder a
INNER JOIN (
SELECT CallPlanID FROM CallPlan
WHERE EmployeeID = @EmployeeID AND BranchID = @BranchID AND IsFinish = 0 AND Date >= @StartDate AND Date < @FinishDate
) b ON b.CallPlanID = a.CallPlanID
WHERE DOStatus = 'Shipper'", sp);
//INNER JOIN (select * from CallPlanDetail where CallPlanID='C1000001') b ON b.CustomerID = a.CustomerID
foreach (DataRow row in dtDeliveryOrder.Rows)
{
var mdlDeliveryOrder = new Model.mdlDeliveryOrder();
mdlDeliveryOrder.DONumber = row["DONumber"].ToString();
mdlDeliveryOrder.CallPlanID = row["CallPlanID"].ToString();
mdlDeliveryOrder.CustomerID = row["CustomerID"].ToString();
mdlDeliveryOrder.WarehouseID = row["WarehouseID"].ToString();
mdlDeliveryOrder.EmployeeID = row["EmployeeID"].ToString();
mdlDeliveryOrder.VehicleID = row["VehicleID"].ToString(); //006--
mdlDeliveryOrder.DODate = Convert.ToDateTime(row["DODate"]).ToString("yyyy-MM-dd hh:mm:ss");
mdlDeliveryOrder.DOStatus = row["DOStatus"].ToString();
mdlDeliveryOrder.Description = row["Description"].ToString();
mdlDeliveryOrder.Signature = row["Signature"].ToString();
mdlDeliveryOrder.IsPrint = row["IsPrint"].ToString();
mdlDeliveryOrder.Remark = row["Remark"].ToString();
mdlDeliveryOrder.BranchID = row["BranchID"].ToString();
mdlDeliveryOrder.VisitID = "";
mdlDeliveryOrderList.Add(mdlDeliveryOrder);
}
return(mdlDeliveryOrderList);
}
