/// <summary> /// 更新一条数据 /// </summary> public bool Update(AMS.Model.View_FileSharingInfo model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update View_FileSharingInfo set "); strSql.Append("Id=@Id,"); strSql.Append("Name=@Name,"); strSql.Append("Remark=@Remark,"); strSql.Append("FileType=@FileType,"); strSql.Append("UpManID=@UpManID,"); strSql.Append("FilePath=@FilePath,"); strSql.Append("DownLoadCount=@DownLoadCount,"); strSql.Append("UserID=@UserID,"); strSql.Append("LoginId=@LoginId,"); strSql.Append("UserName=@UserName,"); strSql.Append("BranchName=@BranchName"); strSql.Append(" where "); SqlParameter[] parameters = { new SqlParameter("@Id", SqlDbType.Int, 4), new SqlParameter("@Name", SqlDbType.NVarChar, 300), new SqlParameter("@Remark", SqlDbType.NVarChar, 300), new SqlParameter("@FileType", SqlDbType.Int, 4), new SqlParameter("@UpManID", SqlDbType.Int, 4), new SqlParameter("@FilePath", SqlDbType.NVarChar, 300), new SqlParameter("@DownLoadCount", SqlDbType.Int, 4), new SqlParameter("@UserID", SqlDbType.Int, 4), new SqlParameter("@LoginId", SqlDbType.NVarChar, 30), new SqlParameter("@UserName", SqlDbType.NVarChar, 30), new SqlParameter("@BranchName", SqlDbType.NVarChar, 30) }; parameters[0].Value = model.Id; parameters[1].Value = model.Name; parameters[2].Value = model.Remark; parameters[3].Value = model.FileType; parameters[4].Value = model.UpManID; parameters[5].Value = model.FilePath; parameters[6].Value = model.DownLoadCount; parameters[7].Value = model.UserID; parameters[8].Value = model.LoginId; parameters[9].Value = model.UserName; parameters[10].Value = model.BranchName; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(AMS.Model.View_FileSharingInfo model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into View_FileSharingInfo("); strSql.Append("Id,Name,Remark,FileType,UpManID,FilePath,DownLoadCount,UserID,LoginId,UserName,BranchName)"); strSql.Append(" values ("); strSql.Append("@Id,@Name,@Remark,@FileType,@UpManID,@FilePath,@DownLoadCount,@UserID,@LoginId,@UserName,@BranchName)"); SqlParameter[] parameters = { new SqlParameter("@Id", SqlDbType.Int, 4), new SqlParameter("@Name", SqlDbType.NVarChar, 300), new SqlParameter("@Remark", SqlDbType.NVarChar, 300), new SqlParameter("@FileType", SqlDbType.Int, 4), new SqlParameter("@UpManID", SqlDbType.Int, 4), new SqlParameter("@FilePath", SqlDbType.NVarChar, 300), new SqlParameter("@DownLoadCount", SqlDbType.Int, 4), new SqlParameter("@UserID", SqlDbType.Int, 4), new SqlParameter("@LoginId", SqlDbType.NVarChar, 30), new SqlParameter("@UserName", SqlDbType.NVarChar, 30), new SqlParameter("@BranchName", SqlDbType.NVarChar, 30) }; parameters[0].Value = model.Id; parameters[1].Value = model.Name; parameters[2].Value = model.Remark; parameters[3].Value = model.FileType; parameters[4].Value = model.UpManID; parameters[5].Value = model.FilePath; parameters[6].Value = model.DownLoadCount; parameters[7].Value = model.UserID; parameters[8].Value = model.LoginId; parameters[9].Value = model.UserName; parameters[10].Value = model.BranchName; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public AMS.Model.View_FileSharingInfo GetModel() { //该表无主键信息,请自定义主键/条件字段 StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 Id,Name,Remark,FileType,UpManID,FilePath,DownLoadCount,UserID,LoginId,UserName,BranchName,Size from View_FileSharingInfo "); strSql.Append(" where "); SqlParameter[] parameters = { }; AMS.Model.View_FileSharingInfo model = new AMS.Model.View_FileSharingInfo(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["Id"] != null && ds.Tables[0].Rows[0]["Id"].ToString() != "") { model.Id = int.Parse(ds.Tables[0].Rows[0]["Id"].ToString()); } if (ds.Tables[0].Rows[0]["Name"] != null && ds.Tables[0].Rows[0]["Name"].ToString() != "") { model.Name = ds.Tables[0].Rows[0]["Name"].ToString(); } if (ds.Tables[0].Rows[0]["Remark"] != null && ds.Tables[0].Rows[0]["Remark"].ToString() != "") { model.Remark = ds.Tables[0].Rows[0]["Remark"].ToString(); } if (ds.Tables[0].Rows[0]["FileType"] != null && ds.Tables[0].Rows[0]["FileType"].ToString() != "") { model.FileType = int.Parse(ds.Tables[0].Rows[0]["FileType"].ToString()); } if (ds.Tables[0].Rows[0]["UpManID"] != null && ds.Tables[0].Rows[0]["UpManID"].ToString() != "") { model.UpManID = int.Parse(ds.Tables[0].Rows[0]["UpManID"].ToString()); } if (ds.Tables[0].Rows[0]["FilePath"] != null && ds.Tables[0].Rows[0]["FilePath"].ToString() != "") { model.FilePath = ds.Tables[0].Rows[0]["FilePath"].ToString(); } if (ds.Tables[0].Rows[0]["DownLoadCount"] != null && ds.Tables[0].Rows[0]["DownLoadCount"].ToString() != "") { model.DownLoadCount = int.Parse(ds.Tables[0].Rows[0]["DownLoadCount"].ToString()); } if (ds.Tables[0].Rows[0]["UserID"] != null && ds.Tables[0].Rows[0]["UserID"].ToString() != "") { model.UserID = int.Parse(ds.Tables[0].Rows[0]["UserID"].ToString()); } if (ds.Tables[0].Rows[0]["LoginId"] != null && ds.Tables[0].Rows[0]["LoginId"].ToString() != "") { model.LoginId = ds.Tables[0].Rows[0]["LoginId"].ToString(); } if (ds.Tables[0].Rows[0]["UserName"] != null && ds.Tables[0].Rows[0]["UserName"].ToString() != "") { model.UserName = ds.Tables[0].Rows[0]["UserName"].ToString(); } if (ds.Tables[0].Rows[0]["BranchName"] != null && ds.Tables[0].Rows[0]["BranchName"].ToString() != "") { model.BranchName = ds.Tables[0].Rows[0]["BranchName"].ToString(); } return(model); } else { return(null); } }