/// <summary>
/// 由一行数据得到一个实体
/// </summary>
private CoScheduling.Core.Model.BIGAREA_TARGET GetModel(DbDataReader dr)
{
CoScheduling.Core.Model.BIGAREA_TARGET model = new CoScheduling.Core.Model.BIGAREA_TARGET();
model.TARGETID = Convert.ToInt32(dr["TARGETID"]);
model.TARGETNAME = Convert.ToString(dr["TARGETNAME"]);
model.TARGETLAT = Convert.ToDecimal(dr["TARGETLAT"]);
model.TARGETLON = Convert.ToDecimal(dr["TARGETLON"]);
model.SCHEMEID = Convert.ToInt32(dr["SCHEMEID"]);
return(model);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public CoScheduling.Core.Model.BIGAREA_TARGET GetModel(decimal TARGETID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("SELECT * FROM BIGAREA_TARGET ");
strSql.Append(" WHERE TARGETID=" + TARGETID);
CoScheduling.Core.Model.BIGAREA_TARGET model = new CoScheduling.Core.Model.BIGAREA_TARGET();
using (DbDataReader dr = CoScheduling.Core.DBUtility.DbHelperSQL.ExecuteReader(strSql.ToString()))
{
while (dr.Read())
{
model = GetModel(dr);
}
return(model);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(CoScheduling.Core.Model.BIGAREA_TARGET model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("INSERT INTO BIGAREA_TARGET(");
strSql.Append("TARGETNAME,TARGETLAT,TARGETLON,SCHEMEID)");
strSql.Append(" VALUES (");
strSql.Append("@in_TARGETNAME,@in_TARGETLAT,@in_TARGETLON,@in_SCHEMEID)");
SqlParameter[] cmdParms = new SqlParameter[] {
new SqlParameter("@in_TARGETNAME", SqlDbType.NVarChar),
new SqlParameter("@in_TARGETLAT", SqlDbType.Decimal),
new SqlParameter("@in_TARGETLON", SqlDbType.Decimal),
new SqlParameter("@in_SCHEMEID", SqlDbType.Decimal)
};
cmdParms[0].Value = model.TARGETNAME;
cmdParms[1].Value = model.TARGETLAT;
cmdParms[2].Value = model.TARGETLON;
cmdParms[3].Value = model.SCHEMEID;
return(CoScheduling.Core.DBUtility.DbHelperSQL.ExecuteSql(strSql.ToString(), cmdParms));
}
/// <summary>
/// 更新一条数据
/// </summary>
public int Update(CoScheduling.Core.Model.BIGAREA_TARGET model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("UPDATE BIGAREA_TARGET SET ");
strSql.Append("TARGETNAME=@in_TARGETNAME,");
strSql.Append("TARGETLAT=@in_TARGETLAT,");
strSql.Append("TARGETLON=@in_TARGETLON,");
strSql.Append("SCHEMEID=@in_SCHEMEID");
strSql.Append(" WHERE TARGETID=@in_TARGETID");
SqlParameter[] cmdParms = new SqlParameter[] {
new SqlParameter("@in_TARGETNAME", SqlDbType.NVarChar),
new SqlParameter("@in_TARGETLAT", SqlDbType.Decimal),
new SqlParameter("@in_TARGETLON", SqlDbType.Decimal),
new SqlParameter("@in_SCHEMEID", SqlDbType.Decimal),
new SqlParameter("@in_TARGETID", SqlDbType.Decimal)
};
cmdParms[0].Value = model.TARGETNAME;
cmdParms[1].Value = model.TARGETLAT;
cmdParms[2].Value = model.TARGETLON;
cmdParms[3].Value = model.SCHEMEID;
cmdParms[4].Value = model.TARGETID;
return(CoScheduling.Core.DBUtility.DbHelperSQL.ExecuteSql(strSql.ToString(), cmdParms));
}
