public IList<AccountEntity> GetAllAccountByring_id(int t_ring_id)
{
IList<AccountEntity> t_Accounts = new List<AccountEntity>();
OleDbDataReader sdr = null;
using(sdr=OLEDBHelp.GetReader("select * from Account where ring_id="+t_ring_id))
{
while(sdr.Read())
{
AccountEntity t_Account= new AccountEntity();
t_Account.User_id=(int)sdr.GetValue(0);
t_Account.Account=(string)sdr.GetValue(1);
t_Account.Password=(string)sdr.GetValue(2);
t_Account.Ring_id=(int)sdr.GetValue(3);
t_Accounts.Add(t_Account);
}
sdr.Close();
}
return t_Accounts;
}
public static int UpdateAccount(AccountEntity t_Account)
{
int i=-1;
//定义插入数据的参数数组
try
{
i=dal.UpdateAccount(t_Account);
}
catch(Exception ex)
{
throw new Exception(ex.Message);
}
return i;
}
public AccountEntity SelectAccountByID(string t_account)
{
AccountEntity t_Account= new AccountEntity();
OleDbDataReader sdr=null;
using(sdr=OLEDBHelp.GetReader("select * from Account where account="+t_account))
{
if(sdr.Read())
{
t_Account.User_id=(int)sdr.GetValue(0);
t_Account.Account=(string)sdr.GetValue(1);
t_Account.Password=(string)sdr.GetValue(2);
t_Account.Ring_id=(int)sdr.GetValue(3);
}
}
sdr.Close();
return t_Account;
}
public int UpdateAccount(AccountEntity t_Account)
{
OleDbParameter[] p=new OleDbParameter[]{
new OleDbParameter("@User_id",t_Account.User_id),
new OleDbParameter("@Account",t_Account.Account),
new OleDbParameter("@Password",t_Account.Password),
new OleDbParameter("@Ring_id",t_Account.Ring_id)
};
int i=OLEDBHelp.GetExecute("update Account set account=@Account,password=@Password where account=@Account", p) ;
return i;
}
//插入操作
public int InsertAccount(AccountEntity t_Account)
{
//定义插入数据的参数数组
OleDbParameter[] p=new OleDbParameter[]{
new OleDbParameter("@User_id",t_Account.User_id),
new OleDbParameter("@Account",t_Account.Account),
new OleDbParameter("@Password",t_Account.Password),
new OleDbParameter("@Ring_id",t_Account.Ring_id)
};
int i=OLEDBHelp.GetExecute("insert into Account values (@User_id,@Account,@Password,@Ring_id)", p) ;
return i;
}