/// <summary>
/// 更新一条数据
/// </summary>
public int Update(CoScheduling.Core.Model.AssemblyPoint model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("UPDATE AssemblyPoint SET ");
strSql.Append("Name=@in_Name,");
strSql.Append("TID=@in_TID,");
strSql.Append("LON=@in_LON,");
strSql.Append("LAT=@in_LAT,");
strSql.Append("RoadType=@in_RoadType,");
strSql.Append("RoadID=@in_RoadID,");
strSql.Append("RoadName=@in_RoadName");
strSql.Append(" WHERE ID=@in_ID");
SqlParameter[] cmdParms = new SqlParameter[] {
new SqlParameter("@in_Name", SqlDbType.NVarChar),
new SqlParameter("@in_TID", SqlDbType.Int),
new SqlParameter("@in_LON", SqlDbType.Decimal),
new SqlParameter("@in_LAT", SqlDbType.Decimal),
new SqlParameter("@in_RoadType", SqlDbType.NVarChar),
new SqlParameter("@in_RoadID", SqlDbType.Int),
new SqlParameter("@in_RoadName", SqlDbType.NVarChar),
new SqlParameter("@in_ID", SqlDbType.Int)
};
cmdParms[0].Value = model.Name;
cmdParms[1].Value = model.TID;
cmdParms[2].Value = model.LON;
cmdParms[3].Value = model.LAT;
cmdParms[4].Value = model.RoadType;
cmdParms[5].Value = model.RoadID;
cmdParms[6].Value = model.RoadName;
cmdParms[7].Value = model.ID;
return(DbHelperSQL.ExecuteSql(strSql.ToString(), cmdParms));
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(CoScheduling.Core.Model.AssemblyPoint model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("INSERT INTO AssemblyPoint(");
strSql.Append("Name,TID,LON,LAT,RoadType,RoadID,RoadName)");
strSql.Append(" VALUES (");
strSql.Append("@in_Name,@in_TID,@in_LON,@in_LAT,@in_RoadType,@in_RoadID,@in_RoadName)");
SqlParameter[] cmdParms = new SqlParameter[] {
new SqlParameter("@in_Name", SqlDbType.NVarChar),
new SqlParameter("@in_TID", SqlDbType.Int),
new SqlParameter("@in_LON", SqlDbType.Decimal),
new SqlParameter("@in_LAT", SqlDbType.Decimal),
new SqlParameter("@in_RoadType", SqlDbType.NVarChar),
new SqlParameter("@in_RoadID", SqlDbType.Int),
new SqlParameter("@in_RoadName", SqlDbType.NVarChar)
};
cmdParms[0].Value = model.Name;
cmdParms[1].Value = model.TID;
cmdParms[2].Value = model.LON;
cmdParms[3].Value = model.LAT;
cmdParms[4].Value = model.RoadType;
cmdParms[5].Value = model.RoadID;
cmdParms[6].Value = model.RoadName;
return(DbHelperSQL.ExecuteSql(strSql.ToString(), cmdParms));
}
