/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Model.ScheduleResult model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("INSERT INTO ScheduleResult(");
strSql.Append("StartPoint,EndPoint,TranCost,Route,isChecked,UID,GID,PID)");
strSql.Append(" VALUES (");
strSql.Append("@in_StartPoint,@in_EndPoint,@in_TranCost,@in_Route,@in_isChecked,@in_UID,@in_GID,@in_PID)");
SqlParameter[] cmdParms = new SqlParameter[] {
new SqlParameter("@in_StartPoint", SqlDbType.NVarChar),
new SqlParameter("@in_EndPoint", SqlDbType.NVarChar),
new SqlParameter("@in_TranCost", SqlDbType.NVarChar),
new SqlParameter("@in_Route", SqlDbType.NVarChar),
new SqlParameter("@in_isChecked", SqlDbType.Bit),
new SqlParameter("@in_UID", SqlDbType.Int),
new SqlParameter("@in_GID", SqlDbType.Int),
new SqlParameter("@in_PID", SqlDbType.Int)
};
cmdParms[0].Value = model.StartPoint;
cmdParms[1].Value = model.EndPoint;
cmdParms[2].Value = model.TranCost;
cmdParms[3].Value = model.Route;
cmdParms[4].Value = 0;
cmdParms[5].Value = model.UID;
cmdParms[6].Value = model.GID;
cmdParms[7].Value = model.PID;
return(DbHelperSQL.ExecuteSql(strSql.ToString(), cmdParms));
}
/// <summary>
/// 由一行数据得到一个实体
/// </summary>
private Model.ScheduleResult GetModel(DbDataReader dr)
{
Model.ScheduleResult model = new Model.ScheduleResult();
model.ID = DbHelperSQL.GetInt(dr["ID"]);
model.StartPoint = DbHelperSQL.GetString(dr["StartPoint"]);
model.EndPoint = DbHelperSQL.GetString(dr["EndPoint"]);
model.TranCost = DbHelperSQL.GetString(dr["TranCost"]);
model.Route = DbHelperSQL.GetString(dr["Route"]);
model.isChecked = DbHelperSQL.GetBool(dr["isChecked"]);
model.UID = DbHelperSQL.GetInt(dr["UID"]);
model.GID = DbHelperSQL.GetInt(dr["GID"]);
model.PID = DbHelperSQL.GetInt(dr["PID"]);
return(model);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Model.ScheduleResult GetModel(int ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("SELECT * FROM ScheduleResult ");
strSql.Append(" WHERE ID=" + ID);
Model.ScheduleResult model = null;
using (SqlDataReader dr = DbHelperSQL.ExecuteReader(strSql.ToString()))
{
while (dr.Read())
{
model = GetModel(dr);
}
return(model);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public int Update(Model.ScheduleResult model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("UPDATE ScheduleResult SET ");
strSql.Append("StartPoint=@in_StartPoint,");
strSql.Append("EndPoint=@in_EndPoint,");
strSql.Append("TranCost=@in_TranCost,");
strSql.Append("Route=@in_Route,");
strSql.Append("isChecked=@in_isChecked,");
strSql.Append("UID=@in_UID,");
strSql.Append("GID=@in_GID,");
strSql.Append("PID=@in_PID");
strSql.Append(" WHERE ID=@in_ID");
SqlParameter[] cmdParms = new SqlParameter[] {
new SqlParameter("@in_StartPoint", SqlDbType.NVarChar),
new SqlParameter("@in_EndPoint", SqlDbType.NVarChar),
new SqlParameter("@in_TranCost", SqlDbType.NVarChar),
new SqlParameter("@in_Route", SqlDbType.NVarChar),
new SqlParameter("@in_isChecked", SqlDbType.Bit),
new SqlParameter("@in_UID", SqlDbType.Int),
new SqlParameter("@in_GID", SqlDbType.Int),
new SqlParameter("@in_PID", SqlDbType.Int),
new SqlParameter("@in_ID", SqlDbType.Int)
};
cmdParms[0].Value = model.StartPoint;
cmdParms[1].Value = model.EndPoint;
cmdParms[2].Value = model.TranCost;
cmdParms[3].Value = model.Route;
cmdParms[4].Value = 0;
cmdParms[5].Value = model.UID;
cmdParms[6].Value = model.GID;
cmdParms[7].Value = model.PID;
cmdParms[8].Value = model.ID;
return(DbHelperSQL.ExecuteSql(strSql.ToString(), cmdParms));
}
