public List<JifenChange> GetByQQAndType(string qq,JifenChangeType type)
{
string str = "select * from T_JifenChange where QQ='" + qq + "' and Type="+(int)type ;
DataTable dt = _DBbase.ExeSelect(str);
List<JifenChange> users = new List<JifenChange>();
foreach (DataRow dr in dt.Rows)
{
users.Add(this.GetEntity(dr));
}
return users;
}
public void Add(string qq, int amount, JifenChangeType type, bool isAdd,string fromqq)
{
string sql = "insert into T_JifenChange ([QQ],[Amount],[IsAdd],[Type],[Time],[FromQQ]) values ('" + qq + "'," + amount + "," + isAdd + "," + (int)type + ",'" + DateTime.Now + "','"+fromqq+"')";
_DBbase.ExecuteCommand(sql);
}
