/// <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)); }