public int Update(Model.DistanceModel model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update Distance set ");
strSql.Append("Lng=@Lng,Lat=@Lat,Province=@Province,City=@City,District=@District,Address=@Address,StorName=@StorName,Channel=@Channel,CreateTime=@CreateTime,StatusId=@StatusId,Describe=@Describe,Note=@Note ");
strSql.Append(" where Id=@Id ");
SqlParameter[] parameters =
{
new SqlParameter("@Lng", DbTool.FixSqlParameter(model.Lng))
, new SqlParameter("@Lat", DbTool.FixSqlParameter(model.Lat))
, new SqlParameter("@Province", DbTool.FixSqlParameter(model.Province))
, new SqlParameter("@City", DbTool.FixSqlParameter(model.City))
, new SqlParameter("@District", DbTool.FixSqlParameter(model.District))
, new SqlParameter("@Address", DbTool.FixSqlParameter(model.Address))
, new SqlParameter("@StorName", DbTool.FixSqlParameter(model.StorName))
, new SqlParameter("@Channel", DbTool.FixSqlParameter(model.Channel))
, new SqlParameter("@CreateTime", DbTool.FixSqlParameter(model.CreateTime))
, new SqlParameter("@StatusId", DbTool.FixSqlParameter(model.StatusId))
, new SqlParameter("@Describe", DbTool.FixSqlParameter(model.Describe))
, new SqlParameter("@Note", DbTool.FixSqlParameter(model.Note))
, new SqlParameter("@Id", model.Id)
};
return(SqlHelper.ExecuteNonQuery(conn, CommandType.Text, strSql.ToString(), parameters));
}
public int Add(Model.DistanceModel model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into [Distance]");
strSql.Append("(Lng,Lat,Province,City,District,Address,StorName,Channel,CreateTime,StatusId,Describe,Note)");
strSql.Append(" values (@Lng,@Lat,@Province,@City,@District,@Address,@StorName,@Channel,@CreateTime,@StatusId,@Describe,@Note)");
strSql.Append(";select SCOPE_IDENTITY()");
SqlParameter[] parameters =
{
new SqlParameter("@Lng", DbTool.FixSqlParameter(model.Lng))
, new SqlParameter("@Lat", DbTool.FixSqlParameter(model.Lat))
, new SqlParameter("@Province", DbTool.FixSqlParameter(model.Province))
, new SqlParameter("@City", DbTool.FixSqlParameter(model.City))
, new SqlParameter("@District", DbTool.FixSqlParameter(model.District))
, new SqlParameter("@Address", DbTool.FixSqlParameter(model.Address))
, new SqlParameter("@StorName", DbTool.FixSqlParameter(model.StorName))
, new SqlParameter("@Channel", DbTool.FixSqlParameter(model.Channel))
, new SqlParameter("@CreateTime", DbTool.FixSqlParameter(model.CreateTime))
, new SqlParameter("@StatusId", DbTool.FixSqlParameter(model.StatusId))
, new SqlParameter("@Describe", DbTool.FixSqlParameter(model.Describe))
, new SqlParameter("@Note", DbTool.FixSqlParameter(model.Note))
};
return(DbTool.ConvertObject <int>(SqlHelper.ExecuteScalar(conn, CommandType.Text, strSql.ToString(), parameters), 0));
}
protected Model.DistanceModel AutoBindDataReader(SqlDataReader dr, params string[] fields)
{
var model = new Model.DistanceModel();
if (DbTool.HasFields("Id", fields))
{
model.Id = DbTool.ConvertObject <System.Int32>(dr["Id"]);
}
if (DbTool.HasFields("Lng", fields))
{
model.Lng = DbTool.ConvertObject <System.Decimal>(dr["Lng"]);
}
if (DbTool.HasFields("Lat", fields))
{
model.Lat = DbTool.ConvertObject <System.Decimal>(dr["Lat"]);
}
if (DbTool.HasFields("Province", fields))
{
model.Province = DbTool.ConvertObject <System.String>(dr["Province"]);
}
if (DbTool.HasFields("City", fields))
{
model.City = DbTool.ConvertObject <System.String>(dr["City"]);
}
if (DbTool.HasFields("District", fields))
{
model.District = DbTool.ConvertObject <System.String>(dr["District"]);
}
if (DbTool.HasFields("Address", fields))
{
model.Address = DbTool.ConvertObject <System.String>(dr["Address"]);
}
if (DbTool.HasFields("StorName", fields))
{
model.StorName = DbTool.ConvertObject <System.String>(dr["StorName"]);
}
if (DbTool.HasFields("Channel", fields))
{
model.Channel = DbTool.ConvertObject <System.String>(dr["Channel"]);
}
if (DbTool.HasFields("CreateTime", fields))
{
model.CreateTime = DbTool.ConvertObject <System.DateTime>(dr["CreateTime"]);
}
if (DbTool.HasFields("StatusId", fields))
{
model.StatusId = DbTool.ConvertObject <System.Int32>(dr["StatusId"]);
}
if (DbTool.HasFields("Describe", fields))
{
model.Describe = DbTool.ConvertObject <System.String>(dr["Describe"]);
}
if (DbTool.HasFields("Note", fields))
{
model.Note = DbTool.ConvertObject <System.String>(dr["Note"]);
}
return(model);
}
public Model.DistanceModel GetModel(int Id)
{
string sql = "select top 1 * from Distance where Id =" + Id;
Model.DistanceModel model = new Model.DistanceModel();
SqlDataReader dr = SqlHelper.ExecuteReader(conn, CommandType.Text, sql.ToString());
if (dr.Read())
{
//var fields = DbTool.GetReaderFieldNames(dr);
//model = AutoBindDataReader(dr, fields);
BindDataReader(model, dr);
}
dr.Close();
return(model);
}
protected void BindDataReader(Model.DistanceModel model, SqlDataReader dr)
{
model.Id = DbTool.ConvertObject <System.Int32>(dr["Id"]);
model.Lng = DbTool.ConvertObject <System.Decimal>(dr["Lng"]);
model.Lat = DbTool.ConvertObject <System.Decimal>(dr["Lat"]);
model.Province = DbTool.ConvertObject <System.String>(dr["Province"]);
model.City = DbTool.ConvertObject <System.String>(dr["City"]);
model.District = DbTool.ConvertObject <System.String>(dr["District"]);
model.Address = DbTool.ConvertObject <System.String>(dr["Address"]);
model.StorName = DbTool.ConvertObject <System.String>(dr["StorName"]);
model.Channel = DbTool.ConvertObject <System.String>(dr["Channel"]);
model.CreateTime = DbTool.ConvertObject <System.DateTime>(dr["CreateTime"]);
model.StatusId = DbTool.ConvertObject <System.Int32>(dr["StatusId"]);
model.Describe = DbTool.ConvertObject <System.String>(dr["Describe"]);
model.Note = DbTool.ConvertObject <System.String>(dr["Note"]);
}
public int UpdateLngLat(Model.DistanceModel model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update Distance set ");
strSql.Append("Lng=@Lng,Lat=@Lat");
strSql.Append(" where Id=@Id ");
SqlParameter[] parameters =
{
new SqlParameter("@Lng", DbTool.FixSqlParameter(model.Lng))
, new SqlParameter("@Lat", DbTool.FixSqlParameter(model.Lat))
, new SqlParameter("@Id", model.Id)
};
return(SqlHelper.ExecuteNonQuery(conn, CommandType.Text, strSql.ToString(), parameters));
}
public List <Model.DistanceModel> GetModelList(string sqlwhere)
{
List <Model.DistanceModel> result = new List <Model.DistanceModel>();
string sql = "select * from Distance where 1=1 " + sqlwhere;
Model.DistanceModel model = new Model.DistanceModel();
SqlDataReader dr = SqlHelper.ExecuteReader(conn, CommandType.Text, sql.ToString());
//var fields = DbTool.GetReaderFieldNames(dr);
while (dr.Read())
{
//model = AutoBindDataReader(dr, fields);
model = new Model.DistanceModel();
BindDataReader(model, dr);
result.Add(model);
}
dr.Close();
return(result);
}