/// <summary>
/// GetList 获取数据集
/// </summary>
/// <param name="dataParams">dataParams 查询参数</param>
/// <returns>返回 数据集</returns>
public IList <Os.Brain.iBxg.Core.Entity.BankList> GetList(params DbParameter[] dataParams)
{
if (DataActions.select != this.Action)
{
return(null);
}
IList <Os.Brain.iBxg.Core.Entity.BankList> returnList = new List <Os.Brain.iBxg.Core.Entity.BankList>();
Os.Brain.iBxg.Core.Entity.BankList _model = null;
Database db = DatabaseFactory.CreateDatabase(Os.Brain.iBxg.Core.Entity.BankList.CONN);
DbCommand dbc = db.GetStoredProcCommand("BankList_Get");
if (null != dataParams)
{
dbc.Parameters.AddRange(dataParams);
}
using (IDataReader dr = db.ExecuteReader(dbc))
{
while (dr.Read())
{
_model = new Os.Brain.iBxg.Core.Entity.BankList();
LoadFromReader(dr, _model);
returnList.Add(_model);
}
}
return(returnList);
}
/// <summary>
/// GetItem 获取单个实体
/// </summary>
/// <param name="ids">ids 主键值</param>
/// <returns>返回 空或实体</returns>
public Os.Brain.iBxg.Core.Entity.BankList GetItem(string ids)
{
#region DEBUG
Debug.WriteLine(string.Format(TSQL.DEBUG_START_LINE, "Os.Brain.iBxg.Core.Dal.GetItem START"));
Debug.WriteLine(string.Format(TSQL.SELECT_ITEM, "[dbo].[BankList]", "[BankList_Ids]", "@BankList_Ids"));
Debug.WriteLine(string.Format(TSQL.DEBUG_END_LINE, "Os.Brain.iBxg.Core.Dal.GetItem END"));
#endregion
if (DataActions.select != this.Action)
{
return(null);
}
Os.Brain.iBxg.Core.Entity.BankList _model = null;
Database db = DatabaseFactory.CreateDatabase(Os.Brain.iBxg.Core.Entity.BankList.CONN);
DbCommand dbc = db.GetSqlStringCommand(string.Format(TSQL.SELECT_ITEM, "[dbo].[BankList]", "[BankList_Ids]", "@BankList_Ids"));
db.AddInParameter(dbc, "@BankList_Ids", DbType.Int32, ids);
using (IDataReader dr = db.ExecuteReader(dbc))
{
if (dr.Read())
{
_model = new Os.Brain.iBxg.Core.Entity.BankList();
LoadFromReader(dr, _model);
}
}
return(_model);
}
protected void LoadFromReader1(IDataReader dr, Os.Brain.iBxg.Core.Entity.BankList model)
{
if (dr != null && !dr.IsClosed)
{
model.BankList_Ids = (int)dr["BankList_Ids"];
model.BankList_UserId = dr["BankList_UserId"].ToString();
model.BankList_Orders = dr["BankList_Orders"].ToString();
model.BankList_Balance1 = Convert.ToDecimal(dr["BankList_Balance1"]);
model.BankList_AvailAmount1 = Convert.ToDecimal(dr["BankList_AvailAmount1"]);
model.BankList_FrozenAmount1 = Convert.ToDecimal(dr["BankList_FrozenAmount1"]);
model.BankList_Balance2 = Convert.ToDecimal(dr["BankList_Balance2"]);
model.BankList_AvailAmount2 = Convert.ToDecimal(dr["BankList_AvailAmount2"]);
model.BankList_FrozenAmount2 = Convert.ToDecimal(dr["BankList_FrozenAmount2"]);
model.BankList_Money = Convert.ToDecimal(dr["BankList_Money"]);
model.BankList_InMoney = Convert.ToDecimal(dr["BankList_InMoney"]);
model.BankList_OutMoney = Convert.ToDecimal(dr["BankList_OutMoney"]);
model.BankList_IntFrozenMoney = Convert.ToDecimal(dr["BankList_IntFrozenMoney"]);
model.BankList_OutFrozenMoney = Convert.ToDecimal(dr["BankList_OutFrozenMoney"]);
model.BankList_DaiLianMoney = Convert.ToDecimal(dr["BankList_DaiLianMoney"]);
model.BankList_Types = (int)dr["BankList_Types"];
model.BankList_DoUser = dr["BankList_DoUser"].ToString();
model.BankList_AddTime = (DateTime)dr["BankList_AddTime"];
model.BankList_Remark = dr["BankList_Remark"].ToString();
model.BankList_Field1 = dr["BankList_Field1"].ToString();
model.BankList_Field2 = dr["BankList_Field2"].ToString();
model.BankList_Field3 = dr["BankList_Field3"].ToString();
model.BankList_Field4 = dr["BankList_Field4"].ToString();
model.BankList_Field5 = dr["BankList_Field5"].ToString();
model.BankList_Field6 = dr["BankList_Field6"].ToString();
model.BankList_Field7 = dr["BankList_Field7"].ToString();
model.BankList_Field8 = dr["BankList_Field8"].ToString();
model.BankList_Field9 = dr["BankList_Field9"].ToString();
}
}
/// <summary>
/// Edit 编辑（新增，修改）一条数据
/// </summary>
/// <param name="model">model 实体</param>
/// <returns>返回 实体主键</returns>
public object Edit(Os.Brain.iBxg.Core.Entity.BankList model)
{
if (DataActions.insert == this.Action)
{
return(model.Insert());
}
if (DataActions.update == this.Action)
{
return(model.Update());
}
if (DataActions.delete == this.Action)
{
return(model.Delete());
}
return(null);
}
/// <summary>
/// GetList 获取分页数据集
/// </summary>
/// <param name="pageSize">pageSize 每页条数</param>
/// <param name="currPage">currPage 当前页码</param>
/// <param name="recordCount">recordCount 总记录数</param>
/// <param name="dataParams">dataParams 查询参数</param>
/// <returns>返回 数据集</returns>
public IList <Os.Brain.iBxg.Core.Entity.BankList> GetList(int pageSize, int currPage, out int recordCount, params DbParameter[] dataParams)
{
recordCount = 0;
if (DataActions.select != this.Action)
{
return(null);
}
IList <Os.Brain.iBxg.Core.Entity.BankList> returnList = new List <Os.Brain.iBxg.Core.Entity.BankList>();
Os.Brain.iBxg.Core.Entity.BankList _model = null;
Database db = DatabaseFactory.CreateDatabase(Os.Brain.iBxg.Core.Entity.BankList.CONN);
DbCommand dbc = db.GetStoredProcCommand("BankList_Get");
if (null != dataParams)
{
dbc.Parameters.AddRange(dataParams);
}
db.AddInParameter(dbc, "@PageIndex", DbType.Int32, currPage);
db.AddInParameter(dbc, "@PageSize", DbType.Int32, pageSize);
db.AddOutParameter(dbc, "@RecordCount", DbType.Int32, 4);
using (IDataReader dr = db.ExecuteReader(dbc))
{
while (dr.Read())
{
_model = new Os.Brain.iBxg.Core.Entity.BankList();
LoadFromReader(dr, _model);
returnList.Add(_model);
}
}
recordCount = (int)dbc.Parameters["@RecordCount"].Value;
return(returnList);
}
protected void LoadFromReader(IDataReader dr, Os.Brain.iBxg.Core.Entity.BankList model)
{
if (dr != null && !dr.IsClosed)
{
if (!dr.IsDBNull(0))
{
model.BankList_Ids = dr.GetInt32(0);
}
if (!dr.IsDBNull(1))
{
model.BankList_UserId = dr.GetString(1);
}
if (!dr.IsDBNull(2))
{
model.BankList_Orders = dr.GetString(2);
}
if (!dr.IsDBNull(3))
{
model.BankList_Balance1 = dr.GetDecimal(3);
}
if (!dr.IsDBNull(4))
{
model.BankList_AvailAmount1 = dr.GetDecimal(4);
}
if (!dr.IsDBNull(5))
{
model.BankList_FrozenAmount1 = dr.GetDecimal(5);
}
if (!dr.IsDBNull(6))
{
model.BankList_Balance2 = dr.GetDecimal(6);
}
if (!dr.IsDBNull(7))
{
model.BankList_AvailAmount2 = dr.GetDecimal(7);
}
if (!dr.IsDBNull(8))
{
model.BankList_FrozenAmount2 = dr.GetDecimal(8);
}
if (!dr.IsDBNull(9))
{
model.BankList_Money = dr.GetDecimal(9);
}
if (!dr.IsDBNull(10))
{
model.BankList_InMoney = dr.GetDecimal(10);
}
if (!dr.IsDBNull(11))
{
model.BankList_OutMoney = dr.GetDecimal(11);
}
if (!dr.IsDBNull(12))
{
model.BankList_IntFrozenMoney = dr.GetDecimal(12);
}
if (!dr.IsDBNull(13))
{
model.BankList_OutFrozenMoney = dr.GetDecimal(13);
}
if (!dr.IsDBNull(14))
{
model.BankList_DaiLianMoney = dr.GetDecimal(14);
}
if (!dr.IsDBNull(15))
{
model.BankList_Types = dr.GetInt32(15);
}
if (!dr.IsDBNull(16))
{
model.BankList_DoUser = dr.GetString(16);
}
if (!dr.IsDBNull(17))
{
model.BankList_AddTime = dr.GetDateTime(17);
}
if (!dr.IsDBNull(18))
{
model.BankList_Remark = dr.GetString(18);
}
if (!dr.IsDBNull(19))
{
model.BankList_Field1 = dr.GetString(19);
}
if (!dr.IsDBNull(20))
{
model.BankList_Field2 = dr.GetString(20);
}
if (!dr.IsDBNull(21))
{
model.BankList_Field3 = dr.GetString(21);
}
if (!dr.IsDBNull(22))
{
model.BankList_Field4 = dr.GetString(22);
}
if (!dr.IsDBNull(23))
{
model.BankList_Field5 = dr.GetString(23);
}
if (!dr.IsDBNull(24))
{
model.BankList_Field6 = dr.GetString(24);
}
if (!dr.IsDBNull(25))
{
model.BankList_Field7 = dr.GetString(25);
}
if (!dr.IsDBNull(26))
{
model.BankList_Field8 = dr.GetString(26);
}
if (!dr.IsDBNull(27))
{
model.BankList_Field9 = dr.GetString(27);
}
}
}
/// <summary>
/// Edit 编辑（新增，修改）一条数据
/// </summary>
/// <param name="model">model 实体</param>
/// <returns>returns 实体主键</returns>
public object Edit(Os.Brain.iBxg.Core.Entity.BankList model)
{
return(this.dal.Edit(model));
}
