/// <summary> /// 增加一条数据 /// </summary> public void Add(Hch.iDisk.Model.File model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into [File]("); strSql.Append("FId,DirId,FName,FDate,FSize,FVisibility,FUrl,FDesc,FUserId)"); strSql.Append(" values ("); strSql.Append("@FId,@DirId,@FName,@FDate,@FSize,@FVisibility,@FUrl,@FDesc,@FUserId)"); SqlParameter[] parameters = { new SqlParameter("@FId", SqlDbType.VarChar, 130), new SqlParameter("@DirId", SqlDbType.Int, 4), new SqlParameter("@FName", SqlDbType.VarChar, 50), new SqlParameter("@FDate", SqlDbType.DateTime), new SqlParameter("@FSize", SqlDbType.BigInt, 8), new SqlParameter("@FVisibility", SqlDbType.Int, 4), new SqlParameter("@FUrl", SqlDbType.VarChar, 200), new SqlParameter("@FDesc", SqlDbType.VarChar, 100), new SqlParameter("@FUserId", SqlDbType.Int, 4) }; parameters[0].Value = model.FId; parameters[1].Value = model.DirId; parameters[2].Value = model.FName; parameters[3].Value = model.FDate; parameters[4].Value = model.FSize; parameters[5].Value = model.FVisibility; parameters[6].Value = model.FUrl; parameters[7].Value = model.FDesc; parameters[8].Value = model.FUserId; DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Hch.iDisk.Model.File model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update [File] set "); strSql.Append("DirId=@DirId,"); strSql.Append("FName=@FName,"); strSql.Append("FDate=@FDate,"); strSql.Append("FSize=@FSize,"); strSql.Append("FVisibility=@FVisibility,"); strSql.Append("FUrl=@FUrl,"); strSql.Append("FDesc=@FDesc"); strSql.Append(" where FId=@FId and FUserId=@FUserId "); SqlParameter[] parameters = { new SqlParameter("@DirId", SqlDbType.Int, 4), new SqlParameter("@FName", SqlDbType.VarChar, 50), new SqlParameter("@FDate", SqlDbType.DateTime), new SqlParameter("@FSize", SqlDbType.BigInt, 8), new SqlParameter("@FVisibility", SqlDbType.Int, 4), new SqlParameter("@FUrl", SqlDbType.VarChar, 200), new SqlParameter("@FDesc", SqlDbType.VarChar, 100), new SqlParameter("@FId", SqlDbType.VarChar, 130), new SqlParameter("@FUserId", SqlDbType.Int, 4) }; parameters[0].Value = model.DirId; parameters[1].Value = model.FName; parameters[2].Value = model.FDate; parameters[3].Value = model.FSize; parameters[4].Value = model.FVisibility; parameters[5].Value = model.FUrl; parameters[6].Value = model.FDesc; parameters[7].Value = model.FId; parameters[8].Value = model.FUserId; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Hch.iDisk.Model.File GetModel(string FId, int FUserId) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 FId,DirId,FName,FDate,FSize,FVisibility,FUrl,FDesc,FUserId from File "); strSql.Append(" where FId=@FId and FUserId=@FUserId "); SqlParameter[] parameters = { new SqlParameter("@FId", SqlDbType.VarChar, 130), new SqlParameter("@FUserId", SqlDbType.Int, 4) }; parameters[0].Value = FId; parameters[1].Value = FUserId; Hch.iDisk.Model.File model = new Hch.iDisk.Model.File(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["FId"] != null) { model.FId = ds.Tables[0].Rows[0]["FId"].ToString(); } if (ds.Tables[0].Rows[0]["DirId"].ToString() != "") { model.DirId = int.Parse(ds.Tables[0].Rows[0]["DirId"].ToString()); } if (ds.Tables[0].Rows[0]["FName"] != null) { model.FName = ds.Tables[0].Rows[0]["FName"].ToString(); } if (ds.Tables[0].Rows[0]["FDate"].ToString() != "") { model.FDate = DateTime.Parse(ds.Tables[0].Rows[0]["FDate"].ToString()); } if (ds.Tables[0].Rows[0]["FSize"].ToString() != "") { model.FSize = long.Parse(ds.Tables[0].Rows[0]["FSize"].ToString()); } if (ds.Tables[0].Rows[0]["FVisibility"].ToString() != "") { model.FVisibility = int.Parse(ds.Tables[0].Rows[0]["FVisibility"].ToString()); } if (ds.Tables[0].Rows[0]["FUrl"].ToString() != "") { model.FUrl = ds.Tables[0].Rows[0]["FUrl"].ToString(); } if (ds.Tables[0].Rows[0]["FDesc"] != null) { model.FDesc = ds.Tables[0].Rows[0]["FDesc"].ToString(); } if (ds.Tables[0].Rows[0]["FUserId"].ToString() != "") { model.FUserId = int.Parse(ds.Tables[0].Rows[0]["FUserId"].ToString()); } return(model); } else { return(null); } }