示例#1
0
 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;
     }
 }
示例#2
0
        /// <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);
            }
        }
示例#3
0
 /// <summary>
 /// 增加一条数据
 /// </summary>
 public int Add(TravelParts model)
 {
     return dal.Add(model);
 }
示例#4
0
 /// <summary>
 /// 更新一条数据
 /// </summary>
 public bool Update(TravelParts model)
 {
     return dal.Update(model);
 }
示例#5
0
 /// <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;
 }
示例#6
0
        /// <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;
            }
        }
示例#7
0
        /// <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;
            }
        }