/// <summary>
/// 得到一个对象实体
/// </summary>
public YueYePlat.Model.deliveryorder GetModel(int Id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select Id,DeliveryOrderId,DeliveryId,SourceTransType,SourceTransId,AirWaybillID,Origin,BeginTime,Destination,Longitude,Latitude,PredictDeliveryTime,DeliveryTime,ClientId,ArriveTime,Receiver,ReceiverPhone1,ReceiverPhone2,ReceiverPhone3,IfTransfer,TransferName,TransferFee,Signer,SignerCardID,Telephone,IsBackFee,Receivable,Amount,IsDeliver,TotalFee,ReturnOrderSrc,ClientReturnOrderSrc,Terminator,IsEnd,PaymentMethod,Auditor,IsChecked,LogisCompanyShortName,LogisCompanyID,Remark,RecorderID from deliveryorder ");
strSql.Append(" where Id=@Id");
MySqlParameter[] parameters =
{
new MySqlParameter("@Id", MySqlDbType.Int32)
};
parameters[0].Value = Id;
YueYePlat.Model.deliveryorder model = new YueYePlat.Model.deliveryorder();
DataSet ds = DbHelperMySQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool UpdateByOrderId(YueYePlat.Model.deliveryorder model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update deliveryorder set ");
strSql.Append("DeliveryId=@DeliveryId,");
strSql.Append("Origin=@Origin,");
strSql.Append("BeginTime=@BeginTime,");
strSql.Append("Destination=@Destination,");
strSql.Append("Longitude=@Longitude,");
strSql.Append("Latitude=@Latitude,");
strSql.Append("PredictDeliveryTime=@PredictDeliveryTime,");
strSql.Append("DeliveryTime=@DeliveryTime,");
strSql.Append("ClientId=@ClientId,");
strSql.Append("ArriveTime=@ArriveTime,");
strSql.Append("Receiver=@Receiver,");
strSql.Append("ReceiverPhone1=@ReceiverPhone1,");
strSql.Append("ReceiverPhone2=@ReceiverPhone2,");
strSql.Append("ReceiverPhone3=@ReceiverPhone3,");
strSql.Append("Signer=@Signer,");
strSql.Append("Telephone=@Telephone,");
strSql.Append("IsBackFee=@IsBackFee,");
strSql.Append("Amount=@Amount,");
strSql.Append("IsDeliver=@IsDeliver,");
strSql.Append("TotalFee=@TotalFee,");
strSql.Append("ReturnOrderSrc=@ReturnOrderSrc,");
strSql.Append("ClientReturnOrderSrc=@ClientReturnOrderSrc,");
strSql.Append("IsEnd=@IsEnd,");
strSql.Append("Terminator=@Terminator,");
strSql.Append("PaymentMethod=@PaymentMethod,");
strSql.Append("LogisCompanyShortName=@LogisCompanyShortName,");
strSql.Append("LogisCompanyID=@LogisCompanyID,");
strSql.Append("Remark=@Remark");
strSql.Append(" where DeliveryOrderId=@DeliveryOrderId");
MySqlParameter[] parameters =
{
new MySqlParameter("@DeliveryOrderId", MySqlDbType.VarChar, 50),
new MySqlParameter("@DeliveryId", MySqlDbType.VarChar, 50),
new MySqlParameter("@Origin", MySqlDbType.VarChar, 20),
new MySqlParameter("@BeginTime", MySqlDbType.DateTime),
new MySqlParameter("@Destination", MySqlDbType.VarChar, 300),
new MySqlParameter("@Longitude", MySqlDbType.Double),
new MySqlParameter("@Latitude", MySqlDbType.Double),
new MySqlParameter("@PredictDeliveryTime", MySqlDbType.DateTime),
new MySqlParameter("@DeliveryTime", MySqlDbType.DateTime),
new MySqlParameter("@ClientId", MySqlDbType.VarChar, 50),
new MySqlParameter("@ArriveTime", MySqlDbType.DateTime),
new MySqlParameter("@Receiver", MySqlDbType.VarChar, 50),
new MySqlParameter("@ReceiverPhone1", MySqlDbType.VarChar, 20),
new MySqlParameter("@ReceiverPhone2", MySqlDbType.VarChar, 20),
new MySqlParameter("@ReceiverPhone3", MySqlDbType.VarChar, 20),
new MySqlParameter("@Signer", MySqlDbType.VarChar, 50),
new MySqlParameter("@Telephone", MySqlDbType.VarChar, 20),
new MySqlParameter("@IsBackFee", MySqlDbType.Bit),
new MySqlParameter("@Amount", MySqlDbType.Decimal, 15),
new MySqlParameter("@IsDeliver", MySqlDbType.Bit),
new MySqlParameter("@TotalFee", MySqlDbType.Decimal, 15),
new MySqlParameter("@ReturnOrderSrc", MySqlDbType.VarChar, 500),
new MySqlParameter("@ClientReturnOrderSrc", MySqlDbType.VarChar, 500),
new MySqlParameter("@IsEnd", MySqlDbType.Bit),
new MySqlParameter("@Terminator", MySqlDbType.VarChar, 50),
new MySqlParameter("@PaymentMethod", MySqlDbType.VarChar, 50),
new MySqlParameter("@LogisCompanyShortName", MySqlDbType.VarChar, 200),
new MySqlParameter("@LogisCompanyID", MySqlDbType.VarChar, 50),
new MySqlParameter("@Remark", MySqlDbType.Text),
};
parameters[0].Value = model.DeliveryOrderId;
parameters[1].Value = model.DeliveryId;
parameters[2].Value = model.Origin;
parameters[3].Value = model.BeginTime;
parameters[4].Value = model.Destination;
parameters[5].Value = model.Longitude;
parameters[6].Value = model.Latitude;
parameters[7].Value = model.PredictDeliveryTime;
parameters[8].Value = model.DeliveryTime;
parameters[9].Value = model.ClientId;
parameters[10].Value = model.ArriveTime;
parameters[11].Value = model.Receiver;
parameters[12].Value = model.ReceiverPhone1;
parameters[13].Value = model.ReceiverPhone2;
parameters[14].Value = model.ReceiverPhone3;
parameters[15].Value = model.Signer;
parameters[16].Value = model.Telephone;
parameters[17].Value = model.IsBackFee;
parameters[18].Value = model.Amount;
parameters[19].Value = model.IsDeliver;
parameters[20].Value = model.TotalFee;
parameters[21].Value = model.ReturnOrderSrc;
parameters[22].Value = model.ClientReturnOrderSrc;
parameters[23].Value = model.IsEnd;
parameters[24].Value = model.Terminator;
parameters[25].Value = model.PaymentMethod;
parameters[26].Value = model.LogisCompanyShortName;
parameters[27].Value = model.LogisCompanyID;
parameters[28].Value = model.Remark;
int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(YueYePlat.Model.deliveryorder model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into deliveryorder(");
strSql.Append("DeliveryOrderId,DeliveryId,SourceTransType,SourceTransId,AirWaybillID,Origin,BeginTime,Destination,Longitude,Latitude,PredictDeliveryTime,DeliveryTime,ClientId,ArriveTime,Receiver,ReceiverPhone1,ReceiverPhone2,ReceiverPhone3,IfTransfer,TransferName,TransferFee,Signer,SignerCardID,Telephone,IsBackFee,Receivable,Amount,IsDeliver,TotalFee,ReturnOrderSrc,ClientReturnOrderSrc,Terminator,IsEnd,PaymentMethod,Auditor,IsChecked,LogisCompanyShortName,LogisCompanyID,Remark,RecorderID)");
strSql.Append(" values (");
strSql.Append("@DeliveryOrderId,@DeliveryId,@SourceTransType,@SourceTransId,@AirWaybillID,@Origin,@BeginTime,@Destination,@Longitude,@Latitude,@PredictDeliveryTime,@DeliveryTime,@ClientId,@ArriveTime,@Receiver,@ReceiverPhone1,@ReceiverPhone2,@ReceiverPhone3,@IfTransfer,@TransferName,@TransferFee,@Signer,@SignerCardID,@Telephone,@IsBackFee,@Receivable,@Amount,@IsDeliver,@TotalFee,@ReturnOrderSrc,@ClientReturnOrderSrc,@Terminator,@IsEnd,@PaymentMethod,@Auditor,@IsChecked,@LogisCompanyShortName,@LogisCompanyID,@Remark,@RecorderID)");
MySqlParameter[] parameters =
{
new MySqlParameter("@DeliveryOrderId", MySqlDbType.VarChar, 50),
new MySqlParameter("@DeliveryId", MySqlDbType.VarChar, 50),
new MySqlParameter("@SourceTransType", MySqlDbType.VarChar, 50),
new MySqlParameter("@SourceTransId", MySqlDbType.VarChar, 50),
new MySqlParameter("@AirWaybillID", MySqlDbType.VarChar, 50),
new MySqlParameter("@Origin", MySqlDbType.VarChar, 20),
new MySqlParameter("@BeginTime", MySqlDbType.DateTime),
new MySqlParameter("@Destination", MySqlDbType.VarChar, 300),
new MySqlParameter("@Longitude", MySqlDbType.Double),
new MySqlParameter("@Latitude", MySqlDbType.Double),
new MySqlParameter("@PredictDeliveryTime", MySqlDbType.DateTime),
new MySqlParameter("@DeliveryTime", MySqlDbType.DateTime),
new MySqlParameter("@ClientId", MySqlDbType.VarChar, 50),
new MySqlParameter("@ArriveTime", MySqlDbType.DateTime),
new MySqlParameter("@Receiver", MySqlDbType.VarChar, 50),
new MySqlParameter("@ReceiverPhone1", MySqlDbType.VarChar, 20),
new MySqlParameter("@ReceiverPhone2", MySqlDbType.VarChar, 20),
new MySqlParameter("@ReceiverPhone3", MySqlDbType.VarChar, 20),
new MySqlParameter("@IfTransfer", MySqlDbType.Bit),
new MySqlParameter("@TransferName", MySqlDbType.VarChar, 300),
new MySqlParameter("@TransferFee", MySqlDbType.Decimal, 20),
new MySqlParameter("@Signer", MySqlDbType.VarChar, 50),
new MySqlParameter("@SignerCardID", MySqlDbType.VarChar, 50),
new MySqlParameter("@Telephone", MySqlDbType.VarChar, 20),
new MySqlParameter("@IsBackFee", MySqlDbType.Bit),
new MySqlParameter("@Receivable", MySqlDbType.Decimal, 15),
new MySqlParameter("@Amount", MySqlDbType.Decimal, 15),
new MySqlParameter("@IsDeliver", MySqlDbType.Bit),
new MySqlParameter("@TotalFee", MySqlDbType.Decimal, 15),
new MySqlParameter("@ReturnOrderSrc", MySqlDbType.VarChar, 500),
new MySqlParameter("@ClientReturnOrderSrc", MySqlDbType.VarChar, 500),
new MySqlParameter("@Terminator", MySqlDbType.VarChar, 50),
new MySqlParameter("@IsEnd", MySqlDbType.Bit),
new MySqlParameter("@PaymentMethod", MySqlDbType.VarChar, 50),
new MySqlParameter("@Auditor", MySqlDbType.VarChar, 50),
new MySqlParameter("@IsChecked", MySqlDbType.Bit),
new MySqlParameter("@LogisCompanyShortName", MySqlDbType.VarChar, 200),
new MySqlParameter("@LogisCompanyID", MySqlDbType.VarChar, 50),
new MySqlParameter("@Remark", MySqlDbType.Text),
new MySqlParameter("@RecorderID", MySqlDbType.VarChar, 50)
};
parameters[0].Value = model.DeliveryOrderId;
parameters[1].Value = model.DeliveryId;
parameters[2].Value = model.SourceTransType;
parameters[3].Value = model.SourceTransId;
parameters[4].Value = model.AirWaybillID;
parameters[5].Value = model.Origin;
parameters[6].Value = model.BeginTime;
parameters[7].Value = model.Destination;
parameters[8].Value = model.Longitude;
parameters[9].Value = model.Latitude;
parameters[10].Value = model.PredictDeliveryTime;
parameters[11].Value = model.DeliveryTime;
parameters[12].Value = model.ClientId;
parameters[13].Value = model.ArriveTime;
parameters[14].Value = model.Receiver;
parameters[15].Value = model.ReceiverPhone1;
parameters[16].Value = model.ReceiverPhone2;
parameters[17].Value = model.ReceiverPhone3;
parameters[18].Value = model.IfTransfer;
parameters[19].Value = model.TransferName;
parameters[20].Value = model.TransferFee;
parameters[21].Value = model.Signer;
parameters[22].Value = model.SignerCardID;
parameters[23].Value = model.Telephone;
parameters[24].Value = model.IsBackFee;
parameters[25].Value = model.Receivable;
parameters[26].Value = model.Amount;
parameters[27].Value = model.IsDeliver;
parameters[28].Value = model.TotalFee;
parameters[29].Value = model.ReturnOrderSrc;
parameters[30].Value = model.ClientReturnOrderSrc;
parameters[31].Value = model.Terminator;
parameters[32].Value = model.IsEnd;
parameters[33].Value = model.PaymentMethod;
parameters[34].Value = model.Auditor;
parameters[35].Value = model.IsChecked;
parameters[36].Value = model.LogisCompanyShortName;
parameters[37].Value = model.LogisCompanyID;
parameters[38].Value = model.Remark;
parameters[39].Value = model.RecorderID;
int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public YueYePlat.Model.deliveryorder DataRowToModel(DataRow row)
{
YueYePlat.Model.deliveryorder model = new YueYePlat.Model.deliveryorder();
if (row != null)
{
if (row["Id"] != null && row["Id"].ToString() != "")
{
model.Id = int.Parse(row["Id"].ToString());
}
if (row["DeliveryOrderId"] != null)
{
model.DeliveryOrderId = row["DeliveryOrderId"].ToString();
}
if (row["DeliveryId"] != null)
{
model.DeliveryId = row["DeliveryId"].ToString();
}
if (row["SourceTransType"] != null)
{
model.SourceTransType = row["SourceTransType"].ToString();
}
if (row["SourceTransId"] != null)
{
model.SourceTransId = row["SourceTransId"].ToString();
}
if (row["AirWaybillID"] != null)
{
model.AirWaybillID = row["AirWaybillID"].ToString();
}
if (row["Origin"] != null)
{
model.Origin = row["Origin"].ToString();
}
if (row["BeginTime"] != null && row["BeginTime"].ToString() != "")
{
model.BeginTime = DateTime.Parse(row["BeginTime"].ToString());
}
if (row["Destination"] != null)
{
model.Destination = row["Destination"].ToString();
}
if (row["Longitude"] != null && row["Longitude"].ToString() != "")
{
model.Longitude = double.Parse(row["Longitude"].ToString());
}
if (row["Latitude"] != null && row["Latitude"].ToString() != "")
{
model.Latitude = double.Parse(row["Latitude"].ToString());
}
//model.Longitude=row["Longitude"].ToString();
//model.Latitude=row["Latitude"].ToString();
if (row["PredictDeliveryTime"] != null && row["PredictDeliveryTime"].ToString() != "")
{
model.PredictDeliveryTime = DateTime.Parse(row["PredictDeliveryTime"].ToString());
}
if (row["DeliveryTime"] != null && row["DeliveryTime"].ToString() != "")
{
model.DeliveryTime = DateTime.Parse(row["DeliveryTime"].ToString());
}
if (row["ClientId"] != null)
{
model.ClientId = row["ClientId"].ToString();
}
if (row["ArriveTime"] != null && row["ArriveTime"].ToString() != "")
{
model.ArriveTime = DateTime.Parse(row["ArriveTime"].ToString());
}
if (row["Receiver"] != null)
{
model.Receiver = row["Receiver"].ToString();
}
if (row["ReceiverPhone1"] != null)
{
model.ReceiverPhone1 = row["ReceiverPhone1"].ToString();
}
if (row["ReceiverPhone2"] != null)
{
model.ReceiverPhone2 = row["ReceiverPhone2"].ToString();
}
if (row["ReceiverPhone3"] != null)
{
model.ReceiverPhone3 = row["ReceiverPhone3"].ToString();
}
if (row["IfTransfer"] != null && row["IfTransfer"].ToString() != "")
{
if ((row["IfTransfer"].ToString() == "1") || (row["IfTransfer"].ToString().ToLower() == "true"))
{
model.IfTransfer = true;
}
else
{
model.IfTransfer = false;
}
}
if (row["TransferName"] != null)
{
model.TransferName = row["TransferName"].ToString();
}
if (row["TransferFee"] != null && row["TransferFee"].ToString() != "")
{
model.TransferFee = decimal.Parse(row["TransferFee"].ToString());
}
if (row["Signer"] != null)
{
model.Signer = row["Signer"].ToString();
}
if (row["SignerCardID"] != null)
{
model.SignerCardID = row["SignerCardID"].ToString();
}
if (row["Telephone"] != null)
{
model.Telephone = row["Telephone"].ToString();
}
if (row["IsBackFee"] != null && row["IsBackFee"].ToString() != "")
{
if ((row["IsBackFee"].ToString() == "1") || (row["IsBackFee"].ToString().ToLower() == "true"))
{
model.IsBackFee = true;
}
else
{
model.IsBackFee = false;
}
}
if (row["Receivable"] != null && row["Receivable"].ToString() != "")
{
model.Receivable = decimal.Parse(row["Receivable"].ToString());
}
if (row["Amount"] != null && row["Amount"].ToString() != "")
{
model.Amount = decimal.Parse(row["Amount"].ToString());
}
if (row["IsDeliver"] != null && row["IsDeliver"].ToString() != "")
{
if ((row["IsDeliver"].ToString() == "1") || (row["IsDeliver"].ToString().ToLower() == "true"))
{
model.IsDeliver = true;
}
else
{
model.IsDeliver = false;
}
}
if (row["TotalFee"] != null && row["TotalFee"].ToString() != "")
{
model.TotalFee = decimal.Parse(row["TotalFee"].ToString());
}
if (row["ReturnOrderSrc"] != null)
{
model.ReturnOrderSrc = row["ReturnOrderSrc"].ToString();
}
if (row["ClientReturnOrderSrc"] != null)
{
model.ClientReturnOrderSrc = row["ClientReturnOrderSrc"].ToString();
}
if (row["Terminator"] != null)
{
model.Terminator = row["Terminator"].ToString();
}
if (row["IsEnd"] != null && row["IsEnd"].ToString() != "")
{
if ((row["IsEnd"].ToString() == "1") || (row["IsEnd"].ToString().ToLower() == "true"))
{
model.IsEnd = true;
}
else
{
model.IsEnd = false;
}
}
if (row["PaymentMethod"] != null)
{
model.PaymentMethod = row["PaymentMethod"].ToString();
}
if (row["Auditor"] != null)
{
model.Auditor = row["Auditor"].ToString();
}
if (row["IsChecked"] != null && row["IsChecked"].ToString() != "")
{
if ((row["IsChecked"].ToString() == "1") || (row["IsChecked"].ToString().ToLower() == "true"))
{
model.IsChecked = true;
}
else
{
model.IsChecked = false;
}
}
if (row["LogisCompanyShortName"] != null)
{
model.LogisCompanyShortName = row["LogisCompanyShortName"].ToString();
}
if (row["LogisCompanyID"] != null)
{
model.LogisCompanyID = row["LogisCompanyID"].ToString();
}
if (row["Remark"] != null)
{
model.Remark = row["Remark"].ToString();
}
if (row["RecorderID"] != null)
{
model.RecorderID = row["RecorderID"].ToString();
}
}
return(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool UpdateByOrderId(YueYePlat.Model.deliveryorder model)
{
return(dal.UpdateByOrderId(model));
}
