/// <summary> /// 更新一条数据 /// </summary> public int Update(Model.UAVPlan model) { StringBuilder strSql = new StringBuilder(); strSql.Append("UPDATE UAVPlan SET "); strSql.Append("CID=@in_CID,"); strSql.Append("CompName=@in_CompName,"); strSql.Append("PID=@in_PID,"); strSql.Append("ExpTime=@in_ExpTime,"); strSql.Append("GeneTime=@in_GeneTime,"); strSql.Append("isSelected=@in_isSelected"); strSql.Append(" WHERE ID=@in_ID"); SqlParameter[] cmdParms = new SqlParameter[] { new SqlParameter("@in_CID", SqlDbType.Int), new SqlParameter("@in_CompName", SqlDbType.NVarChar), new SqlParameter("@in_PID", SqlDbType.Int), new SqlParameter("@in_ExpTime", SqlDbType.Decimal), new SqlParameter("@in_GeneTime", SqlDbType.DateTime), new SqlParameter("@in_isSelected", SqlDbType.Int), new SqlParameter("@in_ID", SqlDbType.Int) }; cmdParms[0].Value = model.CID; cmdParms[1].Value = model.CompName; cmdParms[2].Value = model.PID; cmdParms[3].Value = model.ExpTime; cmdParms[4].Value = model.GeneTime; cmdParms[5].Value = model.isSelected; cmdParms[6].Value = model.ID; return(DbHelperSQL.ExecuteSql(strSql.ToString(), cmdParms)); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Model.UAVPlan model) { StringBuilder strSql = new StringBuilder(); strSql.Append("INSERT INTO UAVPlan("); strSql.Append("CID,CompName,PID,ExpTime,GeneTime,isSelected)"); strSql.Append(" VALUES ("); strSql.Append("@in_CID,@in_CompName,@in_PID,@in_ExpTime,@in_GeneTime,@in_isSelected)"); SqlParameter[] cmdParms = new SqlParameter[] { new SqlParameter("@in_CID", SqlDbType.Int), new SqlParameter("@in_CompName", SqlDbType.NVarChar), new SqlParameter("@in_PID", SqlDbType.Int), new SqlParameter("@in_ExpTime", SqlDbType.Decimal), new SqlParameter("@in_GeneTime", SqlDbType.DateTime), new SqlParameter("@in_isSelected", SqlDbType.Int) }; cmdParms[0].Value = model.CID; cmdParms[1].Value = model.CompName; cmdParms[2].Value = model.PID; cmdParms[3].Value = model.ExpTime; cmdParms[4].Value = model.GeneTime; cmdParms[5].Value = model.isSelected; return(DbHelperSQL.ExecuteSql(strSql.ToString(), cmdParms)); }
/// <summary> /// 由一行数据得到一个实体 /// </summary> private Model.UAVPlan GetModel(DbDataReader dr) { Model.UAVPlan model = new Model.UAVPlan(); model.ID = DbHelperSQL.GetInt(dr["ID"]); model.CID = DbHelperSQL.GetInt(dr["CID"]); model.CompName = DbHelperSQL.GetString(dr["CompName"]); model.PID = DbHelperSQL.GetInt(dr["PID"]); model.ExpTime = DbHelperSQL.GetDouble(dr["ExpTime"]); model.GeneTime = DbHelperSQL.GetDateTime(dr["GeneTime"]); model.isSelected = DbHelperSQL.GetInt(dr["isSelected"]); return(model); }
/// <summary> /// 得到一个对象实体 /// </summary> public Model.UAVPlan GetModel(int ID) { StringBuilder strSql = new StringBuilder(); strSql.Append("SELECT * FROM UAVPlan "); strSql.Append(" WHERE ID=" + ID); Model.UAVPlan model = null; using (SqlDataReader dr = DbHelperSQL.ExecuteReader(strSql.ToString())) { while (dr.Read()) { model = GetModel(dr); } return(model); } }