public int ModifyOrderDeliverPlan(OrderDeliverPlanInfo info)
{
DataCommand command = new DataCommand(ConnectionString, GetDbCommand(OrderDeliverPlanStatement.ModifyOrderDeliverPlan, "Text"));
command.AddInputParameter("@PlanID", DbType.Int32, info.PlanID);
command.AddInputParameter("@OrderIDS", DbType.String, info.OrderIDS);
command.AddInputParameter("@DeliveryNo", DbType.String, info.DeliveryNo);
command.AddInputParameter("@CarrierName", DbType.String, info.CarrierName);
command.AddInputParameter("@CarrierID", DbType.String, info.CarrierID);
command.AddInputParameter("@Temp", DbType.String, info.Temp);
command.AddInputParameter("@DeliveryType", DbType.String, info.DeliveryType);
command.AddInputParameter("@DriverName", DbType.String, info.DriverName);
command.AddInputParameter("@DriverTelephone", DbType.String, info.DriverTelephone);
command.AddInputParameter("@CarModel", DbType.String, info.CarModel);
command.AddInputParameter("@CarNo", DbType.String, info.CarNo);
command.AddInputParameter("@OilCardNo", DbType.String, info.OilCardNo);
command.AddInputParameter("@OilCardBalance", DbType.Decimal, info.OilCardBalance);
command.AddInputParameter("@GPSNo", DbType.String, info.GPSNo);
command.AddInputParameter("@NeedTicket", DbType.Boolean, info.NeedTicket);
command.AddInputParameter("@DeliverDate", DbType.DateTime, info.DeliverDate);
command.AddInputParameter("@Remark", DbType.String, info.Remark);
command.AddInputParameter("@OperatorID", DbType.String, info.OperatorID);
command.AddInputParameter("@ChangeDate", DbType.DateTime, info.ChangeDate);
return(command.ExecuteNonQuery());
}
private static OrderDeliverPlanEntity TranslateOrderDeliverPlanEntity(OrderDeliverPlanInfo info)
{
OrderDeliverPlanEntity entity = new OrderDeliverPlanEntity();
if (info != null)
{
entity.PlanID = info.PlanID;
entity.OrderIDS = info.OrderIDS;
entity.CarrierName = info.CarrierName;
entity.CarrierID = info.CarrierID;
entity.Temp = info.Temp;
entity.DeliveryNo = info.DeliveryNo;
entity.DeliveryType = info.DeliveryType;
entity.DriverName = info.DriverName;
entity.DriverTelephone = info.DriverTelephone;
entity.CarModel = info.CarModel;
entity.CarNo = info.CarNo;
entity.OilCardNo = info.OilCardNo;
entity.OilCardBalance = info.OilCardBalance;
entity.GPSNo = info.GPSNo;
entity.NeedTicket = info.NeedTicket;
entity.DeliverDate = info.DeliverDate;
if (entity.DeliverDate != null)
{
entity.formatDeliverDate = info.DeliverDate.ToString("yyyy-MM-dd");
}
entity.Remark = info.Remark;
entity.OperatorID = info.OperatorID;
entity.CreateDate = info.CreateDate;
entity.ChangeDate = info.ChangeDate;
}
return(entity);
}
private static OrderDeliverPlanInfo TranslateOrderDeliverPlanInfo(OrderDeliverPlanEntity entity)
{
OrderDeliverPlanInfo info = new OrderDeliverPlanInfo();
if (info != null)
{
info.PlanID = entity.PlanID;
info.OrderIDS = entity.OrderIDS;
info.DeliveryNo = entity.DeliveryNo;
info.CarrierName = entity.CarrierName;
info.CarrierID = entity.CarrierID;
info.Temp = entity.Temp;
info.DeliveryType = entity.DeliveryType;
info.DriverName = entity.DriverName;
info.DriverTelephone = entity.DriverTelephone;
info.CarModel = entity.CarModel;
info.CarNo = entity.CarNo;
info.OilCardNo = entity.OilCardNo;
info.OilCardBalance = entity.OilCardBalance;
info.GPSNo = entity.GPSNo;
info.NeedTicket = entity.NeedTicket;
info.DeliverDate = entity.DeliverDate;
info.Remark = entity.Remark;
info.OperatorID = entity.OperatorID;
info.CreateDate = entity.CreateDate;
info.ChangeDate = entity.ChangeDate;
}
return(info);
}
public OrderDeliverPlanInfo GetOrderDeliverPlanByKey(long ID)
{
OrderDeliverPlanInfo result = new OrderDeliverPlanInfo();
DataCommand command = new DataCommand(ConnectionString, GetDbCommand(OrderDeliverPlanStatement.GetOrderDeliverPlanByKey, "Text"));
command.AddInputParameter("@PlanID", DbType.String, ID);
result = command.ExecuteEntity <OrderDeliverPlanInfo>();
return(result);
}
public static OrderDeliverPlanEntity GetOrderDeliverPlanEntityById(long cid)
{
OrderDeliverPlanEntity result = new OrderDeliverPlanEntity();
OrderDeliverPlanRepository mr = new OrderDeliverPlanRepository();
OrderDeliverPlanInfo info = mr.GetOrderDeliverPlanByKey(cid);
if (info != null)
{
result = TranslateOrderDeliverPlanEntity(info);
}
return(result);
}
public static int ModifyOrderDeliverPlan(OrderDeliverPlanEntity entity)
{
int result = entity.PlanID;
if (entity != null)
{
OrderDeliverPlanRepository mr = new OrderDeliverPlanRepository();
OrderDeliverPlanInfo info = TranslateOrderDeliverPlanInfo(entity);
if (entity.PlanID > 0)
{
info.ChangeDate = DateTime.Now;
mr.ModifyOrderDeliverPlan(info);
}
else
{
info.ChangeDate = DateTime.Now;
info.CreateDate = DateTime.Now;
result = mr.CreateNew(info);
}
}
return(result);
}
