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