/// <summary> /// 将DataRedar转换为List /// </summary> private List <Data.Model.ReportTemplate> DataReaderToList(SqlDataReader dataReader) { List <Data.Model.ReportTemplate> List = new List <Data.Model.ReportTemplate>(); Data.Model.ReportTemplate model = null; while (dataReader.Read()) { model = new Data.Model.ReportTemplate(); model.ID = dataReader.GetGuid(0); model.Title = dataReader.GetString(1); model.Type = dataReader.GetGuid(2); if (!dataReader.IsDBNull(3)) { model.Html = dataReader.GetString(3); } if (!dataReader.IsDBNull(4)) { model.DesignJSON = dataReader.GetString(4); } if (!dataReader.IsDBNull(5)) { model.UseMember = dataReader.GetString(5); } List.Add(model); } return(List); }
/// <summary> /// 更新记录 /// </summary> /// <param name="model">Data.Model.ReportTemplate实体类</param> public int Update(Data.Model.ReportTemplate model) { string sql = @"UPDATE ReportTemplate SET Title=@Title,Type=@Type,Html=@Html,DesignJSON=@DesignJSON,UseMember=@UseMember WHERE ID=@ID" ; SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@Title", SqlDbType.NVarChar, 510) { Value = model.Title }, new SqlParameter("@Type", SqlDbType.UniqueIdentifier, -1) { Value = model.Type }, model.Html == null ? new SqlParameter("@Html", SqlDbType.Text, -1) { Value = DBNull.Value } : new SqlParameter("@Html", SqlDbType.Text, -1) { Value = model.Html }, model.DesignJSON == null ? new SqlParameter("@DesignJSON", SqlDbType.Text, -1) { Value = DBNull.Value } : new SqlParameter("@DesignJSON", SqlDbType.Text, -1) { Value = model.DesignJSON }, model.UseMember == null ? new SqlParameter("@UseMember", SqlDbType.VarChar, -1) { Value = DBNull.Value } : new SqlParameter("@UseMember", SqlDbType.VarChar, -1) { Value = model.UseMember }, new SqlParameter("@ID", SqlDbType.UniqueIdentifier, -1) { Value = model.ID } }; return(dbHelper.Execute(sql, parameters)); }
/// <summary> /// 添加记录 /// </summary> /// <param name="model">Data.Model.ReportTemplate实体类</param> /// <returns>操作所影响的行数</returns> public int Add(Data.Model.ReportTemplate model) { string sql = @"INSERT INTO ReportTemplate (ID,Title,Type,Html,DesignJSON,UseMember) VALUES(@ID,@Title,@Type,@Html,@DesignJSON,@UseMember)" ; SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@ID", SqlDbType.UniqueIdentifier, -1) { Value = model.ID }, new SqlParameter("@Title", SqlDbType.NVarChar, 510) { Value = model.Title }, new SqlParameter("@Type", SqlDbType.UniqueIdentifier, -1) { Value = model.Type }, model.Html == null ? new SqlParameter("@Html", SqlDbType.Text, -1) { Value = DBNull.Value } : new SqlParameter("@Html", SqlDbType.Text, -1) { Value = model.Html }, model.DesignJSON == null ? new SqlParameter("@DesignJSON", SqlDbType.Text, -1) { Value = DBNull.Value } : new SqlParameter("@DesignJSON", SqlDbType.Text, -1) { Value = model.DesignJSON }, model.UseMember == null ? new SqlParameter("@UseMember", SqlDbType.VarChar, -1) { Value = DBNull.Value } : new SqlParameter("@UseMember", SqlDbType.VarChar, -1) { Value = model.UseMember } }; return(dbHelper.Execute(sql, parameters)); }
/// <summary> /// 更新记录 /// </summary> /// <param name="model">Data.Model.ReportTemplate实体类</param> public int Update(Data.Model.ReportTemplate model) { string sql = @"UPDATE ReportTemplate SET Title=:Title,Type=:Type,Html=:Html,DesignJSON=:DesignJSON,UseMember=:UseMember WHERE ID=:ID" ; OracleParameter[] parameters = new OracleParameter[] { new OracleParameter(":Title", OracleDbType.NVarchar2, 510) { Value = model.Title }, new OracleParameter(":Type", OracleDbType.Char, 36) { Value = model.Type }, model.Html == null ? new OracleParameter(":Html", OracleDbType.Clob) { Value = DBNull.Value } : new OracleParameter(":Html", OracleDbType.Clob) { Value = model.Html }, model.DesignJSON == null ? new OracleParameter(":DesignJSON", OracleDbType.Clob) { Value = DBNull.Value } : new OracleParameter(":DesignJSON", OracleDbType.Clob) { Value = model.DesignJSON }, model.UseMember == null ? new OracleParameter(":UseMember", OracleDbType.Clob) { Value = DBNull.Value } : new OracleParameter(":UseMember", OracleDbType.Clob) { Value = model.UseMember }, new OracleParameter(":ID", OracleDbType.Char, 36) { Value = model.ID } }; return(dbHelper.Execute(sql, parameters)); }
/// <summary> /// 添加记录 /// </summary> /// <param name="model">Data.Model.ReportTemplate实体类</param> /// <returns>操作所影响的行数</returns> public int Add(Data.Model.ReportTemplate model) { string sql = @"INSERT INTO ReportTemplate (ID,Title,Type,Html,DesignJSON,UseMember) VALUES(:ID,:Title,:Type,:Html,:DesignJSON,:UseMember)" ; OracleParameter[] parameters = new OracleParameter[] { new OracleParameter(":ID", OracleDbType.Char, 36) { Value = model.ID }, new OracleParameter(":Title", OracleDbType.NVarchar2, 510) { Value = model.Title }, new OracleParameter(":Type", OracleDbType.Char, 36) { Value = model.Type }, model.Html == null ? new OracleParameter(":Html", OracleDbType.Clob) { Value = DBNull.Value } : new OracleParameter(":Html", OracleDbType.Clob) { Value = model.Html }, model.DesignJSON == null ? new OracleParameter(":DesignJSON", OracleDbType.Clob) { Value = DBNull.Value } : new OracleParameter(":DesignJSON", OracleDbType.Clob) { Value = model.DesignJSON }, model.UseMember == null ? new OracleParameter(":UseMember", OracleDbType.Clob) { Value = DBNull.Value } : new OracleParameter(":UseMember", OracleDbType.Clob) { Value = model.UseMember } }; return(dbHelper.Execute(sql, parameters)); }