public string AddTravelPart(FormCollection collection)
{
var travelIdStr = collection.Get("travelId");
var userIdStr = collection.Get("userId");
var partType = collection.Get("partType");
var description = collection.Get("description");
var partUrl = collection.Get("partUrl");
var longitude = collection.Get("longitude");
var latitude = collection.Get("latitude");
var area = collection.Get("address");
if (string.IsNullOrEmpty(userIdStr)) return HttpRequestResult.StateNotNull;
if (string.IsNullOrEmpty(description) && string.IsNullOrEmpty(partUrl))
return HttpRequestResult.StateNotNull;
var model = new TravelParts();
{
model.UserId = Int32.Parse(userIdStr);
if (!string.IsNullOrEmpty(travelIdStr))
{
var travelId = Int32.Parse(travelIdStr);
if (travelId > 0)
{
model.TravelId = travelId;
}
}
model.PartType = Int32.Parse(partType);
model.Description = description;
model.PartUrl = partUrl;
if (!string.IsNullOrEmpty(longitude) && !string.IsNullOrEmpty(latitude))
{
model.Longitude = decimal.Parse(longitude);
model.Latitude = decimal.Parse(latitude);
}
if (!string.IsNullOrEmpty(area)) model.Area = area;
model.CreateTime = DateTime.Now;
model.IsDelete = false;
};
var flag = _travelPartsBll.Add(model);
if (flag > 0)
{
return HttpRequestResult.StateOk;
}
else
{
return HttpRequestResult.StateError;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(TravelParts model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into TravelParts(");
strSql.Append("TravelId,UserId,PartType,Description,PartUrl,Longitude,Latitude,Height,Area,CreateTime,IsDelete)");
strSql.Append(" values (");
strSql.Append("@TravelId,@UserId,@PartType,@Description,@PartUrl,@Longitude,@Latitude,@Height,@Area,@CreateTime,@IsDelete)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@TravelId", SqlDbType.Int,4),
new SqlParameter("@UserId", SqlDbType.Int,4),
new SqlParameter("@PartType", SqlDbType.TinyInt,1),
new SqlParameter("@Description", SqlDbType.VarChar,-1),
new SqlParameter("@PartUrl", SqlDbType.VarChar,100),
new SqlParameter("@Longitude", SqlDbType.Decimal,9),
new SqlParameter("@Latitude", SqlDbType.Decimal,9),
new SqlParameter("@Height", SqlDbType.Decimal,9),
new SqlParameter("@Area", SqlDbType.NVarChar,100),
new SqlParameter("@CreateTime", SqlDbType.DateTime),
new SqlParameter("@IsDelete", SqlDbType.Bit,1)};
parameters[0].Value = model.TravelId;
parameters[1].Value = model.UserId;
parameters[2].Value = model.PartType;
parameters[3].Value = model.Description;
parameters[4].Value = model.PartUrl;
parameters[5].Value = model.Longitude;
parameters[6].Value = model.Latitude;
parameters[7].Value = model.Height;
parameters[8].Value = model.Area;
parameters[9].Value = model.CreateTime;
parameters[10].Value = model.IsDelete;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(TravelParts model)
{
return dal.Add(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(TravelParts model)
{
return dal.Update(model);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public TravelParts DataRowToModel(DataRow row)
{
TravelParts model=new TravelParts();
if (row != null)
{
if(row["Id"]!=null && row["Id"].ToString()!="")
{
model.Id=int.Parse(row["Id"].ToString());
}
if(row["TravelId"]!=DBNull.Value && row["TravelId"].ToString()!="")
{
model.TravelId=int.Parse(row["TravelId"].ToString());
}
if(row["UserId"]!=null && row["UserId"].ToString()!="")
{
model.UserId=int.Parse(row["UserId"].ToString());
}
if(row["PartType"]!=null && row["PartType"].ToString()!="")
{
model.PartType=int.Parse(row["PartType"].ToString());
}
if(row["Description"]!=null)
{
model.Description=row["Description"].ToString();
}
if(row["PartUrl"]!=null)
{
model.PartUrl=row["PartUrl"].ToString();
}
if(row["Longitude"]!=null && row["Longitude"].ToString()!="")
{
model.Longitude=decimal.Parse(row["Longitude"].ToString());
}
if(row["Latitude"]!=null && row["Latitude"].ToString()!="")
{
model.Latitude=decimal.Parse(row["Latitude"].ToString());
}
if(row["Height"]!=null && row["Height"].ToString()!="")
{
model.Height=decimal.Parse(row["Height"].ToString());
}
if(row["Area"]!=null)
{
model.Area=row["Area"].ToString();
}
if(row["CreateTime"]!=null && row["CreateTime"].ToString()!="")
{
model.CreateTime=DateTime.Parse(row["CreateTime"].ToString());
}
if(row["IsDelete"]!=null && row["IsDelete"].ToString()!="")
{
if((row["IsDelete"].ToString()=="1")||(row["IsDelete"].ToString().ToLower()=="true"))
{
model.IsDelete=true;
}
else
{
model.IsDelete=false;
}
}
}
return model;
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(TravelParts model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("update TravelParts set ");
strSql.Append("TravelId=@TravelId,");
strSql.Append("UserId=@UserId,");
strSql.Append("PartType=@PartType,");
strSql.Append("Description=@Description,");
strSql.Append("PartUrl=@PartUrl,");
strSql.Append("Longitude=@Longitude,");
strSql.Append("Latitude=@Latitude,");
strSql.Append("Height=@Height,");
strSql.Append("Area=@Area,");
strSql.Append("CreateTime=@CreateTime,");
strSql.Append("IsDelete=@IsDelete");
strSql.Append(" where Id=@Id");
SqlParameter[] parameters = {
new SqlParameter("@TravelId", SqlDbType.Int,4),
new SqlParameter("@UserId", SqlDbType.Int,4),
new SqlParameter("@PartType", SqlDbType.TinyInt,1),
new SqlParameter("@Description", SqlDbType.VarChar,-1),
new SqlParameter("@PartUrl", SqlDbType.VarChar,100),
new SqlParameter("@Longitude", SqlDbType.Decimal,9),
new SqlParameter("@Latitude", SqlDbType.Decimal,9),
new SqlParameter("@Height", SqlDbType.Decimal,9),
new SqlParameter("@Area", SqlDbType.NVarChar,100),
new SqlParameter("@CreateTime", SqlDbType.DateTime),
new SqlParameter("@IsDelete", SqlDbType.Bit,1),
new SqlParameter("@Id", SqlDbType.Int,4)};
parameters[0].Value = model.TravelId;
parameters[1].Value = model.UserId;
parameters[2].Value = model.PartType;
parameters[3].Value = model.Description;
parameters[4].Value = model.PartUrl;
parameters[5].Value = model.Longitude;
parameters[6].Value = model.Latitude;
parameters[7].Value = model.Height;
parameters[8].Value = model.Area;
parameters[9].Value = model.CreateTime;
parameters[10].Value = model.IsDelete;
parameters[11].Value = model.Id;
int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public TravelParts GetModel(int Id)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("select top 1 Id,TravelId,UserId,PartType,Description,PartUrl,Longitude,Latitude,Height,Area,CreateTime,IsDelete from TravelParts ");
strSql.Append(" where Id=@Id");
SqlParameter[] parameters = {
new SqlParameter("@Id", SqlDbType.Int,4)
};
parameters[0].Value = Id;
TravelParts model=new TravelParts();
DataSet ds=DbHelperSQL.Query(strSql.ToString(),parameters);
if(ds.Tables[0].Rows.Count>0)
{
return DataRowToModel(ds.Tables[0].Rows[0]);
}
else
{
return null;
}
}