/*
/// <summary>
/// ��ҳ��ȡ�����б�
/// </summary>
public DataSet GetList(int PageSize,int PageIndex,string strWhere)
{
MySqlParameter[] parameters = {
new MySqlParameter("@tblName", MySqlDbType.VarChar, 255),
new MySqlParameter("@fldName", MySqlDbType.VarChar, 255),
new MySqlParameter("@PageSize", MySqlDbType.Int32),
new MySqlParameter("@PageIndex", MySqlDbType.Int32),
new MySqlParameter("@IsReCount", MySqlDbType.Bit),
new MySqlParameter("@OrderType", MySqlDbType.Bit),
new MySqlParameter("@strWhere", MySqlDbType.VarChar,1000),
};
parameters[0].Value = "package_type";
parameters[1].Value = "ID";
parameters[2].Value = PageSize;
parameters[3].Value = PageIndex;
parameters[4].Value = 0;
parameters[5].Value = 0;
parameters[6].Value = strWhere;
return DBHelper.RunProcedure("UP_GetRecordByPage",parameters,"ds");
}*/
public IList<AutoBwsModel.Credit.package_type> GetPackageTypeList()
{
IList<AutoBwsModel.Credit.package_type> list = new List<AutoBwsModel.Credit.package_type>();
DataSet ds = this.GetList("");
foreach (DataRow r in ds.Tables[0].Rows)
{
AutoBwsModel.Credit.package_type model = new AutoBwsModel.Credit.package_type();
SetModel(r, ref model);
list.Add(model);
}
return list;
}
/// <summary>
/// �õ�һ������ʵ��
/// </summary>
public AutoBwsModel.Credit.package_type GetModel(int id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select * from package_type ");
strSql.Append(" where id=@id ");
MySqlParameter[] parameters = {
new MySqlParameter("@id", MySqlDbType.Int32)
};
parameters[0].Value = id;
AutoBwsModel.Credit.package_type model = new AutoBwsModel.Credit.package_type();
DataSet ds = DBHelper.ExecuteDataset(con, CommandType.Text, strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["id"].ToString() != "")
{
model.id = int.Parse(ds.Tables[0].Rows[0]["id"].ToString());
}
model.remark = ds.Tables[0].Rows[0]["remark"].ToString();
model.name = ds.Tables[0].Rows[0]["name"].ToString();
// model.credit_count = ds.Tables[0].Rows[0]["name"].ToString();
model.credit_count = Convert.ToInt32(ds.Tables[0].Rows[0]["credit_count"].ToString());
model.level = Convert.ToInt32(ds.Tables[0].Rows[0]["level"].ToString());
return model;
}
else
{
return null;
}
}