/// <summary>
/// 得到一个对象实体
/// </summary>
public Model.DisaAreaInfo GetLastModel()
{
StringBuilder strSql = new StringBuilder();
strSql.Append("SELECT top 1 * FROM DisaAreaInfo ORDER BY ID DESC");
Model.DisaAreaInfo model = null;
using (SqlDataReader dr = DbHelperSQL.ExecuteReader(strSql.ToString()))
{
while (dr.Read())
{
model = GetModel(dr);
}
return(model);
}
}
/// <summary>
/// 得到最新的一个对象实体
/// </summary>
public Model.DisaAreaInfo GetSelectedModel(int ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("SELECT * FROM DisaAreaInfo Where ID=" + ID);
Model.DisaAreaInfo model = null;
using (SqlDataReader dr = DbHelperSQL.ExecuteReader(strSql.ToString()))
{
while (dr.Read())
{
model = GetModel(dr);
}
return(model);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public string GetCounty(int ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("SELECT County FROM DisaAreaInfo Where ID=" + ID);
Model.DisaAreaInfo model = null;
using (SqlDataReader dr = DbHelperSQL.ExecuteReader(strSql.ToString()))
{
string county = "";
while (dr.Read())
{
county = dr["County"].ToString();
}
return(county);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public int Update(Model.DisaAreaInfo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("UPDATE DisaAreaInfo SET ");
strSql.Append("Name=@in_Name,");
strSql.Append("StartTime=@in_StartTime,");
strSql.Append("LON=@in_LON,");
strSql.Append("LAT=@in_LAT,");
strSql.Append("Province=@in_Province,");
strSql.Append("County=@in_County,");;
strSql.Append("Descripe=@in_Descripe,");
strSql.Append("Seismic=@in_Seismic,");
strSql.Append("Angle=@in_Angle,");
strSql.Append("MBR=@in_MBR,");
strSql.Append("PolygonString=@in_PolygonString");
strSql.Append(" WHERE ID=@in_ID");
SqlParameter[] cmdParms = new SqlParameter[] {
new SqlParameter("@in_Name", SqlDbType.NVarChar),
new SqlParameter("@in_StartTime", SqlDbType.NVarChar),
new SqlParameter("@in_LON", SqlDbType.Decimal),
new SqlParameter("@in_LAT", SqlDbType.Decimal),
new SqlParameter("@in_Province", SqlDbType.NVarChar),
new SqlParameter("@in_County", SqlDbType.NVarChar),
new SqlParameter("@in_Descripe", SqlDbType.Decimal),
new SqlParameter("@in_Seismic", SqlDbType.Decimal),
new SqlParameter("@in_Angle", SqlDbType.Decimal),
new SqlParameter("@in_MBR", SqlDbType.NVarChar),
new SqlParameter("@in_PolygonString", SqlDbType.NVarChar),
new SqlParameter("@in_ID", SqlDbType.Int)
};
cmdParms[0].Value = model.Name;
cmdParms[1].Value = model.StartTime;
cmdParms[2].Value = model.LON;
cmdParms[3].Value = model.LAT;
cmdParms[4].Value = model.Province;
cmdParms[5].Value = model.County;
cmdParms[6].Value = model.Descripe;
cmdParms[7].Value = model.Seismic;
cmdParms[8].Value = model.Angle;
cmdParms[9].Value = model.MBR;
cmdParms[10].Value = model.PolygonString;
cmdParms[11].Value = model.ID;
return(DbHelperSQL.ExecuteSql(strSql.ToString(), cmdParms));
}
/// <summary>
/// 由一行数据得到一个实体
/// </summary>
private Model.DisaAreaInfo GetModel(DbDataReader dr)
{
Model.DisaAreaInfo model = new Model.DisaAreaInfo();
model.ID = DbHelperSQL.GetInt(dr["ID"]);
model.Name = DbHelperSQL.GetString(dr["Name"]);
model.StartTime = DbHelperSQL.GetDateTime(dr["StartTime"]);
model.LON = DbHelperSQL.GetDouble(dr["LON"]);
model.LAT = DbHelperSQL.GetDouble(dr["LAT"]);
model.Province = DbHelperSQL.GetString(dr["Province"]);
model.County = DbHelperSQL.GetString(dr["County"]);
model.Descripe = DbHelperSQL.GetDouble(dr["Descripe"]);
model.Seismic = DbHelperSQL.GetDouble(dr["Seismic"]);
model.Angle = DbHelperSQL.GetDouble(dr["Angle"]);
model.MBR = DbHelperSQL.GetString(dr["MBR"]);
model.PolygonString = DbHelperSQL.GetString(dr["PolygonString"]);
model.GenerateWay = DbHelperSQL.GetString(dr["GenerateWay"]);
return(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Model.DisaAreaInfo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("INSERT INTO DisaAreaInfo(");
strSql.Append("Name,StartTime,LON,LAT,Province,County,Descripe,Seismic,Angle,MBR,PolygonString,GenerateWay)");
strSql.Append(" VALUES (");
strSql.Append("@in_Name,@in_StartTime,@in_LON,@in_LAT,@in_Province,@in_County,@in_Descripe,@in_Seismic,@in_Angle,@in_MBR,@in_PolygonString,@in_GenerateWay)");
SqlParameter[] cmdParms = new SqlParameter[] {
new SqlParameter("@in_Name", SqlDbType.NVarChar),
new SqlParameter("@in_StartTime", SqlDbType.NVarChar),
new SqlParameter("@in_LON", SqlDbType.Decimal),
new SqlParameter("@in_LAT", SqlDbType.Decimal),
new SqlParameter("@in_Province", SqlDbType.NVarChar),
new SqlParameter("@in_County", SqlDbType.NVarChar),
new SqlParameter("@in_Descripe", SqlDbType.Decimal),
new SqlParameter("@in_Seismic", SqlDbType.Decimal),
new SqlParameter("@in_Angle", SqlDbType.Decimal),
new SqlParameter("@in_MBR", SqlDbType.NVarChar),
new SqlParameter("@in_PolygonString", SqlDbType.NVarChar),
new SqlParameter("@in_GenerateWay", SqlDbType.NVarChar),
};
cmdParms[0].Value = model.Name;
cmdParms[1].Value = model.StartTime;
cmdParms[2].Value = model.LON;
cmdParms[3].Value = model.LAT;
cmdParms[4].Value = model.Province;
cmdParms[5].Value = model.County;
cmdParms[6].Value = model.Descripe;
cmdParms[7].Value = model.Seismic;
cmdParms[8].Value = model.Angle;
cmdParms[9].Value = model.MBR;
cmdParms[10].Value = model.PolygonString;
cmdParms[11].Value = model.GenerateWay;
return(DbHelperSQL.ExecuteSql(strSql.ToString(), cmdParms));
}
