public List<AndroidEntity> GetByPaged(AndroidEntity android, PagerCondition pagerCondition)
{
try
{
pagerCondition.SelectFields = "ID,UserName,State";
System.Data.Common.DbCommand cmd = db.GetStoredProcCommand("pagination");
db.AddInParameter(cmd, "tblName", DbType.String, tableName);
db.AddInParameter(cmd, "strGetFields", DbType.String, pagerCondition.SelectFields);
db.AddInParameter(cmd, "fldName", DbType.String, pagerCondition.SortField);//排序字段名
db.AddInParameter(cmd, "PageSize", DbType.Int32, pagerCondition.PageSize);
db.AddInParameter(cmd, "PageIndex", DbType.Int32, pagerCondition.PageIndex);
db.AddInParameter(cmd, "doCount", DbType.Byte, pagerCondition.doCount);
db.AddInParameter(cmd, "OrderType", DbType.Byte, pagerCondition.SortType);
db.AddInParameter(cmd, "strWhere", DbType.String, pagerCondition.StrWhere);
List<AndroidEntity> list = new List<AndroidEntity>();
string[] fields = pagerCondition.SelectFields.Split(new char[1] { ',' });
using (IDataReader reader = db.ExecuteReader(cmd))
{
while (reader.Read())
{
list.Add(new AndroidEntity
{
ID = Convert.ToInt32(reader[0]),
UserName = reader[1].ToString(),
State = Convert.ToByte(reader[2])
});
}
reader.Close();
reader.Dispose();
}
return list;
}
catch (Exception ex)
{
throw new DalException("系统异常！", ex);
}
}
public int Update(AndroidEntity android)
{
return 0;
}
public int Delete(AndroidEntity android)
{
return 0;
}
public int Insert(AndroidEntity android)
{
try
{
string sql = "insert into " + tableName + "([UserName],[State]) values(@userName,@state)";
System.Data.Common.DbCommand cmd = db.GetSqlStringCommand(sql);
db.AddInParameter(cmd, "userName", DbType.String, android.UserName);
db.AddInParameter(cmd, "state", DbType.Byte, android.State);
int result = db.ExecuteNonQuery(cmd);
return result;
}
catch (Exception ex)
{
throw new DalException("系统异常！", ex);
}
}
