/// <summary>
/// 新增
/// </summary>
/// <param name="flowAuthRoleEntity"></param>
/// <returns></returns>
public bool AddFlowAuthRole(FlowAuthRoleEntity flowAuthRoleEntity)
{
bool flag = false;
StringBuilder sqlCommandText = new StringBuilder();
sqlCommandText.Append(" @JournalID");
sqlCommandText.Append(", @ActionID");
sqlCommandText.Append(", @RoleID");
DbCommand cmd = db.GetSqlStringCommand(String.Format("INSERT INTO dbo.FlowAuthRole ({0}) VALUES ({1})", sqlCommandText.ToString().Replace("@", ""), sqlCommandText.ToString()));
db.AddInParameter(cmd, "@JournalID", DbType.Int64, flowAuthRoleEntity.JournalID);
db.AddInParameter(cmd, "@ActionID", DbType.Int64, flowAuthRoleEntity.ActionID);
db.AddInParameter(cmd, "@RoleID", DbType.Int64, flowAuthRoleEntity.RoleID);
try
{
db.ExecuteNonQuery(cmd);
flag = true;
}
catch (SqlException sqlEx)
{
throw sqlEx;
}
return flag;
}
public FlowAuthRoleEntity MakeFlowAuthRole(DataRow dr)
{
FlowAuthRoleEntity flowAuthRoleEntity=null;
if(dr!=null)
{
flowAuthRoleEntity=new FlowAuthRoleEntity();
flowAuthRoleEntity.RoleAuthID = (Int64)dr["RoleAuthID"];
flowAuthRoleEntity.JournalID = (Int64)dr["JournalID"];
flowAuthRoleEntity.ActionID = (Int64)dr["ActionID"];
flowAuthRoleEntity.RoleID = (Int64)dr["RoleID"];
flowAuthRoleEntity.AddDate = (DateTime)dr["AddDate"];
}
return flowAuthRoleEntity;
}
public List<FlowAuthRoleEntity> MakeFlowAuthRoleList(IDataReader dr)
{
List<FlowAuthRoleEntity> list = new List<FlowAuthRoleEntity>();
while (dr.Read())
{
FlowAuthRoleEntity flowAuthRoleEntity = new FlowAuthRoleEntity();
flowAuthRoleEntity.RoleAuthID = (Int64)dr["RoleAuthID"];
flowAuthRoleEntity.JournalID = (Int64)dr["JournalID"];
flowAuthRoleEntity.ActionID = (Int64)dr["ActionID"];
flowAuthRoleEntity.RoleID = (Int64)dr["RoleID"];
flowAuthRoleEntity.AddDate = (DateTime)dr["AddDate"];
list.Add(flowAuthRoleEntity);
}
dr.Close();
return list;
}
/// <summary>
/// 新增
/// </summary>
/// <param name="flowAuthRoleEntity"></param>
/// <returns></returns>
public bool AddFlowAuthRole(FlowAuthRoleEntity flowAuthRoleEntity)
{
return FlowAuthRoleDataAccess.Instance.AddFlowAuthRole(flowAuthRoleEntity);
}