/// <summary> /// 更新一条数据 /// </summary> public bool Update(Hch.iDisk.Model.FileList model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update FileList set "); #warning 系统发现缺少更新的字段,请手工确认如此更新是否正确! strSql.Append("FileId=@FileId,"); strSql.Append("ServerId=@ServerId"); strSql.Append(" where FileId=@FileId and ServerId=@ServerId "); SqlParameter[] parameters = { new SqlParameter("@FileId", SqlDbType.VarChar, 130), new SqlParameter("@ServerId", SqlDbType.Int, 4) }; parameters[0].Value = model.FileId; parameters[1].Value = model.ServerId; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Hch.iDisk.Model.FileList GetModel(string FileId, int ServerId) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 FileId,ServerId from FileList "); strSql.Append(" where FileId=@FileId and ServerId=@ServerId "); SqlParameter[] parameters = { new SqlParameter("@FileId", SqlDbType.VarChar, 130), new SqlParameter("@ServerId", SqlDbType.Int, 4) }; parameters[0].Value = FileId; parameters[1].Value = ServerId; Hch.iDisk.Model.FileList model = new Hch.iDisk.Model.FileList(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["FileId"] != null) { model.FileId = ds.Tables[0].Rows[0]["FileId"].ToString(); } if (ds.Tables[0].Rows[0]["ServerId"].ToString() != "") { model.ServerId = int.Parse(ds.Tables[0].Rows[0]["ServerId"].ToString()); } return(model); } else { return(null); } }
/// <summary> /// 增加一条数据 /// </summary> public void Add(Hch.iDisk.Model.FileList model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into FileList("); strSql.Append("FileId,ServerId)"); strSql.Append(" values ("); strSql.Append("@FileId,@ServerId)"); SqlParameter[] parameters = { new SqlParameter("@FileId", SqlDbType.VarChar, 130), new SqlParameter("@ServerId", SqlDbType.Int, 4) }; parameters[0].Value = model.FileId; parameters[1].Value = model.ServerId; DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); }
/// <summary> /// �õ�һ������ʵ�� /// </summary> public Hch.iDisk.Model.FileList GetModel(string FileId,int ServerId) { StringBuilder strSql=new StringBuilder(); strSql.Append("select top 1 FileId,ServerId from FileList "); strSql.Append(" where FileId=@FileId and ServerId=@ServerId "); SqlParameter[] parameters = { new SqlParameter("@FileId", SqlDbType.VarChar,130), new SqlParameter("@ServerId", SqlDbType.Int,4)}; parameters[0].Value = FileId; parameters[1].Value = ServerId; Hch.iDisk.Model.FileList model=new Hch.iDisk.Model.FileList(); DataSet ds=DbHelperSQL.Query(strSql.ToString(),parameters); if(ds.Tables[0].Rows.Count>0) { if(ds.Tables[0].Rows[0]["FileId"]!=null) { model.FileId=ds.Tables[0].Rows[0]["FileId"].ToString(); } if(ds.Tables[0].Rows[0]["ServerId"].ToString()!="") { model.ServerId=int.Parse(ds.Tables[0].Rows[0]["ServerId"].ToString()); } return model; } else { return null; } }