Access、Sql 获取当前插入的主键ID

  public   int  AddSale(SaleModel model)
        {
             int  id  =   0 ;
             string  query  =   " select @@identity " ;
             string  sqlText  =   string .Format( " insert into Sale(SCount,SumMoney,SUser,SJoinTime,Hide) values ('{0}','{1}','{2}','{3}',0) " , model.SCount, model.SumMoney, model.SUser, model.SJoinTime);
             // LogWrite(sqlText);
            OleDbCommand cmd  =   new  OleDbCommand(sqlText, conn);
            conn.Open();
            cmd.ExecuteNonQuery();
            cmd.CommandText  =  query;
            id  =  ( int )cmd.ExecuteScalar();
            conn.Close();            
             return  id;
        }