/// <summary> /// 更新一条数据 /// </summary> public int UpdateAll(Model.UAVBD model) { StringBuilder strSql = new StringBuilder(); strSql.Append("UPDATE UAVBD SET "); strSql.Append("CID=@in_CID,"); strSql.Append("Speed=@in_Speed,"); strSql.Append("Focus=@in_Focus,"); strSql.Append("Chip_L=@in_Chip_L,"); strSql.Append("Chip_W=@in_Chip_W,"); strSql.Append("Pixel_L=@in_Pixel_L,"); strSql.Append("Pixel_W=@in_Pixel_W,"); strSql.Append("Sidelap=@in_Sidelap,"); strSql.Append("Routelap=@in_Routelap,"); strSql.Append("X=@in_X,"); strSql.Append("Y=@in_Y,"); strSql.Append("Name=@in_Name,"); strSql.Append("Province=@in_Province,"); strSql.Append("GID=@in_GID"); strSql.Append(" WHERE ID=@in_ID"); SqlParameter[] cmdParms = new SqlParameter[] { new SqlParameter("@in_CID", SqlDbType.Int), new SqlParameter("@in_Speed", SqlDbType.Float), new SqlParameter("@in_Focus", SqlDbType.Float), new SqlParameter("@in_Chip_L", SqlDbType.Float), new SqlParameter("@in_Chip_W", SqlDbType.Float), new SqlParameter("@in_Pixel_L", SqlDbType.Float), new SqlParameter("@in_Pixel_W", SqlDbType.Float), new SqlParameter("@in_Sidelap", SqlDbType.Float), new SqlParameter("@in_Routelap", SqlDbType.Float), new SqlParameter("@in_X", SqlDbType.Float), new SqlParameter("@in_Y", SqlDbType.Float), new SqlParameter("@in_Name", SqlDbType.NVarChar), new SqlParameter("@in_Province", SqlDbType.NVarChar), new SqlParameter("@in_GID", SqlDbType.Int), new SqlParameter("@in_ID", SqlDbType.Int) }; cmdParms[0].Value = model.CID; cmdParms[1].Value = model.Speed; cmdParms[2].Value = model.Focus; cmdParms[3].Value = model.Chip_L; cmdParms[4].Value = model.Chip_W; cmdParms[5].Value = model.Pixel_L; cmdParms[6].Value = model.Pixel_W; cmdParms[7].Value = model.Sidelap; cmdParms[8].Value = model.Routelap; cmdParms[9].Value = model.X; cmdParms[10].Value = model.Y; cmdParms[11].Value = model.Name; cmdParms[12].Value = model.Province; cmdParms[13].Value = model.GID; cmdParms[14].Value = model.ID; return(DbHelperSQL.ExecuteSql(strSql.ToString(), cmdParms)); }
/// <summary> /// 根据条件得到一个对象实体 /// </summary> public Model.UAVBD GetModel(string whereclause) { StringBuilder strSql = new StringBuilder(); strSql.Append("SELECT * FROM UAVBD "); strSql.Append(" WHERE " + whereclause);; Model.UAVBD model = null; using (SqlDataReader dr = DbHelperSQL.ExecuteReader(strSql.ToString())) { while (dr.Read()) { model = GetModel(dr); } return(model); } }
/// <summary> /// 更新一条数据 /// </summary> public int Update(Model.UAVBD model) { StringBuilder strSql = new StringBuilder(); strSql.Append("UPDATE UAVBD SET "); strSql.Append("GID=@in_GID"); strSql.Append(" WHERE Name=@in_PName"); SqlParameter[] cmdParms = new SqlParameter[] { new SqlParameter("@in_GID", SqlDbType.Int), new SqlParameter("@in_PName", SqlDbType.NVarChar) }; cmdParms[0].Value = model.GID; cmdParms[1].Value = model.Name; return(DbHelperSQL.ExecuteSql(strSql.ToString(), cmdParms)); }
/// <summary> /// 根据条件获取泛型数据列表 /// </summary> public List <Model.UAVBD> GetUAVList(string whereclause) { StringBuilder strSql = new StringBuilder("SELECT * FROM UAVBD WHERE " + whereclause); Model.UAVBD model; List <Model.UAVBD> lst = new List <Model.UAVBD>(); using (SqlDataReader dr = DbHelperSQL.ExecuteReader(strSql.ToString())) { while (dr.Read()) { model = new Model.UAVBD(); model.ID = DbHelperSQL.GetInt(dr["ID"]); model.GID = DbHelperSQL.GetInt(dr["GID"]); model.Name = DbHelperSQL.GetString(dr["Name"]); lst.Add(model); } return(lst); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Model.UAVBD model) { StringBuilder strSql = new StringBuilder(); strSql.Append("INSERT INTO UAVBD("); strSql.Append("CID,Speed,Focus,Chip_L,Chip_W,Pixel_L,Pixel_W,Sidelap,Routelap,X,Y,Name,Province,GID)"); strSql.Append(" VALUES ("); strSql.Append("@in_CID,@in_Speed,@in_Focus,@in_Chip_L,@in_Chip_W,@in_Pixel_L,@in_Pixel_W,@in_Sidelap,@in_Routelap,@in_X,@in_Y,@in_Name,@in_Province,@in_GID)"); SqlParameter[] cmdParms = new SqlParameter[] { new SqlParameter("@in_CID", SqlDbType.Int), new SqlParameter("@in_Speed", SqlDbType.Float), new SqlParameter("@in_Focus", SqlDbType.Float), new SqlParameter("@in_Chip_L", SqlDbType.Float), new SqlParameter("@in_Chip_W", SqlDbType.Float), new SqlParameter("@in_Pixel_L", SqlDbType.Float), new SqlParameter("@in_Pixel_W", SqlDbType.Float), new SqlParameter("@in_Sidelap", SqlDbType.Float), new SqlParameter("@in_Routelap", SqlDbType.Float), new SqlParameter("@in_X", SqlDbType.Float), new SqlParameter("@in_Y", SqlDbType.Float), new SqlParameter("@in_Name", SqlDbType.NVarChar), new SqlParameter("@in_Province", SqlDbType.NVarChar), new SqlParameter("@in_GID", SqlDbType.Int) }; cmdParms[0].Value = model.CID; cmdParms[1].Value = model.Speed; cmdParms[2].Value = model.Focus; cmdParms[3].Value = model.Chip_L; cmdParms[4].Value = model.Chip_W; cmdParms[5].Value = model.Pixel_L; cmdParms[6].Value = model.Pixel_W; cmdParms[7].Value = model.Sidelap; cmdParms[8].Value = model.Routelap; cmdParms[9].Value = model.X; cmdParms[10].Value = model.Y; cmdParms[11].Value = model.Name; cmdParms[12].Value = model.Province; cmdParms[13].Value = model.GID; return(DbHelperSQL.ExecuteSql(strSql.ToString(), cmdParms)); }
/// <summary> /// 由一行数据得到一个实体 /// </summary> private Model.UAVBD GetModel(DbDataReader dr) { Model.UAVBD model = new Model.UAVBD(); model.ID = DbHelperSQL.GetInt(dr["ID"]); model.CID = DbHelperSQL.GetInt(dr["CID"]); model.Name = DbHelperSQL.GetString(dr["Name"]); model.Speed = DbHelperSQL.GetDouble(dr["Speed"]); model.Focus = DbHelperSQL.GetDouble(dr["Focus"]); model.Chip_L = DbHelperSQL.GetDouble(dr["Chip_L"]); model.Chip_W = DbHelperSQL.GetDouble(dr["Chip_W"]); model.Pixel_L = DbHelperSQL.GetDouble(dr["Pixel_L"]); model.Pixel_W = DbHelperSQL.GetDouble(dr["Pixel_W"]); model.Sidelap = DbHelperSQL.GetDouble(dr["Sidelap"]); model.Routelap = DbHelperSQL.GetDouble(dr["Routelap"]); model.X = DbHelperSQL.GetDouble(dr["X"]); model.Y = DbHelperSQL.GetDouble(dr["Y"]); model.GID = DbHelperSQL.GetInt(dr["GID"]); model.TotalTime = DbHelperSQL.GetDouble(dr["TotalTime"]); model.TaskAreaIndex = DbHelperSQL.GetInt(dr["TaskAreaIndex"]); model.Province = DbHelperSQL.GetString(dr["Province"]); return(model); }