/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(YueYePlat.Model.refueling model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update refueling set ");
strSql.Append("VehicleID=@VehicleID,");
strSql.Append("DeliveryId=@DeliveryId,");
strSql.Append("Longitude=@Longitude,");
strSql.Append("Latitude=@Latitude,");
strSql.Append("PetrolStation=@PetrolStation,");
strSql.Append("Money=@Money,");
strSql.Append("Quantity=@Quantity,");
strSql.Append("RefuelTime=@RefuelTime,");
strSql.Append("InvoicePhoto=@InvoicePhoto,");
strSql.Append("DriverId=@DriverId,");
strSql.Append("IfVerifyed=@IfVerifyed,");
strSql.Append("VerfielId=@VerfielId");
strSql.Append(" where Id=@Id");
MySqlParameter[] parameters =
{
new MySqlParameter("@VehicleID", MySqlDbType.VarChar, 12),
new MySqlParameter("@DeliveryId", MySqlDbType.VarChar, 16),
new MySqlParameter("@Longitude", MySqlDbType.Double),
new MySqlParameter("@Latitude", MySqlDbType.Double),
new MySqlParameter("@PetrolStation", MySqlDbType.VarChar, 50),
new MySqlParameter("@Money", MySqlDbType.Decimal, 10),
new MySqlParameter("@Quantity", MySqlDbType.Decimal, 10),
new MySqlParameter("@RefuelTime", MySqlDbType.DateTime),
new MySqlParameter("@InvoicePhoto", MySqlDbType.VarChar, 100),
new MySqlParameter("@DriverId", MySqlDbType.VarChar, 50),
new MySqlParameter("@IfVerifyed", MySqlDbType.Bit),
new MySqlParameter("@VerfielId", MySqlDbType.VarChar, 50),
new MySqlParameter("@Id", MySqlDbType.Int32, 11)
};
parameters[0].Value = model.VehicleID;
parameters[1].Value = model.DeliveryId;
parameters[2].Value = model.Longitude;
parameters[3].Value = model.Latitude;
parameters[4].Value = model.PetrolStation;
parameters[5].Value = model.Money;
parameters[6].Value = model.Quantity;
parameters[7].Value = model.RefuelTime;
parameters[8].Value = model.InvoicePhoto;
parameters[9].Value = model.DriverId;
parameters[10].Value = model.IfVerifyed;
parameters[11].Value = model.VerfielId;
parameters[12].Value = model.Id;
int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(YueYePlat.Model.refueling model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into refueling(");
strSql.Append("VehicleID,DeliveryId,Longitude,Latitude,PetrolStation,Money,Quantity,RefuelTime,InvoicePhoto,DriverId,IfVerifyed,VerfielId)");
strSql.Append(" values (");
strSql.Append("@VehicleID,@DeliveryId,@Longitude,@Latitude,@PetrolStation,@Money,@Quantity,@RefuelTime,@InvoicePhoto,@DriverId,@IfVerifyed,@VerfielId)");
MySqlParameter[] parameters =
{
new MySqlParameter("@VehicleID", MySqlDbType.VarChar, 12),
new MySqlParameter("@DeliveryId", MySqlDbType.VarChar, 16),
new MySqlParameter("@Longitude", MySqlDbType.Double),
new MySqlParameter("@Latitude", MySqlDbType.Double),
new MySqlParameter("@PetrolStation", MySqlDbType.VarChar, 50),
new MySqlParameter("@Money", MySqlDbType.Decimal, 10),
new MySqlParameter("@Quantity", MySqlDbType.Decimal, 10),
new MySqlParameter("@RefuelTime", MySqlDbType.DateTime),
new MySqlParameter("@InvoicePhoto", MySqlDbType.VarChar, 100),
new MySqlParameter("@DriverId", MySqlDbType.VarChar, 50),
new MySqlParameter("@IfVerifyed", MySqlDbType.Bit),
new MySqlParameter("@VerfielId", MySqlDbType.VarChar, 50)
};
parameters[0].Value = model.VehicleID;
parameters[1].Value = model.DeliveryId;
parameters[2].Value = model.Longitude;
parameters[3].Value = model.Latitude;
parameters[4].Value = model.PetrolStation;
parameters[5].Value = model.Money;
parameters[6].Value = model.Quantity;
parameters[7].Value = model.RefuelTime;
parameters[8].Value = model.InvoicePhoto;
parameters[9].Value = model.DriverId;
parameters[10].Value = model.IfVerifyed;
parameters[11].Value = model.VerfielId;
int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public YueYePlat.Model.refueling GetModel(int Id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select Id,VehicleID,DeliveryId,Longitude,Latitude,PetrolStation,Money,Quantity,RefuelTime,InvoicePhoto,DriverId,IfVerifyed,VerfielId from refueling ");
strSql.Append(" where Id=@Id");
MySqlParameter[] parameters =
{
new MySqlParameter("@Id", MySqlDbType.Int32)
};
parameters[0].Value = Id;
YueYePlat.Model.refueling model = new YueYePlat.Model.refueling();
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 YueYePlat.Model.refueling DataRowToModel(DataRow row)
{
YueYePlat.Model.refueling model = new YueYePlat.Model.refueling();
if (row != null)
{
if (row["Id"] != null && row["Id"].ToString() != "")
{
model.Id = int.Parse(row["Id"].ToString());
}
if (row["VehicleID"] != null)
{
model.VehicleID = row["VehicleID"].ToString();
}
if (row["DeliveryId"] != null)
{
model.DeliveryId = row["DeliveryId"].ToString();
}
if (row["Longitude"] != null)
{
model.Longitude = double.Parse(row["Longitude"].ToString());
}
if (row["Latitude"] != null)
{
model.Latitude = double.Parse(row["Latitude"].ToString());
}
//model.Longitude=row["Longitude"].ToString();
//model.Latitude=row["Latitude"].ToString();
if (row["PetrolStation"] != null)
{
model.PetrolStation = row["PetrolStation"].ToString();
}
if (row["Money"] != null && row["Money"].ToString() != "")
{
model.Money = decimal.Parse(row["Money"].ToString());
}
if (row["Quantity"] != null && row["Quantity"].ToString() != "")
{
model.Quantity = decimal.Parse(row["Quantity"].ToString());
}
if (row["RefuelTime"] != null && row["RefuelTime"].ToString() != "")
{
model.RefuelTime = DateTime.Parse(row["RefuelTime"].ToString());
}
if (row["InvoicePhoto"] != null)
{
model.InvoicePhoto = row["InvoicePhoto"].ToString();
}
if (row["DriverId"] != null)
{
model.DriverId = row["DriverId"].ToString();
}
if (row["IfVerifyed"] != null && row["IfVerifyed"].ToString() != "")
{
if ((row["IfVerifyed"].ToString() == "1") || (row["IfVerifyed"].ToString().ToLower() == "true"))
{
model.IfVerifyed = true;
}
else
{
model.IfVerifyed = false;
}
}
if (row["VerfielId"] != null)
{
model.VerfielId = row["VerfielId"].ToString();
}
}
return(model);
}
