/// <summary>
/// 更新一条数据
/// </summary>
public int Update(Model.TaskAreas model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("UPDATE TaskAreas SET ");
strSql.Append("PID=@in_PID,");
strSql.Append("Name=@in_Name,");
strSql.Append("PolygonString=@in_PolygonString,");
strSql.Append("Grade=@in_Grade,");
strSql.Append("Area=@in_Area,");
strSql.Append("X=@in_X,");
strSql.Append("Y=@in_Y");
strSql.Append(" WHERE ID=@in_ID");
SqlParameter[] cmdParms = new SqlParameter[] {
new SqlParameter("@in_ID", SqlDbType.Int),
new SqlParameter("@in_PID", SqlDbType.Int),
new SqlParameter("@in_Name", SqlDbType.NVarChar),
new SqlParameter("@in_PolygonString", SqlDbType.NVarChar),
new SqlParameter("@in_Grade", SqlDbType.Int),
new SqlParameter("@in_Area", SqlDbType.Float),
new SqlParameter("@in_X", SqlDbType.Float),
new SqlParameter("@in_Y", SqlDbType.Float)
};
cmdParms[0].Value = model.ID;
cmdParms[1].Value = model.PID;
cmdParms[2].Value = model.Name;
cmdParms[3].Value = model.PolygonString;
cmdParms[4].Value = model.Grade;
cmdParms[5].Value = model.Area;
cmdParms[6].Value = model.X;
cmdParms[7].Value = model.Y;
return(DbHelperSQL.ExecuteSql(strSql.ToString(), cmdParms));
}
/// <summary>
/// 获取没有完成的灾区列表
/// </summary>
public List <Model.TaskAreas> GetRemainList(string whereclause)
{
List <int> taskID = new List <int>();
StringBuilder strSql = new StringBuilder("SELECT ID FROM TaskAreas");
strSql.Append(" WHERE " + whereclause + "");
using (SqlDataReader dr = DbHelperSQL.ExecuteReader(strSql.ToString()))
{
while (dr.Read())
{
taskID.Add(Convert.ToInt32(dr["ID"]));
}
}
List <Model.TaskAreas> taskArea = new List <Model.TaskAreas>();
Core.Model.TaskAreas model;
for (int i = 0; i < taskID.Count; i++)
{
model = new Model.TaskAreas();
model = GetModel(taskID[i]);
if (model != null)
{
taskArea.Add(model);
}
}
return(taskArea);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Model.TaskAreas model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("INSERT INTO TaskAreas(");
strSql.Append("PID,Name,PolygonString,Grade,Area,X,Y)");
strSql.Append(" VALUES (");
strSql.Append("@in_PID,@in_Name,@in_PolygonString,@in_Grade,@in_Area,@in_X,@in_Y)");
SqlParameter[] cmdParms = new SqlParameter[] {
new SqlParameter("@in_PID", SqlDbType.Int),
new SqlParameter("@in_Name", SqlDbType.NVarChar),
new SqlParameter("@in_PolygonString", SqlDbType.NVarChar),
new SqlParameter("@in_Grade", SqlDbType.Int),
new SqlParameter("@in_Area", SqlDbType.Float),
new SqlParameter("@in_X", SqlDbType.Float),
new SqlParameter("@in_Y", SqlDbType.Float)
};
cmdParms[0].Value = model.PID;
cmdParms[1].Value = model.Name;
cmdParms[2].Value = model.PolygonString;
cmdParms[3].Value = model.Grade;
cmdParms[4].Value = model.Area;
cmdParms[5].Value = model.X;
cmdParms[6].Value = model.Y;
return(DbHelperSQL.ExecuteSql(strSql.ToString(), cmdParms));
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Model.TaskAreas GetModel(int ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("SELECT * FROM TaskAreas ");
strSql.Append(" WHERE ID=" + ID);
Model.TaskAreas model = null;
using (SqlDataReader dr = DbHelperSQL.ExecuteReader(strSql.ToString()))
{
while (dr.Read())
{
model = GetModel(dr);
}
return(model);
}
}
/// <summary>
/// 由一行数据得到一个实体
/// </summary>
private Model.TaskAreas GetModel(DbDataReader dr)
{
Model.TaskAreas model = new Model.TaskAreas();
model.ID = DbHelperSQL.GetInt(dr["ID"]);
model.PID = DbHelperSQL.GetInt(dr["PID"]);
model.Name = DbHelperSQL.GetString(dr["Name"]);
model.PolygonString = DbHelperSQL.GetString(dr["PolygonString"]);
model.Grade = DbHelperSQL.GetInt(dr["Grade"]);
model.Area = DbHelperSQL.GetDouble(dr["Area"]);
model.X = DbHelperSQL.GetDouble(dr["X"]);
model.Y = DbHelperSQL.GetDouble(dr["Y"]);
model.GID = DbHelperSQL.GetInt(dr["GID"]);
model.UID = DbHelperSQL.GetInt(dr["UID"]);
model.TraTime = DbHelperSQL.GetDouble(dr["TraTime"]);
model.Orders = DbHelperSQL.GetInt(dr["Orders"]);
model.FlyTime = DbHelperSQL.GetDouble(dr["FlyTime"]);
return(model);
}
/// <summary>
/// 更新任务区名称和等级
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int Updates(Model.TaskAreas model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("UPDATE TaskAreas SET ");
strSql.Append("Name=@in_Name,");
strSql.Append("Grade=@in_Grade");
strSql.Append(" WHERE ID=@in_ID");
SqlParameter[] cmdParms = new SqlParameter[] {
new SqlParameter("@in_ID", SqlDbType.Int),
new SqlParameter("@in_Name", SqlDbType.NVarChar),
new SqlParameter("@in_Grade", SqlDbType.Int)
};
cmdParms[0].Value = model.ID;
cmdParms[1].Value = model.Name;
cmdParms[2].Value = model.Grade;
return(DbHelperSQL.ExecuteSql(strSql.ToString(), cmdParms));
}
