/// <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));
}
