/// <summary>
/// 得到一个对象实体
/// </summary>
public YueYePlat.Model.exceptioninfo DataRowToModel(DataRow row)
{
YueYePlat.Model.exceptioninfo model = new YueYePlat.Model.exceptioninfo();
if (row != null)
{
if (row["Id"] != null && row["Id"].ToString() != "")
{
model.Id = int.Parse(row["Id"].ToString());
}
if (row["DeliverId"] != null)
{
model.DeliverId = row["DeliverId"].ToString();
}
if (row["ExceptionType"] != null)
{
model.ExceptionType = row["ExceptionType"].ToString();
}
if (row["Exceptiondescribe"] != null)
{
model.Exceptiondescribe = row["Exceptiondescribe"].ToString();
}
if (row["ExceptionDispose"] != null)
{
model.ExceptionDispose = row["ExceptionDispose"].ToString();
}
if (row["Sender"] != null)
{
model.Sender = row["Sender"].ToString();
}
if (row["SendTime"] != null && row["SendTime"].ToString() != "")
{
model.SendTime = DateTime.Parse(row["SendTime"].ToString());
}
if (row["Conductor"] != null)
{
model.Conductor = row["Conductor"].ToString();
}
if (row["DisposeTime"] != null && row["DisposeTime"].ToString() != "")
{
model.DisposeTime = DateTime.Parse(row["DisposeTime"].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();
}
return(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(YueYePlat.Model.exceptioninfo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update exceptioninfo set ");
strSql.Append("DeliverId=@DeliverId,");
strSql.Append("ExceptionType=@ExceptionType,");
strSql.Append("Exceptiondescribe=@Exceptiondescribe,");
strSql.Append("ExceptionDispose=@ExceptionDispose,");
strSql.Append("Sender=@Sender,");
strSql.Append("SendTime=@SendTime,");
strSql.Append("Conductor=@Conductor,");
strSql.Append("DisposeTime=@DisposeTime,");
strSql.Append("Longitude=@Longitude,");
strSql.Append("Latitude=@Latitude");
strSql.Append(" where Id=@Id");
MySqlParameter[] parameters =
{
new MySqlParameter("@DeliverId", MySqlDbType.VarChar, 16),
new MySqlParameter("@ExceptionType", MySqlDbType.VarChar, 50),
new MySqlParameter("@Exceptiondescribe", MySqlDbType.VarChar, 500),
new MySqlParameter("@ExceptionDispose", MySqlDbType.VarChar, 500),
new MySqlParameter("@Sender", MySqlDbType.VarChar, 30),
new MySqlParameter("@SendTime", MySqlDbType.DateTime),
new MySqlParameter("@Conductor", MySqlDbType.VarChar, 50),
new MySqlParameter("@DisposeTime", MySqlDbType.DateTime),
new MySqlParameter("@Longitude", MySqlDbType.Double),
new MySqlParameter("@Latitude", MySqlDbType.Double),
new MySqlParameter("@Id", MySqlDbType.Int32, 11)
};
parameters[0].Value = model.DeliverId;
parameters[1].Value = model.ExceptionType;
parameters[2].Value = model.Exceptiondescribe;
parameters[3].Value = model.ExceptionDispose;
parameters[4].Value = model.Sender;
parameters[5].Value = model.SendTime;
parameters[6].Value = model.Conductor;
parameters[7].Value = model.DisposeTime;
parameters[8].Value = model.Longitude;
parameters[9].Value = model.Latitude;
parameters[10].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.exceptioninfo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into exceptioninfo(");
strSql.Append("DeliverId,ExceptionType,Exceptiondescribe,ExceptionDispose,Sender,SendTime,Conductor,DisposeTime,Longitude,Latitude)");
strSql.Append(" values (");
strSql.Append("@DeliverId,@ExceptionType,@Exceptiondescribe,@ExceptionDispose,@Sender,@SendTime,@Conductor,@DisposeTime,@Longitude,@Latitude)");
MySqlParameter[] parameters =
{
new MySqlParameter("@DeliverId", MySqlDbType.VarChar, 16),
new MySqlParameter("@ExceptionType", MySqlDbType.VarChar, 50),
new MySqlParameter("@Exceptiondescribe", MySqlDbType.VarChar, 500),
new MySqlParameter("@ExceptionDispose", MySqlDbType.VarChar, 500),
new MySqlParameter("@Sender", MySqlDbType.VarChar, 30),
new MySqlParameter("@SendTime", MySqlDbType.DateTime),
new MySqlParameter("@Conductor", MySqlDbType.VarChar, 50),
new MySqlParameter("@DisposeTime", MySqlDbType.DateTime),
new MySqlParameter("@Longitude", MySqlDbType.Double),
new MySqlParameter("@Latitude", MySqlDbType.Double)
};
parameters[0].Value = model.DeliverId;
parameters[1].Value = model.ExceptionType;
parameters[2].Value = model.Exceptiondescribe;
parameters[3].Value = model.ExceptionDispose;
parameters[4].Value = model.Sender;
parameters[5].Value = model.SendTime;
parameters[6].Value = model.Conductor;
parameters[7].Value = model.DisposeTime;
parameters[8].Value = model.Longitude;
parameters[9].Value = model.Latitude;
int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public YueYePlat.Model.exceptioninfo GetModel(int Id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select Id,DeliverId,ExceptionType,Exceptiondescribe,ExceptionDispose,Sender,SendTime,Conductor,DisposeTime,Longitude,Latitude from exceptioninfo ");
strSql.Append(" where Id=@Id");
MySqlParameter[] parameters =
{
new MySqlParameter("@Id", MySqlDbType.Int32)
};
parameters[0].Value = Id;
YueYePlat.Model.exceptioninfo model = new YueYePlat.Model.exceptioninfo();
DataSet ds = DbHelperMySQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
