/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(YueYePlat.Model.vehicledelivery model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into vehicledelivery(");
strSql.Append("DeliveryId,DeviceId,VehicleId,Driver1Id,Driver2Id,Origin,BeginTime,MinTempThreshold,MaxTempThreshold,MinHumThreshold,MaxHumThreshold,IfEnd,RecordId,Auditor,IfChargeback)");
strSql.Append(" values (");
strSql.Append("@DeliveryId,@DeviceId,@VehicleId,@Driver1Id,@Driver2Id,@Origin,@BeginTime,@MinTempThreshold,@MaxTempThreshold,@MinHumThreshold,@MaxHumThreshold,@IfEnd,@RecordId,@Auditor,@IfChargeback)");
MySqlParameter[] parameters =
{
new MySqlParameter("@DeliveryId", MySqlDbType.VarChar, 50),
new MySqlParameter("@DeviceId", MySqlDbType.VarChar, 14),
new MySqlParameter("@VehicleId", MySqlDbType.VarChar, 50),
new MySqlParameter("@Driver1Id", MySqlDbType.VarChar, 50),
new MySqlParameter("@Driver2Id", MySqlDbType.VarChar, 50),
new MySqlParameter("@Origin", MySqlDbType.VarChar, 50),
new MySqlParameter("@BeginTime", MySqlDbType.DateTime),
new MySqlParameter("@MinTempThreshold", MySqlDbType.Double),
new MySqlParameter("@MaxTempThreshold", MySqlDbType.Double),
new MySqlParameter("@MinHumThreshold", MySqlDbType.Double),
new MySqlParameter("@MaxHumThreshold", MySqlDbType.Double),
new MySqlParameter("@IfEnd", MySqlDbType.Bit),
new MySqlParameter("@RecordId", MySqlDbType.VarChar, 50),
new MySqlParameter("@Auditor", MySqlDbType.VarChar, 50),
new MySqlParameter("@IfChargeback", MySqlDbType.Bit)
};
parameters[0].Value = model.DeliveryId;
parameters[1].Value = model.DeviceId;
parameters[2].Value = model.VehicleId;
parameters[3].Value = model.Driver1Id;
parameters[4].Value = model.Driver2Id;
parameters[5].Value = model.Origin;
parameters[6].Value = model.BeginTime;
parameters[7].Value = model.MinTempThreshold;
parameters[8].Value = model.MaxTempThreshold;
parameters[9].Value = model.MinHumThreshold;
parameters[10].Value = model.MaxHumThreshold;
parameters[11].Value = model.IfEnd;
parameters[12].Value = model.RecordId;
parameters[13].Value = model.Auditor;
parameters[14].Value = model.IfChargeback;
int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public YueYePlat.Model.vehicledelivery GetModel(int Id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select Id,DeliveryId,DeviceId,VehicleId,Driver1Id,Driver2Id,Origin,BeginTime,MinTempThreshold,MaxTempThreshold,MinHumThreshold,MaxHumThreshold,IfEnd,RecordId,Auditor,IfChargeback from vehicledelivery ");
strSql.Append(" where Id=@Id");
MySqlParameter[] parameters =
{
new MySqlParameter("@Id", MySqlDbType.Int32)
};
parameters[0].Value = Id;
YueYePlat.Model.vehicledelivery model = new YueYePlat.Model.vehicledelivery();
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.vehicledelivery DataRowToModel(DataRow row)
{
YueYePlat.Model.vehicledelivery model = new YueYePlat.Model.vehicledelivery();
if (row != null)
{
if (row["Id"] != null && row["Id"].ToString() != "")
{
model.Id = int.Parse(row["Id"].ToString());
}
if (row["DeliveryId"] != null)
{
model.DeliveryId = row["DeliveryId"].ToString();
}
if (row["DeviceId"] != null)
{
model.DeviceId = row["DeviceId"].ToString();
}
if (row["VehicleId"] != null)
{
model.VehicleId = row["VehicleId"].ToString();
}
if (row["Driver1Id"] != null)
{
model.Driver1Id = row["Driver1Id"].ToString();
}
if (row["Driver2Id"] != null)
{
model.Driver2Id = row["Driver2Id"].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["MinTempThreshold"] != null && row["MinTempThreshold"].ToString() != "")
{
model.MinTempThreshold = Double.Parse(row["MinTempThreshold"].ToString());
}
if (row["MaxTempThreshold"] != null && row["MaxTempThreshold"].ToString() != "")
{
model.MaxTempThreshold = Double.Parse(row["MaxTempThreshold"].ToString());
}
if (row["MinHumThreshold"] != null && row["MinHumThreshold"].ToString() != "")
{
model.MinHumThreshold = Double.Parse(row["MinHumThreshold"].ToString());
}
if (row["MaxHumThreshold"] != null && row["MaxHumThreshold"].ToString() != "")
{
model.MaxHumThreshold = Double.Parse(row["MaxHumThreshold"].ToString());
}
//model.MinTempThreshold=row["MinTempThreshold"].ToString();
//model.MaxTempThreshold=row["MaxTempThreshold"].ToString();
//model.MinHumThreshold=row["MinHumThreshold"].ToString();
//model.MaxHumThreshold=row["MaxHumThreshold"].ToString();
if (row["IfEnd"] != null && row["IfEnd"].ToString() != "")
{
if ((row["IfEnd"].ToString() == "1") || (row["IfEnd"].ToString().ToLower() == "true"))
{
model.IfEnd = true;
}
else
{
model.IfEnd = false;
}
}
if (row["RecordId"] != null)
{
model.RecordId = row["RecordId"].ToString();
}
if (row["Auditor"] != null)
{
model.Auditor = row["Auditor"].ToString();
}
if (row["IfChargeback"] != null && row["IfChargeback"].ToString() != "")
{
if ((row["IfChargeback"].ToString() == "1") || (row["IfChargeback"].ToString().ToLower() == "true"))
{
model.IfChargeback = true;
}
else
{
model.IfChargeback = false;
}
}
}
return(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(YueYePlat.Model.vehicledelivery model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update vehicledelivery set ");
strSql.Append("DeliveryId=@DeliveryId,");
strSql.Append("DeviceId=@DeviceId,");
strSql.Append("VehicleId=@VehicleId,");
strSql.Append("Driver1Id=@Driver1Id,");
strSql.Append("Driver2Id=@Driver2Id,");
strSql.Append("Origin=@Origin,");
strSql.Append("BeginTime=@BeginTime,");
strSql.Append("MinTempThreshold=@MinTempThreshold,");
strSql.Append("MaxTempThreshold=@MaxTempThreshold,");
strSql.Append("MinHumThreshold=@MinHumThreshold,");
strSql.Append("MaxHumThreshold=@MaxHumThreshold,");
strSql.Append("IfEnd=@IfEnd,");
strSql.Append("RecordId=@RecordId,");
strSql.Append("Auditor=@Auditor,");
strSql.Append("IfChargeback=@IfChargeback");
strSql.Append(" where Id=@Id");
MySqlParameter[] parameters =
{
new MySqlParameter("@DeliveryId", MySqlDbType.VarChar, 50),
new MySqlParameter("@DeviceId", MySqlDbType.VarChar, 14),
new MySqlParameter("@VehicleId", MySqlDbType.VarChar, 50),
new MySqlParameter("@Driver1Id", MySqlDbType.VarChar, 50),
new MySqlParameter("@Driver2Id", MySqlDbType.VarChar, 50),
new MySqlParameter("@Origin", MySqlDbType.VarChar, 50),
new MySqlParameter("@BeginTime", MySqlDbType.DateTime),
new MySqlParameter("@MinTempThreshold", MySqlDbType.Double),
new MySqlParameter("@MaxTempThreshold", MySqlDbType.Double),
new MySqlParameter("@MinHumThreshold", MySqlDbType.Double),
new MySqlParameter("@MaxHumThreshold", MySqlDbType.Double),
new MySqlParameter("@IfEnd", MySqlDbType.Bit),
new MySqlParameter("@RecordId", MySqlDbType.VarChar, 50),
new MySqlParameter("@Auditor", MySqlDbType.VarChar, 50),
new MySqlParameter("@IfChargeback", MySqlDbType.Bit),
new MySqlParameter("@Id", MySqlDbType.Int32, 11)
};
parameters[0].Value = model.DeliveryId;
parameters[1].Value = model.DeviceId;
parameters[2].Value = model.VehicleId;
parameters[3].Value = model.Driver1Id;
parameters[4].Value = model.Driver2Id;
parameters[5].Value = model.Origin;
parameters[6].Value = model.BeginTime;
parameters[7].Value = model.MinTempThreshold;
parameters[8].Value = model.MaxTempThreshold;
parameters[9].Value = model.MinHumThreshold;
parameters[10].Value = model.MaxHumThreshold;
parameters[11].Value = model.IfEnd;
parameters[12].Value = model.RecordId;
parameters[13].Value = model.Auditor;
parameters[14].Value = model.IfChargeback;
parameters[15].Value = model.Id;
int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
